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,220 reads
Richard Doering
2010-12-30 (first published: 2010-03-18)
2,352 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,371 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)
739 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,121 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,915 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,155 reads
Blogs
Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements
By todd-32417
The next batch of exciting updates to the block editor is live on WordPress.com....
Are You a Diverse User Group or Event?
By Steve Jones
One of the things that I’ve seen crop up at various points in my...
Daily Coping 18 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Deceptive Visualizations
Comments posted to this topic are about the item Deceptive Visualizations
Argument syntax for SSIS Execute Process Task Editor
Hi, I'm trying to modify my SSIS packages to use sftp and since it...
Seeking input on Best Method to Join on First or Last Row in a 1:M Join
I have included the DDL to re-create the 2 tables in this examples. I...
Ask SSC