Query Store, Forced Plans, and New Plans
I love questions. I recently received one about new plans in the Query Store (available in Azure SQL Database now and in...
2016-05-23 (first published: 2016-05-16)
2,733 reads
I love questions. I recently received one about new plans in the Query Store (available in Azure SQL Database now and in...
2016-05-23 (first published: 2016-05-16)
2,733 reads
Let’s start with a very brief definition of some RAID levels.
RAID 0 : Stripe your data across multiple disks. Writing a...
2016-05-24 (first published: 2016-05-16)
1,497 reads
Unveil the inner workings of the esoteric build system...
As a data professional, I've never worked extensively with msbuild or other...
2016-05-16
3,257 reads
It started with a tweet from Dusty
The second session I presented at the fantastic PowerShell Conference Europe was about using the...
2016-05-16
825 reads
Recently while working on a scenario I found that in case of transaction if you are doing insertion operation on...
2016-05-16
566 reads
In SQL Server, the concurrent creation of temporary tables from many sessions can lead to tempdb metadata contention. Tempdb metadata contention does not affect the concurrent creation of table...
2016-05-15
37 reads
With SQL Server AlwaysOn Availability Groups, when you configure a secondary in synchronous-commit mode for read-only access, there can be data access latency. If you make changes to your...
2016-05-15
27 reads
When SQL Server has a choice of plans, it will compare the cost among a set of execution plans and will choose the cheapest one. In some cases, even...
2016-05-15
55 reads
SQL Server configuration parameter “optimized for ad hoc workloads” can be very useful when you execute lots of single use ad hoc statements or dynamic SQL statements by reducing...
2016-05-15
42 reads
When it comes to lock waits, one of the important information we need to know is which statement waited for locks and how long. This is possible with extended...
2016-05-15
140 reads
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
I’ve spent a lot of years around SQL Server on shared storage, and lately...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers