Improve Query Performance when SQL Server Ignores Nonclustered Index
In this article, we look at why SQL Server may not use a non-clustered index over the clustered index and what you can do to improve performance.
2023-10-30
In this article, we look at why SQL Server may not use a non-clustered index over the clustered index and what you can do to improve performance.
2023-10-30
In this article, we look at execution plans and performance of a natively compiled stored procedure versus a traditional stored procedure.
2023-10-16
We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.
2023-02-06 (first published: 2023-01-30)
304 reads
2022-08-05
447 reads
2020-11-13
118 reads
2020-11-12
500 reads
2020-06-23
842 reads
2020-06-22
486 reads
The SQL Server set statistics time statement displays the number of milliseconds to parse, compile, and execute a T-SQL query statement. This set statement is widely used to assess times to implement a query statement. The set statistics time statement reports the CPU time and elapsed time for performance tuning.
2020-05-08
Kendra Little talks about write ahead logging in SQL Server, one of the basic concepts that developers and DBAs should understand.
2024-06-12 (first published: 2020-01-20)
4,538 reads
By Brian Kelley
When I watched the following video from Justin Sung, I realized that I am...
I’m excited to share a new open-source project I’ve been working on that combines...
By Brian Kelley
Instead of teaching the CISA exam prep course, I'm teaching in the IT track....
Comments posted to this topic are about the item Why Clone Fails: Discovering the...
Comments posted to this topic are about the item A Well Deserved Break
Comments posted to this topic are about the item Multiple Defaults
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers