Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.
2011-12-15 (first published: 2007-10-11)
3,564 reads
Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.
2010-05-28 (first published: 2009-04-17)
1,453 reads
Check Orphaned logins ie, not associated with any database on the current instance.
2008-07-16 (first published: 2008-05-20)
1,593 reads
Returns list of active processes and their buffer contents over a specified time.
2008-07-02 (first published: 2008-05-20)
1,453 reads
2008-06-30 (first published: 2008-05-20)
2,682 reads
2008-06-26 (first published: 2008-05-20)
879 reads
2008-06-24 (first published: 2008-05-20)
2,110 reads
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,052 reads
This script allows you to check the several availability windows for the current day.
2008-01-11 (first published: 2007-10-29)
1,347 reads
(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.
2007-12-13 (first published: 2007-10-11)
991 reads
By damianwidera
Good morning! It was a tough weekend as we supposed to be in Goteborg...
By Steve Jones
Not something you’ll do too often, but you might find yourself doing this if...
By James-Serra
With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used...
Comments posted to this topic are about the item Is Data the Future of...
Comments posted to this topic are about the item “Included columns” for non-clustered indexes...
Comments posted to this topic are about the item Reindexing a database
Ask SSC