You can create global temp tables (##name) as well, but be careful as these are visible to all connections and you could end up with naming conflicts.

Perhaps you could explain...

If it's not installed, remove the folders in the file system and the registry key under HKLM/Software/Microsoft

You are asking a very general question. How does it help? It reduces round trips, but that may or may not be what makes the most sense.

You can learn a...

If you need to do something like migrate, hire a consultant. You're asking for trouble on your own.

If you want to know how it's configured, that's not an easy thing...

I assume you have other columns, correct?

You can do

create table mytable

( myid int default 0

, mychar varchar(20)

)

go

insert mytable select 1, 'A'

go

select * from mytable

go

insert mytable (mychar) values (...

I'm not sure you can control which objects go where in tempdb. I've not heard that splitting it helps. If you can get multiple drives under it, you can improve...

I thought this wasn't supported, or at least not installing SS2K later. Did you install both as SS2K and then upgrade?

Perhaps the SQL Browser is broken because its' 2000 and...

I've used Profiler. You could even capture separate traces for different users and then replay them from different PCs to simulate loads from different sources.

If you have serious auditing requirements, deleted records aren't allowed. You "mark" them as logically deleted (some flag), but you keep them around.

Worse case, you set up a table to...

The licensing, from what I've understood in the past, is that you license all CPU sockets that are occupied on your system, regardless of affinity. I tried to license a...

My experience with replication and DTS (not so much SSIS) is that they work great until they don't. Then it's a pain.

If you are worried about support calls, I'd think...

I've told someone in every interview in the last 9 or so years that I won't be micro-managed and I don't track time. If you need that, hire someone else.

If...

Very good comments and a few smiles appearing over here from the jokes.

Not that I think all british humor is bad, but I don't like the UK version of the...

I might also run a trace for that user and see if anything is happening.

Can you stop the job?

Strange.

If you need to save databases, I'd copy those, then delete the mssql folder structure off the disk. Also in HKLM/Software, delete the Microsoft SQL Server keys. That should let...