Reindex Procedure with a Twist (or two) the SQL
A 2012 update to "Reindex Procedure with a Twist (or two)":
2015-09-15 (first published: 2014-05-16)
4,436 reads
Scripts
Get database size, used space, free space
Gets the size, amount of space used & unused, owner and modify date for all databases in a Sql instance.
2015-09-14 (first published: 2014-04-22)
4,463 reads
Deleting Duplicate Records
In Datawarehousing, a normal scenario is eleminating duplicate records/rows or deleting duplicate records, here's the solution.
2015-09-11 (first published: 2012-10-31)
5,044 reads
2015-09-10 (first published: 2014-05-08)
4,890 reads
Physical Server or a Virtual Machine?
Simple T-SQL Script to know whether your SQL Server is running on a Physical box or a VM.
Note: This Script works only on 2008R2 SP1 and above.
2015-09-09 (first published: 2014-05-22)
4,815 reads
Create MERGE statements with data!
A script to create MERGE statements with data for specific tables.
2015-09-03 (first published: 2014-05-19)
5,229 reads
SQL Server Performance Base Line Script
Performance Base Line Report from SQL Server DMVs and Perfmon counters
2015-09-02 (first published: 2013-02-04)
17,274 reads
Block altering indexed views.
Altering an indexed view will drop all indexes on it without warning, even if nothing is changed.
This will prevent accidental alters.
Script is divided into 4 parts, included testing and cleanup scripts.
2015-09-01 (first published: 2015-08-13)
1,005 reads
Registered server documenter
Returns server and instance information via a registered server query, regardless of SQL version.
This script is more of how to get the data, and not so much about the data returned by my choice of columns.
Tested on 2008+
2015-08-28 (first published: 2015-08-07)
1,393 reads
Retrieving XML data to Table from dm_os_ring_buffers
Retrieving XML data to Table from dm_os_ring_buffers for better readable purpose
2015-08-27 (first published: 2015-08-03)
999 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Using CHOOSE()
Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
The DBA is Dead! Long Live the !
Comments posted to this topic are about the item The DBA is Dead! Long...
Question of the Day
Using CHOOSE()
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers