Viewing 15 posts - 17,836 through 17,850 (of 22,226 total)
GilaMonster (4/2/2009)
Grant Fritchey (3/27/2009)
"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
April 2, 2009 at 5:38 am
Yeah, Barry's right, table variables aren't logged, but what is it that you're doing that's causing so much logging?
"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
April 1, 2009 at 7:34 pm
I think Gail has it right. They "fixed" the incorrect behavior from 2000. That leads to problems like what you encountered.
"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
April 1, 2009 at 8:14 am
I don't see it on her blog[/url]. It was in a presentation she gave at the PASS Summit last November.
"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
April 1, 2009 at 8:03 am
plavec (4/1/2009)
Tx for your help. We changed model and solved problem.But still I'd like to know if somebody knows how to makes compensation for FORCESEEK in 2005 or 2000.
Nice to...
"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
April 1, 2009 at 7:57 am
Maybe I'm wrong. Wouldn't be the first time (today). Hang on, testing... might be a while.
"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
April 1, 2009 at 7:47 am
Regardless of default schema, if you don't reference the schema in the query, SQL Server will try to find the query in dbo. I don't think it's a bug. 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
April 1, 2009 at 7:19 am
It doesn't look like it from the code you showed, but are you using qualified names in the queries?
SELECT *
FROM schema.table
--not
SELECT *
FROM table
That would absolutely explain the problem.
"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
April 1, 2009 at 6:11 am
According to the Upgrade Advisor column aliases in the ORDER BY clause cannot be prefixed by the table alias.
Why not try dropping the alias and then using the column name...
"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
April 1, 2009 at 6:07 am
Generally, I use the COUNT(*). It's pretty much guaranteed to be accurate. Gail Shaw showed how it will pick an index with the least number of pages to satisfy 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
April 1, 2009 at 5:52 am
If you're comparing two different data types, char & nchar, then you'll get an implicit convert in the engine which will prevent the use of indexes. So yes, there 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
April 1, 2009 at 5:49 am
It's not considered to be a good practice to place procedures in the system databases (except for model). The caveats in the article are true, but they don't emphasize 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
April 1, 2009 at 5:44 am
Financial Testing Server
User Acceptance Testing Server
Performance Testing Server
Continuous Integration Server
Production Support Server
Sandbox Server
You can add them as you need them. They're all just SQL Server servers, just supporting different processes...
"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
April 1, 2009 at 5:39 am
Bob Hovious (3/31/2009)
... just kidding...
... at least to...
"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 31, 2009 at 8:45 pm
End 2 End Training are great guys. You'll learn a ton. I'm not sure who you'll be working with, but tell them Grant says hi.
"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 31, 2009 at 8:44 pm
Viewing 15 posts - 17,836 through 17,850 (of 22,226 total)