Viewing 15 posts - 8,566 through 8,580 (of 22,219 total)
A literal is a string or number used within the query, not a variable or a parameter, but a literal value.
Then, the plan isn't cached. Period. It's not inside or...
"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
March 25, 2014 at 5:49 am
Try running the query without the WHERE clause. You'll note that there are tons of plans right there in the cache that are larger. If there is a literal within...
"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
March 25, 2014 at 4:24 am
It completely depends on how the constraints are defined. The primary pain points, if any, will be on inserts and updates. It won't affect selects at all. The best answer...
"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
March 25, 2014 at 3:52 am
We're going to need you to come in this weekend to work on those TPS reports, mmmkay?
"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
March 24, 2014 at 4:09 pm
GilaMonster (3/24/2014)
Ed Wagner (3/24/2014)
Lynn Pettis (3/24/2014)
I don't know why, but this sort of thing scares me.
WOW! Now that's enough to scare anyone. Just think...he has access to the...
"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
March 24, 2014 at 3:20 pm
You could put in a start up procedure that sends you an email each time the server comes online. That wouldn't tell you it was going down, but it would...
"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
March 24, 2014 at 3:18 pm
There isn't a single path to the goal. You actually sound like you're already doing a lot of what many DBAs do for their entire career, set up servers, 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
March 24, 2014 at 3:14 pm
The query is the better approach.
The index is fragmented. It's just not very fragmented. 34% is fairly light. As for scripts, just search for the names that I provided. You'll...
"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
March 24, 2014 at 12:02 pm
mrupperman (3/24/2014)
Grant Fritchey (3/24/2014)
Nope. I keep getting errors in the XML when I try to open it. Did you edit the plan?
No, I just created the plan and saved 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
March 24, 2014 at 11:59 am
Nope. I keep getting errors in the XML when I try to open it. Did you edit the plan?
"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
March 24, 2014 at 11:31 am
Are there differences between the cost threshold for parallelism between the two? How about optimize for ad hoc? Are there differences in the amount of memory or CPU? When you...
"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
March 24, 2014 at 11:28 am
Without seeing the indexes, I can't even guess at what to do.
"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
March 24, 2014 at 11:25 am
A seek is dependent on the WHERE clause being able to use the statistics that define the data stored on the index. Not seeing your query, I can't make suggestions...
"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
March 24, 2014 at 11:23 am
I'd suggest using extended events. You can capture the recompiles and you can filter the event so you're only capturing information for the query or stored procedure in question. It's...
"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
March 24, 2014 at 6:54 am
Backing up across a network like that can be slow. A better approach is to backup locally and then copy the backup over. That way, the copy process can run...
"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
March 24, 2014 at 5:13 am
Viewing 15 posts - 8,566 through 8,580 (of 22,219 total)