http://download.microsoft.com/download/5/E/7/5E7B79D4-90B8-4A3D-B964-8A72F49A21A9/caleula.pdf

seems to indicate you can upgrade your cals but I don't know what version of 2005 you would buy.

the standard pager goes through an extended proc so I doubt you could do much - I don't know if you could create your own proc to handle the pager...

the create date of tempdb will tell from when your server has been running, subtract from today for runing time.

The solution is dictated by the amount of data you can lose .. what data exactly are you planning to store and how much can you lose?

There's little point covering...

Oh one other point, you can't run profiler for tuning against encrypted procs effectively or use showplan with QA effectively.

sorry I don't have an answer regarding oracle - an rpc call is where you return the result set as a procedure call - e.g.

insert into mytable

exec remoteserver remoteproc

now do...

so many questions - so many answers !!!

table variables are good for small data sets but rubbish for large data sets. If the populated set is of any size always...

well the usual list to start:-

Is the harware the same, are the indexes the same. Have you updated stats? Have you compared the query plans to spot the differences.

Is the...

Well written article and an interesting read, I still don't see what advantage I might gain from it however, and as far as users are concerned the last thing I'd...

Hmm I must have been lucky to never encounter this, mind 818 patch is very elderly now so I wouldn't be running a box without this.

btw.  I doubt we're helping...

No you have to turn on awe, check in BOL , and set the max and min memory required. This assumes you haven't removed the /PAE switch from w2003 and...

aarghhh ! Sorry Bill but very bad idea, a leading % will force a table scan for each sarg .. very expensive.

so i/o counts .. I figure about 1.5k for...

In some ways some of these forum posts would work better face to face !! still - I've tended to work where common groups of service accounts exist within a...

check the query plans for the proc and qa query to see if they are different.

I've encountered this type of problem and the solutions can be a bit strange!! so...

I'm slightly intrigued by your description as to the 2gb you see the service using. In normal operation sql server is limited to around 1.6Gb maybe just under 1.7Gb and...