Getting all services running SQL Server using T-SQL: SELECT * FROM sys.dm_server_services
Category: SQL Server
SQL Server – All Objects On Instance Sorted By Date
One common question I hear whenever something begins to go wrong is, “Has anything been…
Moving Database Files to Another Location
Although moving database files around is simple, it is a still big deal. When you…
SQL Server Compare Users Script
If you need to compare two users in SQL Server, here is a handy script….
Finding Active Node in SQL Server Cluster
The T-SQL method to find the active node that a SQL service is running on:…
SQL Jobs – Daylight Savings Risks
For those of us not lucky enough to live in Arizona (where daylight savings is…
Validate SQL Code Without Running It
Validate SQL Code Without Running It In a nutshell: SET NOEXEC ON; — The script…
SSMS Scripting Partition Scheme With Correct Filegroup
I almost found a bug… but it’s a feature after all. If you are scripting…
AdventureWorksDW Databases – 2012, 2008R2 and 2008
AdventureWorks sample databases seem to be so hard to find when you want them. Here’s…
Database File Space and Free Space
/* Author: Ben Farnsworth Date: 1/7/14 Get info on Data files */ IF OBJECT_ID(‘tempdb..#space’) IS…