The changes are written to the log, so they're on disk, just not in the data file.

If you request a page that's been changed in memory, but not on disk,...

Call PSS. You may have hardware issues, but you don't want to lose data. I'd suspend database activity and call PSS for now to diagnose the issues.

And how we counted votes :w00t:

Sorry was responding to mailsar, who mentioned deleting data and joining back to tables.

I think you can trap the DDL for truncate, but not sure about the data. Perhaps a...

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...