Tag Archives: microsoft sql server
-
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 -
The MERGE statement doesn’t have a WHERE clause.
5September 30, 2013 by Kenneth Fisher
What the heck? Even indexes have WHERE clauses these days. I can’t remember what I was reading when I saw …
Continue reading
SQL Studies 