Viewing 15 posts - 19,606 through 19,620 (of 22,226 total)
Gayathri.Varadarajan (9/12/2008)
...Also the business functionality is so that the PK has to be updated...
At this point, you're totally violating the idea of a primary key. You may have a unique...
"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
September 12, 2008 at 5:54 am
Many happy returns of the day, Steve.
For myself, a good bottle of single malt scotch is all I need for happy birthday... or a happy any other day for 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
September 12, 2008 at 5:42 am
matt stockham (9/11/2008)
Grant Fritchey (9/8/2008)
"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
September 11, 2008 at 2:39 pm
No. I'm not getting this one. Sorry. I've only done about four installs so far (not counting CTP's), but no issues at all... So far... knock wood.
"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
September 10, 2008 at 2:29 pm
I'll shut up now and go and stand in the corner.
"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
September 10, 2008 at 11:20 am
Without a doubt it's going to be better than reading twice every time, definately. I've had to fix that problem WAY to often myself. I was just curious how many...
"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
September 10, 2008 at 8:47 am
Yeah, you can do that without recompiles. Does it cause excessive scans or reads in the table since it's searching for a PK that doesn't exist every single time?
"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
September 10, 2008 at 8:26 am
It's not a huge deal to do this, but it will result in recompiles on the procedure since the execution plan for an UPDATE and one for an INSERT are...
"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
September 10, 2008 at 7:23 am
TRY/CATCH won't help performance, but it will make your code easier to write & maintain.
Can you post an execution plan? If possible, the actual execution plan not the estimated one.
"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
September 10, 2008 at 6:56 am
Paul DB (9/10/2008)
Steve Jones - Editor (9/9/2008)
Why not just use the SELECT UNIONS instead of the temp tables in the select? It appears that you're using static values in there.
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
September 10, 2008 at 6:34 am
There is so much code missing from this query, it's hard to see where you're going wrong. First, using sp_executesql is for working with dynamic TSQL. Nothing in this query...
"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
September 10, 2008 at 6:30 am
This is psuedo-code, but something along these lines:
CREATE TABLE #MyIDs
(ID int)
INSERT INTO TableA
(...)
OUTPUT INSERTED.ID
INTO #MyIDs
SELECT ...
FROM TableB
Then you can obviously do what you want with the temporary table. use...
"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
September 10, 2008 at 6:25 am
I'm not a RAID expert, but having seperate file groups on different drives will be faster than all the filegroups on one drive, yes.
"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
September 10, 2008 at 6:11 am
Or, rather than hard coding all those values in a query, create a table and store them there. It'll sure make maintenance easier.
"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
September 10, 2008 at 6:09 am
Can you break it down and run a couple of steps at a time? I tried duplicating the script in miniature and it worked fine.
CREATE TABLE x ( id INT,...
"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
September 10, 2008 at 6:07 am
Viewing 15 posts - 19,606 through 19,620 (of 22,226 total)