Tag: SQL Server Consultant

SQL Server Performance Office Hours Episode 1

Posted on by Erik Darling

SQL Server Performance Office Hours Episode 1

Do you like me? Y/n
Does Erik prefer nested loops or fruit loops?
If Erik was an operator in an execution plan plus, what operator would he be?
Sometimes my sql server quits responding so I reboot it but then it takes forever to come back online. Is there an easier way to corrupt my data? PS I’m running on prem with azure disks so latency is a little high but usually performance is good. Also hi Erik, this was a test to see how many words I could fit into a form.
Can you fix my server performance for free? Here’s my execution plan <?\stmtsimple(@2$?@38,!@/&!;,$-“2(,&~¥’c/&1@,’]+_•
Can I edit my response?
Are you free later
What is the best Champaign to buy someone when you find out they don’t have to use Microsoft Fabric?
Hi Erik. Im having huge problems with a table that stores text files in a varchar(max) column. Can you suggest an alternative to that? Thanks
Where’s the beef?
What do you wish that more DBAs have read? Specific books, blogs, etc.

To ask your questions, head over here.

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.

A Little More About Parameter Sensitive Plan Optimizations In SQL Server 2022

Posted on by Erik Darling

A Little More About Parameter Sensitive Plan Optimizations In SQL Server 2022

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.

A Little About Choosing Index Key Column Order

Posted on by Erik Darling

A Little About Choosing Index Key Column Order

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.

The State Of Table Variables In 2025

Posted on by Erik Darling

The State Of Table Variables In 2025

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.

A Fun Plan Shape With Aggregates In SQL Server

Posted on by Erik Darling

A Fun Plan Shape With Aggregates In SQL Server

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.

When Subquery Query Plans Are Suboptimal In SQL Server (And How To Fix Them)

Posted on by Erik Darling

When Subquery Query Plans Are Suboptimal In SQL Server (And How To Fix Them)

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.

Better Filtering With YEAR and MONTH Functions In SQL Server

Posted on by Erik Darling

Better Filtering With YEAR and MONTH Functions In SQL Server


This week, I’ve got a coupon that offers an even steeper discount on my training than the one at the bottom of the post.

It brings the total cost on 24 hours of SQL Server performance tuning content down to just about $100 USD even. Good luck finding that price on those other Black Friday sales.

It’s good from December 23rd-27th, or until I remember to turn it off. Hurry along now.

Thanks for watching!

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.

The Great Integer To Bigint Compression Swindle

Posted on by Erik Darling

The Great Integer To Bigint Compression Swindle


Thanks for watching!

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.

SQL Saturday New York City 2025 Is Coming Your Way In May!

Posted on by Erik Darling

You Know You Wanna

After a brief hiatus due to some paperwork difficulties, SQL Saturday NYC is back in action this May 10th!

The event will be taking place at the Microsoft offices located at 11 Times Square, New York, NY 10036, with a full day precon session on May 9th.

See you there!

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.

Indexing SQL Server Queries For Performance: Computed Columns

Posted on by Erik Darling

Indexing SQL Server Queries For Performance: Computed Columns


Thanks for watching!

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.