I take occasional “brain breaks” at the office, to refresh me before I set upon the next course of work. Mostly I like to troll around a favorite set of websites and links from them. So it was today that I happened across this book recommendation – I think on Brent Ozar’s site – for a […]
Author: Jen McCown
This blog IS about NULL
I just recorded a couple of Midnight Snacks on NULLs, and I felt inspired to blog about it too. Equals Null Mistake (video) First, let’s talk about a mistake that’s easy to make, especially if you’re in the throes of a coding frenzy, tossing JOINs here and WHERE clauses there, to get your data set returned […]
Index Rebuilds: SQL vs. PowerShell
I thought this conversation worth reporting…Sean and I were comparing our scripts to create rebuild / reorgs, and he sent this: DECLARE @currSchema VARCHAR(100) , @currTableName VARCHAR(100) , @SQL NVARCHAR(200) DECLARE Tables CURSOR read_only FOR SELECT SS.name , SO.name FROM sys.objects SO INNER JOIN sys.schemas SS ON SO.schema_id = SS.schema_id […]