It also depends on your OS. Some can detect cores, some detect the threading (so hyperthreading on appears as 2).

Windows XP can detect multiple logical processors, but not physical ones....

How much data are we talking about? I'd be surprised if you get much optimization this way.

There isn't a way inside SQL Server to do this easily. Any...

Is Autoclose turned on?

There's no good way to determine when stored procedures have been used. Profiler works or if you can "touch" the stored procedures, you can add a line of code to...

Call PSS. Consistency errors are not worth screwing with.

I think you'll have to just make guesses based on sizes and then queries / sec for them. The best thing you can do, however, is setup internal DNS entries...

No interest on loans is paid. The charity is in letting them use your money for a period of time.

I think something like this would make sense in the US...

The user your application uses may not have rights to the new schema. Might check the security. Trace some executions and see if it's the problem.

Anything in the security or system logs? Service startups usually appear in the system log. The Agent start should also be logged in the SQL errorlog.

If you constantly run the optimizations and it grows the log to 13GB, why bother shrinking? It's just going to grow again. Leave it at 13GB. If you truncate it...

Have a series on how I used to do it.

http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp

Are these related to SQL Server or just other services?

I don't think you want to put anything else on a SQL box if you can avoid it. Have competition for...

The inserts sound strange. Does the query plan give you an idea on where the reads are occurring? Are there perhaps triggers or extra keys on the slow system?

Backups are a problem. I remember in 94 we had an imaging system and we got to the end of our disks. They were large at the time and external...

My way of filling a Question Gets hard to think of new ones over and over. We're at about 1040 now.