2016-03-19
Finding Active Node in SQL Server Cluster
The T-SQL method to find the active node that a SQL service is running on: SELECT...
March 2016
2016-03-19
SQL Jobs – Daylight Savings Risks
For those of us not lucky enough to live in Arizona (where daylight savings is ignored...
2016-03-19
Validate SQL Code Without Running It
Validate SQL Code Without Running It In a nutshell: SET NOEXEC ON; — The script now...
2016-03-19
SSMS Scripting Partition Scheme With Correct Filegroup
I almost found a bug… but it’s a feature after all. If you are scripting out...
2016-03-19
AdventureWorksDW Databases – 2012, 2008R2 and 2008
AdventureWorks sample databases seem to be so hard to find when you want them. Here’s a...
2016-03-19
Database File Space and Free Space
/* Author: Ben Farnsworth Date: 1/7/14 Get info on Data files */ IF OBJECT_ID(‘tempdb..#space’) IS NOT...
2016-03-19
Autogrowth On But Database Not Growing
An issue arose where a database was giving the error: Could not allocate space for object...
2016-03-19
Shrinking Database Files With Excess Free Space
This script is intended for environments where space constraints require the space to be closely maintained....
2016-03-19
SQL Server – Lots of Empty Space But Database Won’t Shrink
Today I ran a script to delete a huge portion of data in a DEV environment...
2016-03-19
SQL Server – Get Latest Backup File Sizes For All Databases
This returns a result for each database and includes its size in MB. SELECT DATABASE_NAME DBNAME...