Monthly Archives: November 2013
-
Finding active DTS packages
2November 27, 2013 by Kenneth Fisher
DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS …
Continue reading -
Finding the metadata for a query
Leave a commentNovember 25, 2013 by Kenneth Fisher
You know I occasionally find it interesting how I learn new things. I was running through a practice test for …
Continue reading -
A pattern to do beginning of period calculations.
Leave a commentNovember 20, 2013 by Kenneth Fisher
Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning …
Continue reading -
Connection options in SSMS
Leave a commentNovember 18, 2013 by Kenneth Fisher
When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know …
Continue reading -
Who’s on call
4November 13, 2013 by Kenneth Fisher
Every morning we have a daily meeting and my manager asks who’s on call. And every morning some form of …
Continue reading -
A better way to find missing indexes
11November 11, 2013 by Kenneth Fisher
I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a …
Continue reading -
Physical Join Operators by Ami Levin
Leave a commentNovember 6, 2013 by Kenneth Fisher
For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these …
Continue reading
