Viewing 15 posts - 2,191 through 2,205 (of 22,232 total)
You're going to need more and deeper information here. CXCONSUMER is a standard wait that simply means parallelism is occurring. It's not in any way actionable. You can read "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 9, 2020 at 1:13 pm
If you TRUNCATE all tables, you better have a script handy to repopulate ALL your necessary reference tables. 😉
Aren't those already in source control too?
"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
January 8, 2020 at 11:28 pm
Another possibility is extracting a DACPAC for the DB in question and building an empty one from that.
I generally dislike DACPAC, but this might be a great use of...
"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
January 8, 2020 at 2:30 pm
Also, in SQL Server, when you're looking at a clustered index, remember, that's the table. The data is stored with the clustered index. There isn't any kind of separation between...
"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
January 8, 2020 at 2:08 pm
I wouldn't worry about sp_MSForEachTable going away.
However, if we're really doing this all the time, nuking the entire database. What about just having an empty one available and run 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
January 8, 2020 at 1:31 pm
Certainly, your intent is the right one. A loop is just a horrible way to code within SQL Server (depending, looping through tables for maintenance, looping through databases for backups,...
"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
January 8, 2020 at 12:44 pm
I'm always puzzled as to ask the question I had in this forum. I know a lot of people don't want to record their presentations, but I'm looking for...
"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
January 8, 2020 at 12:39 pm
If I were tuning this query. I'd take it apart. Get the root table and ensure that I'm pulling only the rows out of that in which I'm interested. Then...
"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
January 8, 2020 at 1:11 am
I didn't even notice it earlier, but the older version of the plan had a missing join predicate. The structure of this query is in dire straights.
How big are these...
"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
January 7, 2020 at 8:22 pm
You're still looking at 2.4 million rows estimated and 46.8k actual. That's an enormous disparity. What other functions do you have in there? You also have filters that aren't doing...
"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
January 7, 2020 at 8:05 pm
I just asked someone else in this thread:
What would be a good way to get presenters to record their presentation the day before they gave it?
Not sure that's always...
"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
January 7, 2020 at 6:16 pm
Good! Use your aggressive feelings, boy. Let the hate flow through you!
HA!!
From the reviews I've heard, I was right though.
It's a real shame. I did love the universe set...
"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
January 7, 2020 at 3:02 pm
Don't put your face in them. I stopped recording videos about 9 months ago. I'm going to get back on it, but change the format a bit. No more "video"...
"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
January 7, 2020 at 2:54 pm
I hear you. Thinking about it some more, while a bit of a pain, I don't see any way this is dangerous. Sure, you have a few more files, so...
"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
January 7, 2020 at 2:48 pm
It's estimating 1.9 million rows and moving 500k. That's my first concern, not the spool. The spool is in place so that it doesn't have to do that scan over...
"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
January 7, 2020 at 2:36 pm
Viewing 15 posts - 2,191 through 2,205 (of 22,232 total)