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,456 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,688 reads
2008-06-26 (first published: 2008-05-20)
883 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)
992 reads
By Steve Jones
This week we released SQL Prompt 10, which is an exciting milestone for us....
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
Over the years I’ve seen quite a few strange things with SQL Server. This...
Comments posted to this topic are about the item Numeric and Decimal, which is...
Comments posted to this topic are about the item Learn from the Troubles of...
When I create a data file (.ndf) and move the previous day's data from...
Ask SSC