Category Archives: T-SQL
-
A quick fix for a full identity column.
Leave a commentSeptember 21, 2016 by Kenneth Fisher
A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following: …
Continue reading -
Using an ORDER BY in a view
20September 19, 2016 by Kenneth Fisher
For many years it’s been a best practice to never put an ORDER BY in a view. The idea is …
Continue reading -
RBAR vs Batch
7August 17, 2016 by Kenneth Fisher
Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s …
Continue reading -
Azure: What’s the difference between SQL Database and SQL Server?
1August 9, 2016 by Kenneth Fisher
If you want to blog T-SQL Tuesday is a great way to get started. On the first Tuesday of each …
Continue reading -
What’s the difference between LEFT and RIGHT OUTER JOINs?
Leave a commentAugust 3, 2016 by Kenneth Fisher
A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?” There are several …
Continue reading -
Using impersonation to allow a task without granting the required permission.
7August 1, 2016 by Kenneth Fisher
I use impersonation on a regular basis for a number of different tasks. This one is pretty basic but can …
Continue reading -
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 -
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 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
