Viewing 15 posts - 6,061 through 6,075 (of 22,221 total)
Jason A. Long (5/20/2015)
Brandie Tarvin (5/20/2015)
Grant Fritchey (5/20/2015)
AAARRARARRGGGGHHHH!!!
Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply 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
May 20, 2015 at 12:32 pm
SELECT TOP 10 without any kind of ORDER BY or WHERE clause? If so, that's going to result in an index scan. That could be the issue right there. Having...
"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
May 20, 2015 at 11:16 am
Can you clarify at all what you mean by "real time"?
That doesn't define much in general within SQL Server. All the SELECT queries are run "in real time" in that...
"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
May 20, 2015 at 11:13 am
Again...
AAARRARARRGGGGHHHH!!!
Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint. Things are a little...
"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
May 20, 2015 at 9:07 am
mdsantos (5/20/2015)
Analysing the "bad" execution plan, I notice that the searches where done with index scan instead of index seek, incresing drastically 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
May 20, 2015 at 9:02 am
audiocool (5/20/2015)
Hi Grant,I will compiled the results you are looking for tomorrow.
Thanks.
Sure thing. Trying hard to help out.
"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
May 20, 2015 at 7:41 am
Ed Wagner (5/20/2015)
Grant Fritchey (5/20/2015)
Ed Wagner (5/20/2015)
Also, be aware that this is a cultural battle that you're going to fighting, so it won't be a simple one.
I agree...
"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
May 20, 2015 at 6:24 am
The documentation is part of the command line install documentation. You can. You just have to specifiy uininstall and the services that you have installed as well as the instance...
"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
May 20, 2015 at 6:16 am
Ed Wagner (5/20/2015)
Brandie Tarvin (5/20/2015)
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!Dare we ask?
How about a link? You're normally so patient that it ought to be good. 😛
We've been beating this person about 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
May 20, 2015 at 6:12 am
Ed Wagner (5/20/2015)
Also, be aware that this is a cultural battle that you're going to fighting, so it won't be a simple one.
I agree with everything you said,...
"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
May 20, 2015 at 6:10 am
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!
"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
May 20, 2015 at 4:08 am
arrjay (5/20/2015)
So a restore will write to disk, and at a later date SQL will write the data to memory once the user starts querying 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
May 20, 2015 at 4:07 am
Also, look at your cost threshold for parallelism. If it's at the default value of 5, it needs to be bumped up.
"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
May 20, 2015 at 4:07 am
audiocool (5/19/2015)
Hi Grant,First of all, I would like to thanks for your effort for trying to help me on this.
Below is the output that you require:
Wait_Stat:
Query Stat
https://drive.google.com/file/d/0B7H-a08logDcdEY1WmY2bEo2Rlk/view?usp=sharing
Sorry. My fault. I...
"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
May 20, 2015 at 4:03 am
audiocool (5/20/2015)
"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
May 20, 2015 at 3:42 am
Viewing 15 posts - 6,061 through 6,075 (of 22,221 total)