Size is relative. My temdb's vary from 1 Gb to 10 Gb. It's just what is 'normal' for that server. Oh, I definitely agree with Jeff ...

A rather dicy thread here ...

Before SQL 2005 the same issues existed more or less. It'sjust that SQL 2005 added CLR integration (check out other threads on this site for...

Just a note on passwords, in particular 'strong' passwords. You need not got to the lengths of 'pass phrases', multiple words with spaces, if you use a 16 character password...

By default, the SQL Agent service is not even configured to autostart, let alone have existing JOBs. IFirst I'd check the execution history then I'd script them out and take...

Yelena,

sp_recompile is not a replacement, it and sp_refreshview simply marks the object and any SP that references that object will have it's plan recreated on the next execution in essence...

Query Analyzer

Enterprise Manager

SQL Server MSX Server

Custom scripts

MOM  - Microsoft Operation Manager

Windows perfmon

SQL Profiler

and ...

Google

SQL Server Central dot com

SQL Performance dot com

I've had to do the same thing in the past. However the best place to start for this information is generally the source. Who does the hiring/firing ? This is...

Here's my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE STATISTICS (with FULL scan) for all tables

    exec sp_recompile for all tables

    exec sp_refreshview for all views

Round II

    DBCC DBREINDEX

   ...

If you can you write a transact SQL query for SQL Server or a SQLPlus query for Oracle then using Queryman or Toad is no different. However if you cannot write...

Are all of your databases SQL Server ?

To get at he things I mentioned:

Start-Programs-Microsoft SQL Server-Query Analyzer

What exactly are you try to do ? Learn SQL ?

Why do you need to use those tools ? SQL Server has QA - Query Analyzer. As for the assistance woth QA, well there is BOL - Books Online.

You quest may be further complicated by applications as well. Some applications use multiple connections, some applications use generic IDs with application security ID's not visible to sysprocesses or to...

Your Domain Admins can give you the exact information that you want, login name. Tey just have to use a couple of extra check boxes and ad a few more...

I do not have a solution but a question. Why are you using a local 'hosts' file instead of DNS ?