Viewing 15 posts - 17,251 through 17,265 (of 22,219 total)
It sounds like parameter sniffing (do a search on that phrase for volumes of information).
But, statements like this in your WHERE clause
abs(abs(a.value)-abs(b.value)) >= @threshold
Are going to prevent index use in...
"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
June 10, 2009 at 7:01 am
The very nature of SQL Server is try to make it possible for lots of people to read the same data at the same time. Reading data, not updating/deleting 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
June 10, 2009 at 6:51 am
There used to be several tools available for reading log files. I know that Idera had one as did Red Gate. I'm pretty sure Red Gate's is gone. I'm not...
"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
June 10, 2009 at 6:44 am
Yeah, it was the number of plan guides that you'd need that made me balk. You can create a plan guide for an ad hoc query, but any variation in...
"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
June 10, 2009 at 6:25 am
Well done. Extremely thorough, accurate, well written... but what's with the attached Word file?
"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
June 10, 2009 at 6:15 am
MarkusB (6/10/2009)
Any psychics around who can help this onehttp://www.sqlservercentral.com/Forums/Topic732091-266-1.aspx
I can't read minds, but I can see the future...
I see... I see... a dba-wanna-be on the street, looking for work... 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
June 10, 2009 at 6:07 am
Bare, bare, bare minimum, run sp_who2 to see if you have blocked processes. From there, you need to delve into all the skills of troubleshooting and investigation. Without at least...
"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
June 10, 2009 at 6:06 am
I started out using various nicknames, but when I published my first article with Steve, he asked me to change my nickname to my real name... and so it has...
"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
June 9, 2009 at 11:25 am
Actually, though... thinking about it. I'm not sure you could make a plan guide work. Hmmm... that might be tough.
"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
June 9, 2009 at 9:10 am
You can using a hint, but since this is ad hoc (right?) you'll need to use a plan guide.
"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
June 9, 2009 at 9:09 am
Excellent.
So you are using forced parameterization 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
June 9, 2009 at 8:44 am
The different plans from the web is probably, but not definately, because of differences in the type of connection or settings within the connection. If you drill down on all...
"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
June 9, 2009 at 8:31 am
GSquared (6/9/2009)
Steve Jones - Editor (6/8/2009)
Back from SQLSaturday #14 in Pensacola, what did I mess?
Okay, Steve. Normally I back you up when you have typos in articles and someone...
"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
June 9, 2009 at 8:23 am
Well, again, any plan will be cached and could be reused. As to whether or not simple is doing what you want, when you look at the query text in...
"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
June 9, 2009 at 6:45 am
You might want to pick up a book on the topic. It's as old as the hills in computer terms, but Flemming & von Halle's Handbook of Relational Design is...
"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
June 9, 2009 at 6:40 am
Viewing 15 posts - 17,251 through 17,265 (of 22,219 total)