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,339 reads
Richard Doering
2010-12-30 (first published: 2010-03-18)
2,456 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,684 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)
920 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,280 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,424 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,382 reads
Blogs
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
My 2024 in Data: Travels
By Steve Jones
This is my last week of the year working (I guess I come back...
Data Strategy Checklist for 2025
The post Data Strategy Checklist for 2025 appeared first on Joyful Craftsmen.
Forums
Techlancers MIddle East
If the on-page blogs have been completed, kindly forward them to us. We have...
Tempdb is filling due to background process.
I have it narrowed down to which session id is causing the issue, but...
Issue with IIF
I am creating a new measure in an SSAS cube and encountering an issue....
Question of the Day
The Random Rows
If I run this code in SQL Server 2019 on Adventureworks, how many random values are returned?
SELECT TOP (10)
be.BusinessEntityID
, RAND (BusinessEntityID)
FROM Person.BusinessEntity AS be; See possible answers