-
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 -
Change in SQL 2012 SSMS grid output behavior
Leave a commentOctober 28, 2013 by Kenneth Fisher
It’s one of those things that always aggravated me but not really enough to complain about. When you run a …
Continue reading -
Unexpected truncation in FETCH
Leave a commentOctober 23, 2013 by Kenneth Fisher
Yes I’m talking about FETCH as in a cursor, yes everyone hates cursors. But you know cursors are like anything …
Continue reading -
A look at comments
17October 21, 2013 by Kenneth Fisher
Everyone knows that we should include comments in our code right? On the other hand the vast majority of us …
Continue reading -
Query to compare indexes between two tables
Leave a commentOctober 16, 2013 by Kenneth Fisher
We have a set of databases at my office that use the load and swap method of loading data with …
Continue reading -
Why you should know how to script as well as use the GUI
Leave a commentOctober 14, 2013 by Kenneth Fisher
Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out …
Continue reading -
I’ve refreshed a test database from prod but now the users can’t access it.
4October 9, 2013 by Kenneth Fisher
This happens to me all the time. I get a request from a developer to overwrite the test copy of …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 