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,580 reads
2010-06-09 (first published: 2008-05-20)
2,912 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,463 reads
2009-02-05 (first published: 2008-05-20)
2,186 reads
Check Orphaned logins ie, not associated with any database on the current instance.
2008-07-16 (first published: 2008-05-20)
1,596 reads
Returns list of active processes and their buffer contents over a specified time.
2008-07-02 (first published: 2008-05-20)
1,457 reads
2008-06-26 (first published: 2008-05-20)
894 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.
2008-05-21 (first published: 2007-10-11)
999 reads
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,060 reads
This script allows you to check the several availability windows for the current day.
2008-01-12 (first published: 2007-10-29)
1,357 reads
By Steve Jones
The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023....
Information security and privacy are key in today’s data-driven world. Sensitive data needs to...
By SQLBalls
Hello Dear Reader! Sorry this is so late, moving houses has gotten me a...
Ok, need someone to talk me off the cursor ledge on this one. I...
Comments posted to this topic are about the item Better Communication Through Less Messaging
Comments posted to this topic are about the item MuleSoft Integration with Azure Key...
Ask SSC