Optimizing for Ad Hoc Workloads
Watch this week’s episode on YouTube.
The execution plan cache is a great feature: after SQL Server goes through the effort...
2019-02-07 (first published: 2019-01-22)
2,107 reads
Watch this week’s episode on YouTube.
The execution plan cache is a great feature: after SQL Server goes through the effort...
2019-02-07 (first published: 2019-01-22)
2,107 reads
dbatools is one of the coolest community projects I’ve seen – it is amazing how many commands are available to help...
2019-02-05
182 reads
Watch this week's video on YouTube
dbatools is one of the coolest community projects I've seen - it is amazing how many commands are available to help make managing your...
2019-02-05
1 reads
Watch this week's video on YouTube
When building indexes for your queries, the order of your index key columns matters. SQL Server can make the most effective use of an...
2019-01-29
1 reads
Watch this week’s episode on YouTube.
When building indexes for your queries, the order of your index key columns matters. SQL...
2019-01-29
930 reads
Watch this week’s video on YouTube.
While most of us strive to make as few mistakes as possible when it comes...
2019-01-25 (first published: 2019-01-15)
2,190 reads
Watch this week's video on YouTube
The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that...
2019-01-22
1 reads
Watch this week's video on YouTube
While most of us strive to make as few mistakes as possible when it comes to our servers and data, accidents do occasionally happen.
Sometimes...
2019-01-15
This post is part 3 in a series about physical join operators (be sure to check out part 1 – nested...
2019-01-10 (first published: 2019-01-02)
2,554 reads
This post is a response to this month’s T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way...
2019-01-08
234 reads
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers