Monthly Archives: June 2016
-
Finding, disabling and enabling foreign keys
3June 29, 2016 by Kenneth Fisher
Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if …
Continue reading -
Perfectly Placed Parentheses
14June 27, 2016 by Kenneth Fisher
Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls …
Continue reading -
Database snapshots
4June 22, 2016 by Kenneth Fisher
This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating. …
Continue reading -
Minimizing Cloud cost
9June 20, 2016 by Kenneth Fisher
The cloud can be expensive. I had this hammered home the other day by a simple mistake. I’m currently working …
Continue reading -
Help! My backup file has doubled in size.
2June 16, 2016 by Kenneth Fisher
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400! …
Continue reading -
Comparing two query plans
3June 14, 2016 by Kenneth Fisher
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server. …
Continue reading -
Comparing the contents of two tables Redux
Leave a commentJune 8, 2016 by Kenneth Fisher
I did a post the other day on comparing two tables. It was meant as a general overview but I …
Continue reading -
I need help with DBCC
2June 6, 2016 by Kenneth Fisher
Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I …
Continue reading -
Using LEN wrong.
4June 2, 2016 by Kenneth Fisher
I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster) …
Continue reading