Viewing 15 posts - 6,061 through 6,075 (of 22,226 total)
Not that I'm aware of. If I try to use code in that fashion it generates an error. You could substitute a local variable or hard code a value, but...
"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:26 pm
Brandie Tarvin (5/20/2015)
Grant Fritchey (5/20/2015)
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...
"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:11 pm
Tom_Sacramento (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:10 pm
Eirikur Eiriksson (5/20/2015)
GilaMonster (5/20/2015)
Eirikur Eiriksson (5/20/2015)
Grant Fritchey (5/20/2015)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!I could see this one coming miles away, surprised how long it took.
😎
If it's the one I'm thinking of, I hit 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 12:36 pm
GilaMonster (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 random query hint. Things...
"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:33 pm
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
Viewing 15 posts - 6,061 through 6,075 (of 22,226 total)