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,259 reads
Richard Doering
2010-12-30 (first published: 2010-03-18)
2,395 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,941 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)
801 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,163 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)
6,399 reads
Windows Group Membership Checker
A script to reveal which logins have access to your sql server via windows groups.
2010-12-09 (first published: 2010-08-26)
2,241 reads
Blogs
Scary Scalar Functions - Part Two: Performance
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...
Goal Progress for June 2022
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Using Sessionize for Your User Group – Part 2
Now that your CFS has been setup it’s time to get the word out...
Forums
Help with Pivoting Table
Hi all, Can someone please help Pivot a table. The table currently looks like...
Help Transposing SQL Table Pt3
Hello Community, Can someone please help transpose a table. The table currently looks like...
PowerApps and SQL security
PowerApps have a problem with their security model and wonder if I could solve...
Ask SSC