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,200 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)
3,545 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)
708 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,033 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,657 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,110 reads
Blogs
Do you have rarely used indexes that are hurting performance of writes?
By SQLPals
We know that indexes are necessary for query performance but comes with overhead during...
Working with SQLSaturday SpeedPASSes – revamped!
In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among...
Happy Hour at SQL in the City Austin
By Steve Jones
Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
sql server 2012 data column used for 7 different languages
In a sql server 2012 database, I want to store some messages in the...
Ask SSC