SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part ...

Understanding Columnstore Indexes in SQL Server First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads.

Let's break down when it's ideal to use the NOLOCK hint and when you should never use it. As a consultant, I work on wide swaths of database systems, which means I get to see many, many SQL statements ...