Removing ad hoc plans from Query Store
This is not a post about the “optimize for ad hoc workloads” setting on your favorite SQL Server instance, but that is a good place to start. Lots of...
2020-02-27 (first published: 2020-02-20)
423 reads
DesertDBA
- Website: https://desertdba.com
Removing ad hoc plans from Query Store
This is not a post about the “optimize for ad hoc workloads” setting on your favorite SQL Server instance, but that is a good place to start. Lots of...
2020-02-20
6 reads
Using Erik Darling’s sp_pressure_detector to resolve CPU issues
Last Friday I spent my lunch break going through some links I had marked for future reading. One of them was a post earlier this month by Erik Darling...
2020-02-13 (first published: 2020-01-28)
1,597 reads
Using Erik Darling’s sp_pressure_detector to resolve CPU issues
Last Friday I spent my lunch break going through some links I had marked for future reading. One of them was a post earlier this month by Erik Darling...
2020-01-28
8 reads
How I passed the 70-761 certification exam
FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over 20 years. Second FUN FACT: the last time I took a Microsoft certification exam was...
2020-01-24 (first published: 2020-01-18)
1,134 reads
How I passed the 70-761 certification exam
FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over 20 years. Second FUN FACT: the last time I took a Microsoft certification exam was...
2020-01-18
3 reads
How I applied 13 cumulative updates in 12 minutes
Twitter is a strange place. I mean, aside from all the outrage practice and animal videos. Last week I sent out a tweet about how I used dbatools to...
2019-10-09 (first published: 2019-10-04)
716 reads
T-SQL Tuesday #119 – Changing My Mind
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2019-10-08
55 reads
T-SQL Tuesday #119 – Changing My Mind
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2019-10-08
2 reads
How I applied 13 cumulative updates in 12 minutes
Twitter is a strange place. I mean, aside from all the outrage practice and animal videos. Last week I sent out a tweet about how I used dbatools to...
2019-10-04
3 reads
Blogs
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Secure Azure SQL Server Backups Using Managed Identities
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Forums
Update particular record in a table
I need to update greatherthan8 (category) record to Missing (status) if the same member...
Internationalisation
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Size of DB on physical disk doesn't match Disk Usage by Table report
Hi everyone I am looking at the size of my db on disk (ie...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers