Thank you for all the feedback.

Jim, it seems that the system on average is 60% writes and 40% reads.

Perry, the tempdb will be located on E as per the original...

Hi peeps,

Did anyone ever do a comparative test on the recommended solutions? We are faced with exactly the same situation at the moment. We have 8x300GB drives and require a...

Hi Sk,

Thanks for the feedback. I thoguh of this but unfortunatly some of the server will be express addition which can only be a subscriber. I did however get this...

Hi Fred,

As previously mentioned, it could work. But... it will become a nightmare to maintain and manage, especially if your working in a team environment. It's recommended you use a...

Here is how I got it to work in the end:

SELECT

[SubscriptionName] =s.Name

,[DeliveryMethod] =s.DeliveryMethod

-- extensions

,(SELECT[Name] =eupvt.Name

,[Value] =eupvt.Value

FROM(SELECT ie.[To], ie.Priority, ie.[Subject], ie.Body FROM @Extension ie WHERE ie.ID = e.ID) a

UNPIVOT (Value FOR...

Any one have any suggestions???

Hi Chris,

My *recommendation* wasn't a comparison between my code vs. Jack's code. It was a recommendation on my own code.

The reason I added this is that Jack's method does...

I've just added this for reference purposes.

-- declare temprary table to store dates

DECLARE @tblDateTime TABLE ([DateTime] DATETIME);

-- populate temporary dates to be used for reference purposes

INSERT INTO @tblDateTime ([DateTime]) VALUES...

Thanks for all your responces.

I agree with not using periods, spaces or any special character for object names. But as you might have noticed none of these (except for index...

Or if you know of a link with some examples please post them here too 😀

*bump*