Monthly Archives: October 2013
-
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 -
T-SQL Tuesday #47: Your Best SQL Server SWAG
1October 7, 2013 by Kenneth Fisher
It’s time for T-SQL Tuesday again and this time Kendal Van Dyke is asking for Your Best SQL Server SWAG. …
Continue reading -
Use TOP instead of SET ROWCOUNT
13October 7, 2013 by Kenneth Fisher
Both TOP and SET ROWCOUNT are both valid methods of limiting the result sets from a query. They are however …
Continue reading -
Filtering Object Explorer
3October 2, 2013 by Kenneth Fisher
I absolutely love learning new tricks that can be done in SSMS. Everything from opening initial connections to both the …
Continue reading