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,570 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,459 reads
Check Orphaned logins ie, not associated with any database on the current instance.
2008-07-16 (first published: 2008-05-20)
1,594 reads
Returns list of active processes and their buffer contents over a specified time.
2008-07-02 (first published: 2008-05-20)
1,454 reads
2008-06-30 (first published: 2008-05-20)
2,745 reads
2008-06-26 (first published: 2008-05-20)
889 reads
2008-06-24 (first published: 2008-05-20)
2,118 reads
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,053 reads
This script allows you to check the several availability windows for the current day.
2008-01-11 (first published: 2007-10-29)
1,350 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)
997 reads
By Angela-Henry
I am very excited to announce that I will be speaking for Data Saturday...
By Angela-Henry
I am super excited about this new version of Data Weekender, coming up on...
By Steve Jones
I have to thank Kathi and Mala for putting on the WIT Mental Health...
Comments posted to this topic are about the item Checking Up on Vendors, which...
Hi Forum, I want to search a Database for a String value and I...
Hello Friends, Posting this for help as the client made more requirement changes. I...
Ask SSC