Performance Problem When Using OR In A JOIN
I recently had a developer come to me with a poorly performing query. As you will see below, it’s a fairly straight forward query, consisting of one table with one …
Stored Procedures Ignore User’s Permissions
So, that title may be a little misleading to some. It is not meant as a blanket statement about all procedures and all permissions, but rather a specific situation that …
List All Foreign Keys Referencing A Table In SQL Server
There may be times that you need to get a list of tables that have foreign key constraints back to a table that you’re working on. Fortunately, SQL Server has a built …
Why you should not prefix your stored procedures with “sp_”
One nasty habit that seems to persist throughout the ages with developers (I even did it myself) is the tendency to put “sp_” at the beginning of stored procedure names …
NOLOCK may not be doing what you think it does
When working with developers, I’ve noticed that some have a tendency to put WITH (NOLOCK) on every table in a SELECT query. When I inquire about this, the typical response I …