top of page
Topic
Recent Posts
Archive
Tags
Data scientists vs analysts
From Me to Everyone: 12:12 PM What are the differences between data scientists and data analysts? From Bri Gipson to Everyone: 12:15 PM...
Performance, error and warning events
Missing_Column_Statistics, Missing_Join_Predicate, and Sort Warnings belongs to the Errors and Warnings event category, which contains...
Inner Join (vs Inline TVF)
Let’s consider a query that combines data from multiple tables to produce the query plan. The Hash Match (Inner Join) operator combines...
Query performance
Often the first step you take to improve your SQL Server query performance is to add indexes to tables. This is also usually true for...
exec_query_stats
You can also review the statistics collection at the query level by executing a query against the sys.dm_exec_query_stats DMV, which...
REORGANIZE vs REBUILD
Besides columnstore and missing index, there are three major issues regarding index we can monitor through system Dynamic Management...
Data Collector vs Activity Monitor
The data collector is a core component of the data collection platform for SQL Server 2019 (15.x) and the tools that are provided by SQL...
Database recovery
Use the Options page of the Restore Database dialog box to modify the behavior and outcome of the restore operation. To use SQL Server...
Version Store
A interesting quote " Are you using Read Committed Snapshot isoloation? We are and it is blowing up our TempDB. "...
bottom of page