AA Install SQL from Command Line.txt
AA Install SQL from Command Line2.txt
AD Access Identification.sql
Add Email Notification For Failed SQL Server Agent Jobs.sql
Add Gmail as Database Mail Account.sql
Add SQL Agent Operate and Assign it to All Jobs for Failure.sql
Add User to Azure Database and Add Role Membership.sql
Alter Database Logical File Names.sql
Attach DB File Without Log File.sql
Attach database using Create Database.sql
Azure SQL Database Resoruce Metrics.sql
AzureSQLdatabase_UpdateFirewallRule.sql
AzureSQLdatabase_UpdateFirewallRule_2.sql
Azure_Database_Firewall_Script.sql
Azure_Firewall_Script.sql
BCP out and in dynamic statement.sql
Build Comma Seperated Column and Query.sql
Cached Exec Plan Query.sql
Check Azure SQL DB User Role and Role Permissions.sql
Check Database Mail Configuration.sql
Check Free Space And Truncate.sql
Check If The Latest Backup File Exist.sql
Check SQL Server Replication Jobs.sql
CheckPoint Free Proc Cache Clean Buffers.sql
Collect Index Usage Statistics.sql
Comma Seperate Mutiple Rows.sql
Configure Database Mail.sql
Convert Int to Time Function.sql
Create Credential and SSIS Proxy.sql
Create Database Mail Account And Profile.sql
Create Database Mail Profile and Account.sql
Create Database With Multiple File Groups.sql
Create Dynamic Database SnapShot Daily.sql
Create Dynamic Database SnapShot In Minutes.sql
Create Extended Event Session 24HourDataCapture.sql
Create Function DelimitedSplit8K For Splitting Comma Sepeprated Parameters.sql
Create Function to Parse String.sql
Create Linked Server to Azure Database.sql
Create ProcExec Role and Grant Execution Select on Objects.sql
Create Proxy for PowerShell.sql
Create SQL Login With SID.sql
Create SQL Server Alerts.sql
Create SSIS Proxy Account.sql
Create User for Azure SQL Database.sql
Create or Drop All PKs.sql
Create ssb_azure_dba for Azure SQL Database.sql
Create_red-gate_monitor_user.sql
DBA Backup System Databases Script.sql
DBCC CheckDB for All DBs.sql
Days Since the Job Run.sql
Delete Duplicate Rows With CTE.sql
DetermineIndexCostBenefits.sql
Drop Clean Buffers and Free Proc Cache.sql
Drop Procs Functions Schemas.sql
Drop Restored Copy of Replicated Database.sql
Drop Server Name and Add Builtin Admin Group To SysAdmin.sql
Drop Views and Tables.sql
DropConstraintDynamic.sql
DropCopyandCreatSubscription.sql
Dynamic Database Restore.sql
Dynamic Drop and Create FK statement.sql
Dynamic Restore with Case From Linked Server.sql
Dynamic Restore with Case.sql
Dynamic Stored Procedure Where Clause.sql
Dynamically Restore Multi File DB backup.sql
EmailModel_TableChanges_ForAzureSQL.sql
Estimate Compression Savings.sql
Find Active Cluster Node.sql
Find Active Directory Users and Groups.sql
Find Active Transactions and Execution Plans.sql
Find Actively Running SQL Server Agent Jobs.sql
Find Ad Hoc Related Plan Cache numbers.sql
Find All Objects in All User Databases Using Name Like.sql
Find All The Schemas Tables Columns and DataTypes.sql
Find All User Created Objects.sql
Find Authentication Scheme And Net Transport.sql
Find Availability Group Health Secondary Node.sql
Find Avg Space Used Page Count and Avg Record Size Per Index For Table.sql
Find Batch Requests Compilations and Plan ReUse.sql
Find Block Size of the Volumes.sql
Find Buffer Descriptors what's in SQL Server buffer.sql
Find Buffer Pool Cache Size For Each Db.sql
Find Buffer Usage For Each Database.sql
Find CPU Intensive Queries.sql
Find Cached Plans and SQL.sql
Find Cached Temporary Object Count.sql
Find Column Exist in Multiple Tables.sql
Find Column Names and Data Types.sql
Find Columns With Constraints And Defaults.sql
Find Compressed Indexes For The Object.sql
Find Compressed Indexes.sql
Find Compressed Objects in SQL 2008.sql
Find Compression Info For All Indexes In A Database.sql
Find Connection Info to SQL Server.sql
Find Count of Connections To SQL Server.sql
Find Data Size And Log Size And Percent Log Used For All DBs.sql
Find Database Backup Size In GB.sql
Find Database File Growth Settings.sql
Find Database File space and File Group Info For All Databases.sql
Find Database File space and File Group Info.sql
Find Database Mail Profile and Account Info.sql
Find Database Role Permissions.sql
Find Database Role Permissions2.sql
Find Database Size for All Databases.sql
Find Date of the Sunday Week Day.sql
Find Degree of Selectivity.sql
Find Deprecated Features Being Used.sql
Find Detailed Information on Existing Indexes.sql
Find Detailed Information on Missing Indexes.sql
Find Detailed Information on Unused Indexes.sql
Find Duplicate and Overlapping Indexes.sql
Find Estimated Compression and Compress Table.sql
Find Estimated Compressions For All Tables.sql
Find Estimated Cost Of Execution Plan.sql
Find Execution Plan And Plan Handle with Usage Count.sql
Find Execution Plan Cache Usage For Stored Procs.sql
Find Execution Plan Cache Usage.sql
Find Execution Plan For Cached Object.sql
Find Execution Plan for Cached Queries.sql
Find Execution Plan for Parallel Executed Cached Queries.sql
Find Execution Plans Using Specific Index.sql
Find File Size and Available Space for Database.sql
Find File Size and File Group Info for All Online Database.sql
Find First and Last Day of The month.sql
Find Foreign Key Parent Chilld Indexing.sql
Find Foreign Keys Existing and Maybe Missing.sql
Find Free Drive Space.sql
Find Free Space in DB Files.sql
Find Full Text Indexes in a Database.sql
Find General Info for All Databases.sql
Find ID Gap In A Table.sql
Find IO Performance over 5 Minutes.sql
Find IO Stalls Since SQL Server Restart.sql
Find Index Column info.sql
Find Index Key Space Usage.sql
Find Index Leaf Page Insert Update Delete Count.sql
Find Index Size and Stats For All Indexes.sql
Find Index Stats Date For All Tables.sql
Find Index Stats Date For Single Table.sql
Find Index Usage Statistics.sql
Find Index Usage and Recommended Missing Indexes.sql
Find Index dept and Page Count for Each Level of index.sql
Find Indexed View Size.sql
Find Indexes with Most Contention.sql
Find Integrity Violating FKs.sql
Find Internal and External Fragmentation.sql
Find Last Statitistics Update Time.sql
Find Lock Type and Locked Resource Types For Given SessionId.sql
Find Lock Type and Locked Resource Types.sql
Find Locks For Each SPID.sql
Find Login Authentication time.sql
Find Long Running Jobs.sql
Find Midnight Date from Getdate.sql
Find Midnight Exact Date and Time.sql
Find Min Max Avg Record Size For All Tables.sql
Find Missing Recommended Index Details.sql
Find Missing Recommended Indexes.sql
Find Most Busy Database Files.sql
Find Most Expensive Query.sql
Find Netbios Server Name.sql
Find Number Of Replication Commands In Dist Db.sql
Find Objects in Each File Group.sql
Find Objects in Specific File Group.sql
Find Open Transactions And Execution Plans.sql
Find PK to FK Relationship.sql
Find Page Life Expectancy.sql
Find Page Splits Per Table.sql
Find Page Splits for All Index Pages.sql
Find Partitioned Tables.sql
Find Permission Grantor.sql
Find Permission In Db SQL2005.sql
Find Permissions For Azure DB Users.sql
Find Permissions For DB Users.sql
Find Permissions Select For Objects.sql
Find Physical Database Location.sql
Find Plan Handle and Remove From Proc Cache.sql
Find Primary Key Related Data.sql
Find Queries using Parallellism.sql
Find Query Memory Grants.sql
Find Read And Write Operations For All the Tables.sql
Find Read Write Operations Per Database File.sql
Find Recommended Log File Size.sql
Find Recommended MAXDOP.sql
Find Recommended Max Memory Setting.sql
Find Recommended Missing Indexes With Create Statement.sql
Find Recommended Missing Indexes.sql
Find Record Count For Each Table in Singe Schema.sql
Find Records Per Minute and Lag Between Data Collection From WhoIsActive.sql
Find Replicated Objects In Distribution DB.sql
Find Replicated Objects.sql
Find Replication Schema Options.sql
Find Replication Undelivered Command Count.sql
Find Reused and NotReused plan space usage in cache.sql
Find Ring Buffer Connectivity Errors.sql
Find Row Size For A Table Using Datalength.sql
Find Running Queries And Cost.sql
Find SQL Server Agent Job in Detail.sql
Find SQL Server Agent Jobs 2.sql
Find SQL Server Agent Jobs.sql
Find SQL Server Data Access Driver and Queries Executed from Client.sql
Find SQL Server High Level Information.sql
Find SQL Server Performance Counters.sql
Find SQL Statements Currently Using T-Logs.sql
Find SSIS Execution Errors in SSISDB.sql
Find SSRS Report Permissions.sql
Find Session Level Information Such as Authentication and Logins.sql
Find Session Transaction Isolation Level.sql
Find Sessions waiting for.sql
Find Size of Data Cache for Databases.sql
Find Statistics Modification Count.sql
Find Statistics Update Date.sql
Find Stats Data for All Statistics.sql
Find Stats Date LastUpdated.sql
Find Stats Date LastUpdated2.sql
Find Stats Update Date for All.sql
Find Stored Proc Containing Text.sql
Find Table Index Filegroup Info.sql
Find Table RowCount From partition_stats.sql
Find Table Size In Single DB.sql
Find Table Size in All Databases 2.sql
Find Table Size in All Databases Top 10 ove 100MB.sql
Find Table Size in All Databases from DBA database.sql
Find Table Size in All Databases.sql
Find Table and Index Size In Database.sql
Find Table and Index Size with Detailed.sql
Find Table and Index Space Usage.sql
Find Table in All User Databases.sql
Find Tables Created for Backup Or Temporary Than Can Be Dropped.sql
Find Tables Without PK and Without PK and Index.sql
Find Tables with Specific Column Type and Length.sql
Find Tempdb Contention.sql
Find Tempdb Session Usage.sql
Find Tempdb Space Allocation.sql
Find Tempdb Space Usage Including Current Requests.sql
Find Termination Reason and Optimization Levels for Execution Plans.sql
Find Top 10 Most Expensive Query.sql
Find Top 10 Queries with Exec Count Max Min Elapsed Time.sql
Find Top Stored Procedures Executed.sql
Find Total Page Read and Write Per Database.sql
Find User Created Objects.sql
Find VLF Number for All Databases.sql
Find When Backup Restore Index Operation Will Finish.sql
Find When Backup Restored.sql
Find When DB Files Auto Grow.sql
Find When DBCC CheckDB Run Successfully.sql
Find When DBCC CheckDB for All DBs Last Known Good Comma Seperated.sql
Find When DBCC CheckDB for All DBs Last Known Good.sql
Find When Databases Backed up Recently.sql
Find When Databases Backed up The latest backup.sql
Find When Stored Procedure Executed.sql
Find When and Which Backup File Used For DB Restore.sql
Find execution plan handle and remove it from plan cache.sql
Find if column has Default.sql
Find last Executed Statement by SPID.sql
Find members of the database role.sql
Find replication Status from Distribution Database.sql
Find when database restored and which backup file used.sql
Find when database restored.sql
Find when table updated.sql
Fix Users and Logins with Same Name Different SID.sql
Free WaitStats And Cache.sql
Function to Split Comma Seperated String.sql
Generate Login Information to Migrate Logins and Users.sql
Generate Script to Drop Create All Non Clustered Indexes.sql
Get Midnight DateTime.sql
Grant Permissions For User Defined Functions.sql
IOstalls and PageIOLatch.sql
In-Memory OLTP Diagnostic script.sql
Index_Fragmentation(2005).sql
Investigate Indexes on table.sql
Investigate_Transaction.sql
Kill All the SPIDS to Single DB.sql
Local Time and UTC Time.sql
MANUAL-SqlDependencySetup.sql
Max Memory Setting for 2 clusters running.sql
Migrate SQL Agent Jobs.sql
Monitor Identity Field Values Used.sql
OptimalMaxServerMemory_New_Multi-Version.sql
Parse Comma Delimited Values to Table.sql
Partition Overview Overloaded Partitions.sql
Partition to FileGroup mapping.sql
Rebuild All Indexes On Single Table SQL2005.sql
Rebuild All Indexes On Single Table.sql
Rebuild Indexes Using Cursor.sql
RebuildReorganizeIndexesForAllDbsSQL2005.sql
RebuildReorganizeIndexesForSingleDbSQL2005.sql
RedGate_SQL_Monitor_Index_Frag_Script.sql
Remove Spaces and Colons From Date.sql
Restore Database From Database Snapshot.sql
RetrieveIndexStats_CreateTableIndexStatProc.sql
SP Start Job With Wait.sql
SQL Server 2005 Diagnostic Information Queries.sql
SQL Server 2008 Diagnostic Information Queries.sql
SQL Server Agent Job Troubleshooting.sql
SQL Server Alerts From Healthy SQL.sql
SSB_AZURE_SQL_CLIENT_DW.sql
SSIS 32_64 bit Reg Unreg DLL.txt
Scan DB code for Problems.sql
Send Email With CSV File Attached.sql
Send Email for Service Restarts.sql
Space Used Analyzer Procedure.sql
Split Comma Seperated String Using XML.sql
Store DBCC CheckDB With TableResults.sql
Sync Database Users To Logins.sql
Trap xp_cmdshell Error Message and Raiserror.sql
Try Catch Block with Commit RollBack Trx and Raise Error Short.sql
Try Catch Block with Commit RollBack Trx and Raise Error.sql
Try Catch Block with Commit RollBack Trx and Throw Error Short.sql
Try Catch Block with Commit RollBack Trx.sql
Update Job Owner To SA.sql
Update Stats For Tables With 1000 Colum Or More.sql
Update Using Two Table Join.sql
Wait Stats Troubleshooting.sql
When Backup Restore Index Will Finish.sql
XML Query Exist Method Sample.sql
_ClientDW_sp_whoisactive_via sql agent calling powershell to invoke azure runbook.txt
_HowToDeplooy_SQLscripts_UsingPowershell.txt
dba_Index_defrag stored procedure.sql
setspn command to be executed.sql
usp_helpindexusagestats.sql
Latest commit Bulent Gucuk
Jun 27, 2017 Folders and files Name Name Last commit message
Last commit date
parent directory Jun 27, 2017
Jun 13, 2017
View all files
You can’t perform that action at this time.