Not a bad article for what it covers, however, I've had experience with this sort of thing in the past and whilst I agree it's fine for small databases it...

Hi Raj,

Can you say what method you used to do the transfer please, if it's DTS then is should have been ok, if it's restoring from a backup then that's...

I agree 100%, that's why I said only to do it if you were being pedantic

LOL

Whenever you run a query that selects/inserts/deletes or updates any information you get a message along the lines of x rows affected

Setting the NOCOUNT option ON removes this message and...

Obviously you're using the SET NOCOUNT ON option inside your SP (arent you ), the good news is that this doesn't stop the...

Hi Alex,

Whilst I dont know if it's logged anywhere I would like to say that shrinking databases for the sake of it is false economy, when you rebuild an index...

We migrated to a clustered Itanium 2 configuration last year and whilst we did see some improvement in performance across the board the main reason for doing it was the...

Wow, a VIC-20 too (this really takes me back ), although I can't help feeling that this discussion has moved slightly away from what...

Oops, forgot to say that as I got sidetracked with the zx81

I agree, great interview and for those interested he's also got...

Wow, he started with a zx81 with 16K of memory, snap, but we couldn't afford the upgrade straight away so had to settle for the original 1K it shipped with...

I happen to know that there's going to be an article published here in a couple of days that details this sort of thing using performance monitor and an SMTP...

I can't think of a way either, but it does give you a damn good reason not to allow users to create objects without a proper change control procedure.

To be honest this is not something that i've ever considered doing, although I do have to admit that I really dont like maintenance plans, even though I sometimes have...

I seem to remember problems with not being able to view DTS packages in SQL 7 if the service pack they were created on was higher than that on the...

which brings us back to partitioned tables again