David Bird

Blogs

Query Store stores dates as UTC

By

One of the powerful aspects of Query Store is the ability to directly query...

SpeedPASS Printing

By

Based on the great post and script from Wayne Sheffield I decided to try...

Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store

By

An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting...

Read the latest Blogs

Forums

Multiple tables created in CDC

By DBA_007

Hello Team, I have enabled CDC for a particular database in SqlServer and enabled...

2 core machine with 4 Tempdb files

By AlphaTangoWhiskey

Just curious if there is a performance hit by having 4 tempdb files with...

User datareader access problem

By jay-h

I went to give a user (via AD account) datareader access to a number...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers