just query sys.columns - I'm sure that somewhere on the ms site there is a pdf of the system tables and views - you can work out how to do...

I agree, usually the optimiser is clever enough to know what to do - however experience tells me this is not always the case so you should just check the...

far as I can remember it creates a "workfile" on the drives which you specify a size for somewhere in the run setup - it then uses this file to...

well maybe 10 secs is good for this. clustered sql server has no bearing upon performance btw.

you need to eliminate the scans and get some seeks - you might want...

I'd say that your approach was probably not the most efficient way to do things - your second call executes 1.7 million page io - I wouldn't want calls like...

it is critical on x64 platform to set the maximum sql server memory. If you don't you will get problems.

BOL explains how sql server uses memory and it's been this...

you can use a t sql function to generate a value for a calulated column in a table. I've used the technique since sql 2000.

For those readers who don't know...

having 4 seperate selects, any one of which may run based upon parameters passed will almost always give you problems unless the query plan for each query is identical -...

if you query sys.dm_os_performance_counters you'll get a true figur eon memory usage in a much more easy to read format.

it depends where and how you're executing the stored proc. If it's through an app then the timeout maybe there as usually timeouts are a client not a server setting....

it's generally a bad idea to leave the database in backward compat and I'd ask for the actual reasons. You won't be able to use the performance dashboard for instance...

I've seen this happening on sql 2000 boxes, even to the extent of an hourly job set to run from 08:00 to 18:00 continuing 24 x 7. I think...

create a group in exchange - add the group as the recipient

you may find sp_autostats tablename is quickest if you just want basic information

this query is more complex - run in the database you're interested in

( this is part of...

you must set the maximum memory on your install otherwise you may have problems.