Tag Archives: microsoft sql server
-
Undocumented functionality in FORMATMESSAGE
2December 9, 2013 by Kenneth Fisher
I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which …
Continue reading -
Insert into a table using only default values
4December 4, 2013 by Kenneth Fisher
A while back I talked about the DEFAULT keyword and using it to tell SQL to use the default value …
Continue reading -
Finding active DTS packages
9November 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
2November 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
2November 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 -
A better way to find missing indexes
13November 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 -
Adding a column to a table with a default (NULL vs NOT NULL)
4October 30, 2013 by Kenneth Fisher
There are lots of ways to learn new things, or be reminded of old things. One of my favorites is …
Continue reading
SQL Studies 