This wait type indicates that parallel plans execute on the server. This wait type doesn’t necessarily means there is a problem. It only...

When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s common to see SQL Server creating and...

Everyone, who deal with SQL server, know sample database AdventureWorks, which has been with us since the days of SQL Server 2005. Most...

Everyone knows the simple T-SQL “SELECT * ” is bad practice. It can: Effects the execution plan (Table / Index Scan); Returns too much...

Usually, when I need to troubleshoot currently running requests, I use a combination of sys.dm_exec_requests and sys.dm_os_waiting_tasks....

Let’s say you need to create a new SQL Server database, which is going to grow very fast, but you don’t know how fast. What would be the...

There is a growing need for Graph Databases in the market. This is a type of database, which is capable of storing, representing and...

So you are a SQL Server DBA, and you are responsible for a database, which gives you a hard time. Users constantly complain about poor...