Category Archives: T-SQL

  1. RBAR vs Batch

    7

    August 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

  2. Azure: What’s the difference between SQL Database and SQL Server?

    1

    August 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

  3. What’s the difference between LEFT and RIGHT OUTER JOINs?

    Leave a comment

    August 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

  4. Using impersonation to allow a task without granting the required permission.

    7

    August 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

  5. Finding, disabling and enabling foreign keys

    2

    June 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

  6. Perfectly Placed Parentheses

    14

    June 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

  7. Help! My backup file has doubled in size.

    2

    June 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

  8. Comparing the contents of two tables Redux

    Leave a comment

    June 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

  9. Using LEN wrong.

    4

    June 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

  10. Master_Views: master_objects, master_tables, etc

    Leave a comment

    May 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,235 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
Follow

Get every new post delivered to your Inbox.

Join 1,235 other followers