Forum Replies Created
Viewing 15 posts - 1,171 through 1,185 (of 22,219 total)
-
Reply To: Volunteer For Something
steve.powell 14027 wrote:Strangely, during the first lockdown, when I (a DBA, mind) was furloughed (but not for long - they realised their mistake quickly enough) I went looking for things to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Volunteer For Something
sean redmond wrote:I used to do a lot of volunteering when I was a child but I have since lost that charitable spirit. I do have much less free time but...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Volunteer For Something
zintp wrote:Grant, you are a busy man! What timely post, b/c I was just thinking that I might have stop my volunteer work with the PA Master Naturalist group because...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Volunteer For Something
meelan wrote:Hi Grant
Nice post and Thanks
By the way, what is your call sign?
KC1KCE
And thanks.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.
Jeff Moden wrote:VoldemarG wrote:Thank you very much for the valuable feedback. So does my suggestion to add more data files to TempDb sound reasonable then?
To me... no. Even if you do...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.
How many files do you have now?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: In-Place upgrade from SQL Server 2016 to SQL Server 2019 leaves older version
It sounds like you didn't actually do an upgrade. By default, assuming no instance names, running the install against an existing instance, it will replace it. You should go back...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.
Without execution plans, I'm guessing here.
Changes in statistics caused a change in execution plans. Changes in data caused a change in behavior (as data changes, row counts change, which causes...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Conditional Where
AH!!!
Sorry. I really did misunderstand.
So, Ken is right. Don't do that. That is two, distinct queries. While yes, there are ways to force them into a single procedure or batch,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Script to find session running SQL text and kill session
It's just a loop that's needed. Try using the SELECT statement above and create a cursor. Then execute an a dynamic statement with the kill and the session_id value.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Azure data studio editor tabs
Ah, and another clarification. I was wrong about the numbers being statements. It's count of lines of code that the tool thinks may have problems. That's why one tab has...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Azure data studio editor tabs
I did a little more research and testing and I've got it. "M" in this case means that you've got a script that's in source control. You've made changes to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Azure data studio editor tabs
I think I've got it. The M, not sure why M, appeared when I had an uncommitted change in source control. I staged it and then committed it, and the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Azure data studio editor tabs
The number I have. It's the number of statements that have perceived problems.
Those three tabs have exactly that number of SQL statements in each that looked wrong...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Reply To: Full Recovery Database restores as Simple Recovery
I'm leaning toward what Scott says. Check the model database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 1,171 through 1,185 (of 22,219 total)