(Pinal Dave) As soon as SQL 2008 and SQL 2008 R2 went out of support, few of my clients contacted me to help them in fixing an error occurred during the upgrade.

(Kenneth Fisher) I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is typically when they want to alter a database and need to get everyone out.

(Nakul Vachhrajani) I have often written about IDENTITY columns on my blog. Identity columns, most commonly used to implement auto-increment keys, have been around for more than a decade now.

(Sergey Gigoyan) There are some concepts in SQL Server which have different names, but functionally they are equivalent. However, the difference between their names can sometimes be confusing and therefore these questions can be classified as a frequently asked questions in the SQL Server sphere.

(Pinal Dave) Today, I am going to discuss a very interesting scenario which I encountered while working with one of the largest European financial technology organizations Comprehensive Database Performance Health Check earlier last week.

(Rick Dobson) We are becoming increasingly aware of the power of the hierarchyid data type for org charts and hierarchical data generally. To help us to access this power, we seek some simple examples of how to query employee data with the hierarchyid data type.

(Pinal Dave) Just another day, I was involved with a client during a Comprehensive Database Performance Health Check and ended up at a very interesting situation.

(Gauri Mahajan) This article aims to walk you through the SQL Decimal data type and its usage with various examples. We will also see how we can exercise this data type in SQL Server to help make SQL developer’s job easier.

(Grant Fritchey) I’ve always said if you’re running a script for the first time in a production environment, you’re doing it wrong.

(Greg Robidoux) One very important design aspect when creating a new table is the decision to create or not create a clustered index.