Backup all Filegroups
A short script to backup all filegroups, for those who utilise filegroups within a database.
2011-06-29 (first published: 2010-07-20)
1,206 reads
Richard Doering
2010-12-30 (first published: 2010-03-18)
2,336 reads
Linked Server Connectivity Test
A short procedure for your tools database. Use it to test connectivity to linked servers.
2010-12-28 (first published: 2010-03-19)
4,041 reads
SQL 2008 : Uncompressed Objects Procedure
A Stored Procedure for your tools database. It lists uncompressed tables and indexes and also generates the SQL to compress them.
2010-12-22 (first published: 2009-08-27)
710 reads
Charpad - Character Padding Function
A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports.
2010-12-20 (first published: 2010-03-31)
2,069 reads
Index Fragmentation Status (includes Partitioned Tables/Indexes)
This script reveals the state of your indexes. It breaks down the indexes where they are partitioned, matching the index to it’s partition and filegroup.
2010-12-16 (first published: 2010-04-22)
4,968 reads
Windows Group Membership Checker
A script to reveal which logins have access to your sql server via windows groups.
2010-09-01 (first published: 2010-08-26)
2,114 reads
Blogs
Cursor Dynamic SQL
By Vinay Thakur
Today was working on SQL Server cursor standard cursor deification would be like this:...
How to get the Active Directory user password policy values
By SQLPals
Recently I have had to troubleshoot quite a bit of SQL login issues and...
How do you use PowerShell toc check if an active directory user locked out, disabled etc.?
By SQLPals
If your organization uses a password policy (there are very good odds these days...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
How does DBCC CHECKDB use tempdb?
I would like to know the working principle of DBCC regarding the tempdb. I...
Ask SSC