Try these links, you should find all you need to know

http://www.sql-server-performance.com/sg_sql_server_performance_article.asp

http://www.extremeexperts.com/sql/articles/SQLCounters.aspx

They may talk about SQL 7 in some places but the info is still valid for 2000.

You forgot to say what OS you were using, that might have an impact on the advice we can give you  

There are a couple of different ways to look at this,

• how many rows are in the table?
• How busy is your server?
• How often is your table referenced?

If there's over 10K...

So if I understand you correctly you want

select getdate() as today

select dateadd(d, 20, getdate()) as [20daystime]

although if you want it to be 20 working days I'll leave the logic up...

beets me, I tried the following in the master database and it works perfectly, the only thing I can see from your post is that you didn't declare the variable...

You could use a trigger for update and store the info in an audit table but it's pretty near impossible to track who has viewed a table (unless you only...

we did some testing with SQLSTRESS when we were benchmarking our new cluster and SAN, or you can always download one of the ones from the MS website.

We manually update the stats each evening too, letting sql decide when to do it tended to cause a few too many issues (it always kicked off at the busiest...

If you have the objects created in your model database every new database you create will also have them .

I'd have a look, clean...

It never used to be a problem with SQL 6.5 (god I'm getting old), that used to let you restore just a table.

They changed the way it worked in SQL...

Thanks for putting it so well

Baseball, isn't that just a group of men who like hitting their balls with a stick?

You'd only be able to do this if the table you wanted had been put in it's own particular filegroup which had been backed up seperately.

Unfortunately you're stuck with restoring...

All of the databases I look after have alerts configured to inform me when they reach 75% log utilisation, and do an automatic backup/checkpoint (depending on their mode) when it...

Not a very pretty way but you could always capture normal usage in profiler for say 30 mins and then replay it once you'd re-attached.

You'd have to be careful that...