Viewing 15 posts - 18,421 through 18,435 (of 22,220 total)
Ah, SQL Server 2000, you need to follow Steve's advice then.
BTW, this is the SQL Server 2005 forum that you posted in. You will get different answers to questions depending...
"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
February 11, 2009 at 6:46 am
Based on the structure and the statement, this sounds like homework. What have you tried so far that hasn't worked?
"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
February 11, 2009 at 6:43 am
dbo is a system schema. It can't be changed. You just need to add a schema and then make it the default.
"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
February 11, 2009 at 5:52 am
Do you mean you have 500 stored procedures that all have the same parameter and you want to change the data type? That's a pretty odd configuration.
Best bet would be...
"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
February 11, 2009 at 5:50 am
Just a question, it says "SQL Server 200" is the last digit there a "0" or a "5"? If it's 2005, you can use TRY/CATCH to catch the deadlock error...
"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
February 11, 2009 at 5:43 am
sp_msforeachdb is a cursor.
You can use the INFORMATION_SCHEMA system views. Specifically INFORMATION_SCHEMA.TABLES. These are common between SQL Server 2000, 2005 and 2008, so are a much better place to program...
"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
February 11, 2009 at 5:39 am
As Lowell and I both said... No.
"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
February 11, 2009 at 5:21 am
OK. So you want to pre-aggregate the data. This is an operation that is best done in the off hours. I'm not sure why you're so obsessed with the amount...
"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
February 11, 2009 at 5:20 am
Great. Glad to hear it. It gave me a little blog post, so it's all good.
"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
February 10, 2009 at 5:06 pm
Alvin Ramard (2/10/2009)
Psychology:
"I have a client who is a DBA and suicidal. What do I tell them?"
You don't have to worry about that one. His problems will go...
"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
February 10, 2009 at 4:58 pm
Yep, Gail's right on this one too (you can usually just assume that).
The only thing cached is the expanded query, which again, the query against the table is cached as...
"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
February 10, 2009 at 1:28 pm
If you mean that the database goes away due to a media failure and you were unable to backup the log file, then you can only restore up 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
February 10, 2009 at 12:34 pm
MVIR (2/10/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
February 10, 2009 at 11:12 am
Took a little bit of experimentation, but this worked. Right click on the tab, change the window to floating. It will detach and be somewhere on your screen. Right click...
"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
February 10, 2009 at 11:08 am
Unfortunately, that image is just shy of useless.
You're getting index scans. That means that the index is not being used effectively. Index scans & hash joins pretty much indicates 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
February 10, 2009 at 10:44 am
Viewing 15 posts - 18,421 through 18,435 (of 22,220 total)