Viewing 4 posts - 1 through 4 (of 4 total)
Thanks Steve that's great, that's the kind of answer I'm looking for.
November 16, 2010 at 11:24 pm
Hi
It's a clustered index on an Int column, identity (1,1)
I think it's volume.
I am considering hash partitioning, ie breaking up the table into 4 parts to begin with, horizontally partitioned...
November 16, 2010 at 7:37 am
Named pipes is enabled, the Service account used by SQL Agent service has full rights on the database and it's default database is online.
I have seen a similar post to...
September 10, 2010 at 8:27 am
Try placing your values into a varchar variable and execute the sp by passing the variable
Example
DECLARE @strSQL varchar(100)
set @strSQL = '(''Shipped''' + ',' + '''Partially Shipped''' + ',' + '''Canceled'''...
September 10, 2010 at 7:40 am
Viewing 4 posts - 1 through 4 (of 4 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy