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,209 reads
Richard Doering
2010-12-30 (first published: 2010-03-18)
2,345 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)
5,065 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)
715 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,094 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,580 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,130 reads
Blogs
Updating my Kubernetes Raspberry Pi Cluster to containerd
There’s been a lot of conversations happening on twitter over the last couple of...
Daily Coping 3 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Homework – December 2020 – Participate in the Advent of Code.
Christmas. Depending on where you live it’s a big deal even if you aren’t...
Forums
Report based on dynamic columns
Hi all, Can anyone help please? I am trying to do the below report,...
There are no SQL Server instances or shared features that can be updated -2017
Hi Please Assist. I am trying to install SQL SERVER CU 22 on SQL...
How can I exclude records from this table?
How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...
Ask SSC