You may have noticed that TF 3656 appears to no longer work in SQL Server 2019 RC1. Symbols are not…
I was workload testing on SQL Server 2019 RC1 when I ran into a wait type I’d never noticed before:…
I thought it could be helpful to go into more detail for what I plan to present at the columnstore…
Microsoft recently published new guidance on setting server level MAXDOP. I hope to help the community by analyzing the new…
In the documentation for TOP, the following is listed as a best practice: In a SELECT statement, always use an…
Consider the following code that calls SYSDATETIME() 10 million times in a loop:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
GO CREATE OR ALTER PROCEDURE #p_local AS BEGIN SET NOCOUNT ON; DECLARE @dummy DATETIME2(7), @loops INT = 0; WHILE @loops <= 10000000 BEGIN SET @dummy = SYSDATETIME(); SET @loops = @loops + 1; END; END; GO EXEC #p_local; |
On my machine the code takes…
The documentation on delta rowgroups says: A delta rowgroup is a clustered index that’s used only with columnstore indexes. It…
A KB article was recently published that suggested that memory time-out behavior was changed for CCI inserts: When you try…
SQL Server KB 4462481 is a bit light on details: Assume that you use Microsoft SQL Server data warehousing. When…
Resource Governor can be used to enforce a hard cap on query MAXDOP, unlike the sp_configure setting. However, query plan…