The 1.2 version of the Query Store Replay script a number of new features are added that return information of...
2017-01-04 (first published: 2016-12-30)
2,008 reads
One of the great features of the Query Store is that it stores query execution plans and runtime performance on-disk...
2016-12-19
1,252 reads
Next to releasing a new version of sp_WhatsupQueryStore, I just released the 1.3 version of the Query Store Database Dashboard!
Release...
2016-12-15
510 reads
sp_WhatsupQueryStore v1.2 has just been released!
In this new version additional parameters are added to control what information is returned and...
2016-12-15
446 reads
Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are...
2016-12-06
464 reads
This afternoon I tweeted that a new Query Store related stored procedure I created is available: sp_WhatsupQueryStore.This blog post goes...
2016-12-01 (first published: 2016-11-24)
2,475 reads
SQL Server 2016 SP1 added loads of cool new features and options. One of those is a change that expands...
2016-11-22 (first published: 2016-11-20)
1,753 reads
Not only did we receive a brand new Service Pack for SQL Server 2016 this week, since yesterday we are...
2016-11-17
870 reads
SQL Server 20016 SP1 is released today and it introduces a truck load of new features and options. Even better,...
2016-11-16
1,165 reads
Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t...
2016-11-07
2,105 reads
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Here’s how these tools can make Kubernetes security easier and help you avoid common...
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Comments posted to this topic are about the item Shades and Reflecting on SQLBits...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers