I don't see why not - tricky without full details - but it's an approach I've used many times when working with large sets of data. You need a parameterised...

personally I don't think this is the place to post this - you're really asking for a freebie from an experienced developer/dba.

I will go out of my way to help...

index rebuilds will always cause t log growth and I'll generally leave the t log at the size it needs to accomodate this growth - however there are some things...

I use the DTA for individual queries, for a complex query it's usually quicker at working out the answer than I am ! I figure it and I generally get...

oh by the way I disagree about sql 6.x being harder to manage/configure - it was an absolute breeze compared to building and managing a 64 bit cluster for sql...

I guess you're probably posting from the US, and this may be different from the UK. Most roles in the UK are handled by agencies and they will filter candidates,...

i'd agree that you might want to reduce allocated memory. I've only used 64 enterprise so have no idea about memory settings for std. is the awe box available in...

the primciple of tuning is to identify the bottleneck/problem then apply. If you don't have a performance problem then tuning is not required, on the basis of "if it...

hmm I'm not convinced you can "upgrade" std to dev as it's a downgrade which I wasn't sure was supported. I could be wrong however, not a thing I do...

I'd suggest you don't enable autoshrink, it'll promote ntfs fragmentation. I usually try to find the size for the transaction log so it doesn't grow - the fact that the...

I didn't know you could actually do this, perhaps you can't! I'm sure a former colleague tried this and decided you couldn't - I'd be interested to know the...

you're all missing the point about an upgrade here. Enterprise supports a large number of "parallel" type processes which are not supported in std edition. If your server is web...

well that's interesting to revisit an article which should have provoked more interest I would have thought. I'm still involved with hiring DBA's and I have to say there's ...

I'm sure I've already seen this post elsewhere on the site. Why on earth would you want to do this anyway - it's also a sql2000 table not a sql2005...

http://msdn2.microsoft.com/en-us/library/ms190283.aspx

did you not think to check BOL before posting such a question - or even using a search engine ( as I did ) to get this link address ?