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,341 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,709 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,086 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)
5,332 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,119 reads
Blogs
Social: Going Along to Get Along
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
Daily Coping 3 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using Docker Volumes for SQL Server in Linux
By John
No, not that kind of volume! Over the past couple of blog posts, I...
Forums
stored procedure to delete user and login
I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...
Managing Stress
Comments posted to this topic are about the item Managing Stress
Failover Cluster Instance Share
Hi, I am using AlwaysOn Availability Groups in SQL Server 2016 with a primary...
Ask SSC