Viewing 15 posts - 20,806 through 20,820 (of 22,219 total)
I'm guessing something else in the code because I took your example, added a statement, and it's running just fine.
CREATE PROCEDURE [dbo].[Sp_Update_Fact] AS
BEGIN
...
"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 20, 2008 at 10:56 am
DBA (3/20/2008)
the execution plan shows a couple of parallelism cost 1% and a couple of hash match cost 2%. No index scans.
That's 3% of the cost. The other 97%?
"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 20, 2008 at 10:42 am
sqluser (3/20/2008)
But i need to do the same for all the table columns having uniqueidentifier.---
The first query will show you all tables and all columns with uniqueidentifiers. You'll 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
March 20, 2008 at 8:03 am
Since there are likely to be more wars (unfortunately) why not set up a table of wars with the appropriate date ranges and then join against it? That way you...
"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 20, 2008 at 7:31 am
Worth mentioning, did you look at the execution plan?
"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 20, 2008 at 7:24 am
First off, if these are primary keys and you have referential integrity, you have a MAJOR task in front of you. Why would you want to do something like this?
Otherwise,...
"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 20, 2008 at 7:12 am
I would add to the Administrative costs a very high cost to implement changes. Tune one procedure, deploy it 200 times. Modify one column, rebuild 200 tables in 200 databases...[shudder]
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
March 20, 2008 at 6:58 am
I wouldn't have expected all those cache misses (miss's?) either. What did the test procedure do? Take a look at the link posted above to see if the test proc...
"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 20, 2008 at 5:44 am
Hey, I lead a pack of Cub Scouts. I'm responsible for teaching them the "Fart Song."
[to the tune "The Yellow Rose of Texas"]
Oh, my body has a passage 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
March 19, 2008 at 11:28 am
Whoa! Hold on. Revelation! People who come out of college are mature adults? Hmmm... To ask this in the proper SSC manner, you have a test that proves 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
March 19, 2008 at 10:43 am
jburkman (3/19/2008)
I've read this excellent thread, I see the vibrant knowledge and experience of the participants, and I'm de-lurking 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 19, 2008 at 8:56 am
The default installation of AdventureWorks is case sensitive.
"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 19, 2008 at 7:05 am
Oh wow. That is depressing. I'm going to go reread Rendevous with Rama.
"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 19, 2008 at 6:56 am
I tried it two ways. I set up a table with a million rows for the tests.
This way works very well, with a nice index seek and only four...
"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 19, 2008 at 6:51 am
Crud. I completely misread your question. Disregard my last post. I'm an idiot.
Why can't you simply do a join against your table? Especially since we're talking about a distinct list,...
"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 18, 2008 at 12:00 pm
Viewing 15 posts - 20,806 through 20,820 (of 22,219 total)