Yes, tempdb is taking the templet from model database hence second option will also work nicely 🙂

I preferably go with "Auto update Statistics" feature of sql server.

You can check the data and time of updated statistics with the following command:

DBCC SHOW_STATISTICS

You can write script to grant permission to tempdb and set this script to run as startup script when sql server starts

Can you run the update statistics on SQL Server 2000 and execute the query again in sql 2000?

Yes, I do agree with Gila.

Always play safe when matter is for Production server.

Also keep the backup of all database including system database and keep it on other server...

You can also perform detach / attach for your user database.

But yes you need to transfer Jobs, users etc.

With help of perfmon you can check following memory related counters:

SQLServer:Memory Manager\Memory Grants Pending

SQLServer:Memory Manager\Total Server Memory (KB)

Memory\Pages/sec

Also you can add few more counters and check memory as well as...

Hello,

You will get many stuffs on net as well as Microsoft Online Help.

But to kick start refer the following link:

http://www.sqlservercentral.com/Forums/Topic165125-92-1.aspx#bm165309

HTH

Generally I prefer default settings Auto update stats and let SQL Server decide when to update stats.

There is no harm in doing it manually but it may lead to overhead...

I guess another CPU menas another computer 😉

run CMD command like "COPY <from location> <to location>"

HTH

It will depend on situation.

If you will be able to perform the tail log backup successfully than yes you will be able to recover data till 12:30 but keep...

You create a stored procedure for reindexing by defining the database_name variable/cursor. It will take the database name from sys.databases.

Create a job and use this sored procedure to schedule at...

There should not be any licencing issue. As far as you are installing it on the single PC 🙂

Because COST of the 32bit and 64bit is same.

The only reason...

sqlcool,

It is not possible.

The work around is restore the backup with different db name. Do BCP / DTS to recover data to original table.

HTH