Index Basics: Hidden Costs Associated With Indexes
I have a confession. When I was a developer, I didn’t understand indexes in SQL Server. I rarely added them to my tables, and when I did there was not …
Encrypting Passwords Using EncryptByPassPhrase
While storing passwords in a database may be a common practice, storing them properly usually isn’t so common. This is part of a storing passwords blog series where we will examine …
Storing Passwords In A SQL Server Database
While storing passwords in a database may be a common practice, storing them properly usually isn’t so common. This is the first of a series of posts where we will …
Index Basics: Nonclustered Indexes, Part 1
In SQL Server, an index is used to speed the retrieval of data from a table. Indexes are built from one or more columns in the table, and SQL Server uses these Indexes …
Index Basics: Clustered Indexes
In SQL Server, an index is used to speed the retrieval of data from a table. Indexes are built from one or more columns in the table, and SQL Server uses these Indexes …
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 …