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,574 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
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-30 (first published: 2008-05-20)
2,791 reads
2008-06-26 (first published: 2008-05-20)
892 reads
2008-06-24 (first published: 2008-05-20)
2,137 reads
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,055 reads
This script allows you to check the several availability windows for the current day.
2008-01-11 (first published: 2007-10-29)
1,353 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)
999 reads
Every one and again you will see people asking What skill do you think...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
After writing several posts about a neat feature in Azure SQL called system-versioned ledger...
Obtain your valid UK driving license now without writing any EXAMS WhatsApp##: +447418334274 APPLY...
Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...
I work on sql server 2012 i need to get featurekey and feature value...
Ask SSC