Viewing 15 posts - 1,981 through 1,995 (of 22,219 total)
Oddball code bug related to rescheduling QOTD. It was scheduled for one day, moved to another, that affected the link. They're working on it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 2:11 pm
Cheers Grant
Testing appears to be working, so I'm going for it. Just wondered if anyone else had tried.
I may ask a loaded question at one your SQL Bits sessions...
@Frederico...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 2:09 pm
Word is, it should be good now.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 1:48 pm
We need to fix it because I suspect there will be a little bit of a brouhaha about the question & answer today.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 1:01 pm
Nope, sorry, still not working. I'm speaking about "Join the discussion and add your comment" link at the end of the answered page. This also happened last week with...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 12:51 pm
I can't find anything saying one way or the other in Microsoft's documentation or on the real source of information, Niko's blog. I'd say if it tests out, it works....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 12:48 pm
Nope, sorry, still not working. I'm speaking about "Join the discussion and add your comment" link at the end of the answered page. This also happened last week with...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 12:45 pm
Yep. Reinforce the correct answer.
Set a max memory that leaves a little bit for the operating system and walk away. SQL Server will use the memory you give it. And,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 12:32 pm
To say the spid was never blocked doesn't mean it's not waiting on resources. It is. It's moving all the pages around. It can't move them while there are shared...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 12:27 pm
Check to see if you have a filter set. Try hitting refresh. Go and query the history table directly.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 12:25 pm
Slightly-OT: I think the discussion link for the 2020-02-11 QotD ("Execution Plan Types") is wrong, it currently points to this editorial. Could someone please fix that?
I didn't "fix...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 12:10 pm
Shocklingly enough, I got this one right.
Yeah, I know, I know. But I'm helping to keep an eye on the site with Steve on sabbatical. Part of this means I'm...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 12:09 pm
I'm currently doing the last bits & pieces of a DWH Upgrade / Replacement to 2017 and I already am screaming for SQL Server 2019 (MDS learns how to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 11:58 am
I know of a company that paid an astronomic sum to keep a warehouse distribution system supported on obsolete hardware and a long obsolete version of the software.
They had...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 11:57 am
I agree with everything you said but, with all the really cool stuff that's been built into SQL Server in the last 8 years, couldn't you have cited a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 11:54 am
Viewing 15 posts - 1,981 through 1,995 (of 22,219 total)