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.
Erik
Not sure your office hours link is fully operational.
Using chrome and it just spins and spins
Thought you should know
wanted to ask a question about the following error message that I received on sql server 2022 while trying to update statistics
Msg 3739, Sev 11, State 1, Line 2 : Cannot DROP the index ‘dbo.ScoreMaster._WA_Sys_SurveyId_2C041907’ because it is not a statistics collection. [SQLSTATE 42000]
This occurs with “Sort based statistics” — would like an explanation if convenient
Googled a ton but no real answers as to what either means or how it is generated in sql server
thanks in advance
BB
Follow the instructions in the video to ask a question for Office Hours. Thanks!
followed every link using both chrome and edge and all that happens is a spinning icon.
including https://go.erikdarling.com/OfficeHours
No problems here. It might be something to do with a work VPN or browser security?
This is on sql server 2019. How much wood would a woodchuck chuck if a woodchuck could chuck wood?
Your mom.
Thanks Erik really enjoyed it
Even thinking of changing my preferred cereal to fruit loops
Toucan do it!
If I have a question to post for next week in regards moving a production database from 2014 compatibility mode to 2022 which is the server it sits upon. How do I do this
The instructions are in the video. Give it a watch.