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)
1,996 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,200 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
507 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
442 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
463 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,460 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,747 reads
Not only did we receive a brand new Service Pack for SQL Server 2016 this week, since yesterday we are...
2016-11-17
864 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,161 reads
As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016....
2016-11-08 (first published: 2016-11-02)
2,898 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers