 |
|
|
SQL Server Scripts by SQL Server Gurus (SQL Server Automation Central)| Kill Active connections in Current Database | Abhijit More | Jun 03, 2010 | | SQL Server DBA | SUMUKH HEGDE | Nov 21, 2009 | | DELETE OLD BACKUP FILES - VBS | Chandran Babu Subramanian | Nov 09, 2009 | | Searching Word in Database | Sreenivasarao ponguru | Sep 21, 2009 | | Grouping Sets in SQL Server 2008 | Amol Rajmane | Aug 07, 2009 | | A script to select columns using wildcards | Anthony Zackin | Jul 30, 2009 | | Index size | Amol Rajmane | Jul 28, 2009 | | Query to find index recommendation | Swapnil Bajaj | Jul 01, 2009 | | Find Unused Non clustered Indexes in your database | Swapnil Bajaj | Jul 01, 2009 | | Execute T-SQL in Parallel | James Ma | Jun 11, 2009 | | UserTableScript_Template | Sirisha Kommushetty | Feb 16, 2009 | | ForeignKeyScript_Template | Sirisha Kommushetty | Feb 16, 2009 | | PrimaryKeyScript_Template | Sirisha Kommushetty | Feb 16, 2009 | | List Tables and the presence on Schema and FileGroup | Phani Tata | Dec 24, 2008 | | List the Indexes present in a database including all schemas | Phani Tata | Dec 24, 2008 | | ListAllTablesSizeinaDB | Sumanth Sudhindra | Dec 22, 2008 | | Completed blocked spid report with what queries running | Veeresh V Nashi | Dec 18, 2008 | | ListallTableIndexes | phani tata | Oct 01, 2008 | | Indentify Table(s) with Unique Constraint | Sirisha Kommushetty | Sep 05, 2008 | | Identify Table(s) without Index | Sirisha Kommushetty | Sep 05, 2008 | | Identify table(s) without Clustered Index in DB | Sirisha Kommushetty | Sep 05, 2008 | | Idenitfy Tables that have Primary key as a part of Non Clustered Index | Sirisha Kommushetty | Sep 05, 2008 | | Identify Tables Without Primary Key,but has unique constraint | Sirisha Kommushetty | Sep 05, 2008 | | Identify Tables that have Clustered Index,but it is not built on Primary Key | Sirisha Kommushetty | Sep 05, 2008 | | Identify Table(s) without Primary Key in a DB | Sirisha Kommushetty | Sep 05, 2008 | | Identify Tables that has Clustered Index,but has no Primary Key | Sirisha Kommushetty | Sep 05, 2008 | | Create All Secondary Indexes 2005 | Gary Fry | Jul 06, 2008 | | Dynamically Generate Delete Statement for Child Tables | SukhvinderSingh Kaushal | Jun 25, 2008 | | Automatically Create and Analyze Trace for Worst Queries | Gilles Comeau | Jun 11, 2008 | | Get a list of databases that are not being backed up | louis nguyen | Mar 11, 2008 | | Logins Permissions Report | louis nguyen | Mar 11, 2008 | | FileGroup Listing - Object (Table/Index) listing in filegroup/files | Vipul Shah | Feb 27, 2008 | | Find out which SQL Agent jobs are currently executing | louis nguyen | Feb 12, 2008 | | Get facts on whether statistics need to be updated | Saleem Hakani | Feb 12, 2008 | | Run SQL (T-SQL Statements or Stored Proc) on multiple Servers | Vipul Shah | Feb 09, 2008 | | SQL Server data/log usage for each drives | Saleem Hakani | Jan 24, 2008 | | Find out if your local SQL Server is configured to use /3GB switch or not? | Saleem Hakani | Jan 21, 2008 | | Identify orphan SQL Server user accounts from your local SQL Server. | Saleem Hakani | Jan 21, 2008 | | See what's happening behind the scenes of TempDB database. | Saleem Hakani | Jan 21, 2008 | | Script to find out which login has what server role permissions. | Saleem Hakani | Jan 21, 2008 | | Create Audit Table | Marco Mascioli | Jan 18, 2008 | | Drop all foreign keys and tables in a database | Denny Lee | Jan 17, 2008 | | Control Database Mirroring Failover and Failback thru script. | Saleem Hakani | Jan 16, 2008 | | Defrag indexes from one or all databases. | Saleem Hakani | Jan 16, 2008 | | Auto Failover SQL Jobs during Database Mirroring Session. | Saleem Hakani | Jan 16, 2008 | | Backup all User and System Databases excluding Mirror Databases. | Saleem Hakani | Jan 16, 2008 | | How to determine the space used by Tables in the database. | Hemant Kamalakar | Jan 16, 2008 | | Quickly get database information | Saleem Hakani | Nov 01, 2007 | | Detect highest CPU bound queries | Saleem Hakani | Nov 01, 2007 | | Get SQL Server Agent job configuration information | Saleem Hakani | Nov 01, 2007 | | Rebuild all indexes in a user database | colin leversuch-roberts | Oct 16, 2007 | | How to get current date and time of a system. | Hemant Kamalakar | Oct 15, 2007 | | Changing the owner of DTS Packages | Saleem Hakani | Oct 06, 2007 | | Get a snapshot of My Computer in SQL Server | Saleem Hakani | Oct 06, 2007 | | Get details about your database | Saleem Hakani | Oct 06, 2007 | | Get the Facts about your Backups | Saleem Hakani | Oct 04, 2007 | | SQLAgent.out Size Alert | Faisal Qureshi | Sep 27, 2007 | | Unrestrict database growth for one and for all | Saleem Hakani | Aug 26, 2007 | | To Index or to Defrag (Smart INDEX) | Saleem Hakani | Aug 26, 2007 | | Detect Real-time Deadlocks and Blocks | Saleem Hakani | Aug 26, 2007 | | Rebuild Indexes Online | Saleem Hakani | Aug 26, 2007 | | Are your indexes useful? | Saleem Hakani | Aug 26, 2007 | | Check the status of database mirroring session | Saleem Hakani | Aug 26, 2007 | | Checking Integrity and Consistency of Databases | Saleem Hakani | Aug 26, 2007 | | Track daily data growth | Saleem Hakani | Aug 26, 2007 | | Attach and Detach SQL Server Databases | Saleem Hakani | Aug 26, 2007 |
|
|
|
|