Viewing 15 posts - 18,316 through 18,330 (of 22,220 total)
That's kind of a wide PK, depending on the data types. Can you post the execution plan? Actual please, not estimated.
"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 19, 2009 at 7:56 am
I'm still trying to untangle the code (did you really need to put comments at the end of every line?), but if this is functional as an inline UDF, 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
February 19, 2009 at 7:48 am
Lynn Pettis (2/19/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 19, 2009 at 7:46 am
What is it that you're actually trying to do?
Just so you know, the code you posted ran in 89ms on my desktop (not the fastest machine on earth either).
"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 19, 2009 at 6:48 am
It sounds like the database is in FULL recovery mode. So you need to institute log backups. Depending on your data needs, you could set the database to SIMPLE recovery...
"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 19, 2009 at 6:45 am
harsha.bhagat1 (2/19/2009)
I have a procedure which has to insert into a table in different database and then will delete those data from the related tables. There are more than...
"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 19, 2009 at 6:43 am
OK. Now I have questions. My contacts & calendar are managed through Outlook and my phone (Blackberry currently, going to change soon). Can you sync that with one of these...
"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 19, 2009 at 6:21 am
GilaMonster (2/19/2009)
Grant Fritchey (2/19/2009)
It makes me wonder what people do all day at these jobs they've been slogging away at for years.
From prior experience working with people like 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 19, 2009 at 6:19 am
GilaMonster (2/19/2009)
Roy Ernest (2/19/2009)
My problem is the management says I am too tough when giving interviews.
My former management used to tell me the same thing. So I expect that people...
"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 19, 2009 at 6:15 am
Nomvula (2/19/2009)
hi guysthanks for the responses, and yes you were right, i got rid of the cursor and used a normal update query and it worked a bit faster..
thanks again
Welcome...
"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 19, 2009 at 6:13 am
Excellent article. Thanks. I only wish I could use Firefox at work. Still, this is some interesting stuff. No, I hadn't been using a wiki to manage my info. I'm...
"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 19, 2009 at 5:58 am
For many years now I've been doing interviews for senior level DBA's and I've consistently received resumes with between 5-10 years of experience from people. These individuals don't know 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 19, 2009 at 5:53 am
Hmmm. That is odd. I had a short period where our local spam blocker was taking out the daily emails, but never the discussion alerts.
Let me know if you got...
"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 18, 2009 at 8:40 pm
From the description it sounds like an inline function, but I have to ask, is it? If it's a multi-statement UDF, that could explain the performance issues too.
"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 18, 2009 at 6:09 pm
Thoughts?
I wish I was a consultant who worked near your office so I could make all the great money that's going to roll in when those queries have to 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 18, 2009 at 6:05 pm
Viewing 15 posts - 18,316 through 18,330 (of 22,220 total)