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,309 reads
Richard Doering
2010-12-30 (first published: 2010-03-18)
2,443 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)
6,520 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)
877 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,237 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)
7,114 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,324 reads
Blogs
Using ThinOptics to Read Data
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...
Set-Based vs Row-Based Database Code
By Kevin3NF
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...
Forums
The Fake Speakers
Comments posted to this topic are about the item The Fake Speakers
Stairway to Database DevOps Level 3: Managing Code as a Team in Git
Comments posted to this topic are about the item Stairway to Database DevOps Level...
Reduction of installation time of sql server 2008 R2 Express
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Ask SSC