|
|
SQL Server Scripts by SQL Server Gurus (SQL Server Automation Central)| SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization | Ola Hallengren | Aug 08, 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 |
|
|
|
 |