How are you replicating the changes from one...

I have.

Not anymore.

http://blogs.msdn.com/psssql/archive/2008/12/16/how-it-works-sql-server-no-longer-uses-rdtsc-for-timings-in-sql-2008-and-sql-2005-service-pack-3-sp3.aspx

Also, from that KB that you posted

Note In SQL Server 2005 Service Pack 3...

clementhuge (12/18/2008)

---

Hello,

I would like to develop a high availability strategy for a company (both automatic failover and load balancing)

If I well understood clustering, it allows you to have n nodes...

I thought it was 42.

Tramp, can you state your question a little more clearly please? The question title gets cut off.

I think this is one of the areas of the internals where the more info you...

I haven't worked in Access for so long I can't remember anything about...

I hope you're going to make that password a little more complex in production.

Your syntax is completely incorrect.

Update TargetTable

SET TargetColumn = SourceColumn

FROM TargetTable INNER JOIN ....

What do you mean by "performance is slow"

Is this normal, or is the server unusually slow?

Have you made any changes recently?

Are there more users than normal?

Is there excessive blocking?

Are you...

If you are using SQL 2005, rather use the sys.dm_exec_sql_text than inputbuffer.

Look up the EncryptByKey and DecryptByKey functions in Books Online.

Username is typically a very bad choice for a clustered index. It's wide, it's nowhere near unique and it's not ever increasing. LOG_DATE_TIME may be a good candidate. Still need...

Did you read the links that Pradeep provided?

DBCC TRACEON (1222,-1)

The -1 turns it on globally. Without that the traceflag is only enabled for a single session, the one that turned it on. Since deadlocks are detected by...

Never. The log is truncated on a checkpoint, meaning the inactive log records are discarded and the space made...