Writing my presentation part 1: The brainstorm/dump
For this session, I’m relying on a mixture of previous blog posts and new material/demos that I’ll have to write....
2019-03-07
387 reads
For this session, I’m relying on a mixture of previous blog posts and new material/demos that I’ll have to write....
2019-03-07
387 reads
So, I’m presenting a session at SQL Saturday Chicago on March 23, 2019. This is a new session, called Performance...
2019-03-06
254 reads
I just discovered this the other day and I had to share it.
First, we need a query in Management...
2019-03-05
589 reads
In Partitioning 2, I showed how to analyze which partitions were accessed by our Index Seek. However, we were searching...
2019-03-04 (first published: 2019-02-14)
1,823 reads
Combining a few themes of recent posts today. I’ll mix in some sp_executesql, it’s always parameter sniffing, and the plan...
2019-02-28
935 reads
Last week I talked about single use plans. One way to increase execution plan re-use is to parameterize queries by...
2019-02-27
1,464 reads
Here’s my take on partitioning. I’ll be focusing on getting queries to perform on partitioned tables, and not on partition...
2019-02-27 (first published: 2019-02-11)
2,393 reads
To add onto yesterday’s post about which cardinality estimator (CE) your query will use, there’s an additional complexity. This specifically...
2019-02-26
799 reads
SQL Server 2008 is reaching end of support this year, so upgrading your SQL Server might be on your mind....
2019-02-25
439 reads
The series is alive! It’s been a while since I last talked about memory grants. Don’t worry, I still care...
2019-02-21
349 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Have anyone implemented CDC, and if so, what has been your experience with it?...
I'm getting a error when using the Import and Export wizard to copy tables...
I have joined a new project, where the business uses Azure SQL Hyperscale for...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers