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,587 reads
2010-06-09 (first published: 2008-05-20)
3,014 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,476 reads
2009-02-05 (first published: 2008-05-20)
2,204 reads
Check Orphaned logins ie, not associated with any database on the current instance.
2008-07-16 (first published: 2008-05-20)
1,603 reads
Returns list of active processes and their buffer contents over a specified time.
2008-07-02 (first published: 2008-05-20)
1,465 reads
2008-06-26 (first published: 2008-05-20)
901 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)
1,004 reads
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,070 reads
This script allows you to check the several availability windows for the current day.
2008-01-12 (first published: 2007-10-29)
1,366 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers