Forum Replies Created
Viewing 15 posts - 4,546 through 4,560 (of 5,685 total)
-
RE: Need some help with a large data volume optimization
Paul White NZ (12/14/2010)
Craig,For the deletes, use this:
DELETE psa
FROM #DelPortList AS dpl WITH (TABLOCKX)
JOIN PortSecAgg AS psa WITH (TABLOCKX)
ON psa.PortfolioID = dpl.PortfolioID
AND...
-
RE: How to Make a Dynamic Stored Procedure Query
dso808 (12/15/2010)
Hi Gail - to intialize @Where, I did this right after declaring it:SET @Where = ''
When I tried to do this:
@Where NVARCHAR(4000) = ''
I got this error message:
Cannot assign...
-
RE: Are the posted questions getting worse?
WayneS (12/14/2010)
Gail, are you trying for sainthood?Yeah, she is.
-
RE: Are the posted questions getting worse?
Steve Jones - SSC Editor (12/14/2010)
Is it now more, or less, frightening?I'm now wishing I was underwater in the scuba gear... kilts skeer me! Won any blue ribbons you...
-
RE: Need some help with a large data volume optimization
LutzM (12/14/2010)
Any chance to post the index def for #DelPortList and PortSecAgg? It seems like the clustered indexes don't match.They don't, not directly.
#DelPortList's index is in the proc, listed here...
-
RE: Need some help with a large data volume optimization
JAWDROP.
Step - Find duplicated AsOfDate/PortIDs between batches: 75 seconds.
Step - Remove duplicated AsOfDate/PortIDs between batches: 0 seconds.
Step - Declare and open cursor: 0 seconds.
Step - Insert into #DelPortList for Batch...
-
RE: View is not ordered. Why?
evald (12/14/2010)
It seems that Microsoft agree with mehttp://support.microsoft.com/kb/926292
I'm going to verify if this hotfix is installed on my sql server and also i'll verify on a sql server 2008
Of...
-
RE: Need some help with a large data volume optimization
Ignore this, bad post.
-
RE: Need some help with a large data volume optimization
Alrighty. So, status update on the processing so far.
I am still doing an all file load to the _staging table. The reason for this necessity is some business...
-
RE: Are the posted questions getting worse?
GilaMonster (12/14/2010)
Brandie Tarvin (12/14/2010)
(Where's my halo? Self-righteous doesn't work without my halo, darnit!)How long did it take you to forge your own halo, in between the lightning strikes, Gail? ...
-
RE: Login Failed error when trying to browse SSIS packages
bleach (12/14/2010)
Yes, indeed I see that service running on the server. I've attached a screen shot.Then it's got to be login related, or a serious glitch on the system....
-
RE: Are the posted questions getting worse?
GSquared (12/14/2010)
Alvin Ramard (12/14/2010)
Stay out of the gutter Gus. It's crowded enough in here without you. 😛Trust me, I am WAY below the gutter.
Marianas Trench is uphill from...
-
RE: Login Failed error when trying to browse SSIS packages
This is sounding like SSIS wasn't installed, at all.
Can you check the services on that machine, make sure you see a running SQL SERVER INTEGRATION SERVICES on that system? ...
-
RE: Round to next 1000 or 100 without Ceiling function
For some reason straight integer divide didn't want to work here, I had to actually convert it on my 2k5. Wierdness.
declare @numeric decimal(32, 8)set @numeric = 1.02
print ( CONVERT(...
-
RE: Need some help with a large data volume optimization
Gyeah!!!! Hold on Paul! 😀
My word man, you make me look like I never type anything! 😛 Though, I appreciate the extensive discussion. Don't misunderstand.
Going to tackle...
Viewing 15 posts - 4,546 through 4,560 (of 5,685 total)