Monthly Archives: October 2017
-
Haunted SQL: The ghost of Management Studio
2October 30, 2017 by Kenneth Fisher
Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results? …
Continue reading -
Schema only backup or schema only DB copy
Leave a commentOctober 25, 2017 by Kenneth Fisher
Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded …
Continue reading -
When is it a good idea to consolidate multiple instances?
1October 23, 2017 by Kenneth Fisher
In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple …
Continue reading -
Updateable CTEs
5October 18, 2017 by Kenneth Fisher
CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t …
Continue reading -
Permissions required for developing with Temporal Tables
2October 16, 2017 by Kenneth Fisher
Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table …
Continue reading -
sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)
2October 11, 2017 by Kenneth Fisher
I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into …
Continue reading -
Small identity columns
5October 9, 2017 by Kenneth Fisher
We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small …
Continue reading -
The Alpha and the Omega. The BEGIN and the END.
2October 4, 2017 by Kenneth Fisher
The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do …
Continue reading -
Haunted SQL
Leave a commentOctober 2, 2017 by Kenneth Fisher
I decided that for Halloween this year it would be fun to tell SQL ghost stories. When I tweeted about …
Continue reading -
SQL Homework – October 2017 – Sample/Test Database(s)
3October 2, 2017 by Kenneth Fisher
Last month your homework was to set up your own lab. Now it’s time to put a sample database or …
Continue reading