Tag Archives: T-SQL
-
RBAR vs Batch
10August 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?
5August 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?
1August 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.
9August 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 -
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 -
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 -
Master_Views: master_objects, master_tables, etc
1May 23, 2016 by Kenneth Fisher
There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of …
Continue reading -
How do I rename a column?
2April 18, 2016 by Kenneth Fisher
Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to …
Continue reading
SQL Studies 