SQL Performance

MARCH 5, 2020

ID ; Since I was running these queries on SQL Server 2019 CU1, the execution plans included the actual wait stats information related to the query execution. So, I decided to change how I was testing things and went to a SQLCMD execution of the queries. Testing with SQLCMD. ID ; SELECT t1. FILLER , t2.

Education 55

Education Servers Testing Tuning 55

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. I have SQL Server 2019 CTP 3.2

Servers 95

Servers C++ Testing Systems 95

SQL Server According to Bob

MARCH 27, 2017

SQL Server is running on Windows and encounters an exception. The dump includes the faulting thread’s memory, indirect memory referenced by the thread, SQL server ring buffers and a bit more memory. SQL Server is running on Linux and encounters an exception within a SQL Server module.

Servers 40

Servers Virtualization Storage Design 40