Please let us know where the recorded versions will be available - Just returned off from vacation and saw I missed these classes 🙁 -

Thanks for offering them ,...

sp_refreshview - Thanks for that noeld, - I forgot about it - I know it would have come back to get me later on

I thought the check constraint was to ensure data integrity by ensuring modifications made through an updateable view would satisfy all conditions of the view definition. I need to get...

Just remember if you add more than 4 GB memory you need to get the patch as there is a bug in the SP4 which halves the available memory. -...

Thanks for that reply, I feel happier I am persuing the correct direction to attaining my goals with this project. I totally forgot about creating a view that can span...

Originally born in Zimbabwe - nearest city that I can find reference for distance was Harare - now work between North Carolina, California and New York - so the greatest...

Ginger nuts (cookies/ biscuites) dunked in a hot cup of tea - problem is that they never end at the same time.

An old favorite - Toast and marmalade with bacon...

Absolutely any information of links that may help me determine a good configuration will be of help - I just dont want to go down the path and then find...

Thanks for all the positive feedback and reference links - They are all helping. From many of the comments above it looks like adding hardware is going to get the...

AH!!!!! that was a killer - just typed a large response and hit the reply button - It all disappeared and now I must do again

Thanks for the /3gb heads up - I was unaware of that.

I am assuming to just perform the select statement to the temp table to pull all the necessary rows...

I have to ask - what size are the uncompressed forms of the files you are planning on storing within the database - and what size are you expecting them...

if you are using SP4 then there is a bug and you need to apply a patch - " If Address Windowing Extentions (AWE) support is enabled, a single instance...

Initial thoughts are that the first call you are making it is pumping all the data into the cache - once cached subsequent reads are fast. after your 30 minute...

works for me - just dont put in the ' ' when capturing the variables in your string list - just tested it and it went through like a...