This has been one of the more frustrating issues I've tried to resolve and I've basically gotten nowhere. If someone has it solved, I'd love for them to do...

In my environ, dbcc table check occurs, I believe due to backup option "checksum" which causes a page checksum calculation on every table's data prior to backup.

Update for Windows 7 x64 OS:

Use HKEY_USER instead of HKEY_CURRENT_USER. You'll need to know your current SID (Security ID). This you'll find by looking at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList. ...

Thanks DJ. Can you maybe explain the purpose of the Set-ExecutionPolicy command? Also, when I tried the sample code, I got an error when trying to restart a...

If you plan to be able to "recreate" a result set using audit tables and the underlying query, keep in mind that a join to a non-audited table could make...

I was going to reply and correct that statement, but you beat me to it. No, the trace does NOT need to be stopped to examine the active trace...

SQL tracing in general, and server-side tracing in particular (simply because of its much lower overhead) is one of my favorite tools for a wide variety of tasks ranging from...

Well, yes and no. I've had to deal with a variety of performance issues, but I haven't specifically faced this issue. I've more commonly faced i/o problems than...

I've used "multi-server" queries and transactions pretty extensively in SQL 2000, and although 2005 has added features that would probably make some of the things that I've done a little...

What if the reporting server were being used by someone who is running a Win32 client application, for example, that is keeping a live connection to the database. When...

Can you [tymberwyld] provide more details on DevExpress. Is this from devexpress.com? Which product?

I had started to write a somewhat similar article just last week. Although my concerns and constraints are somewhat different, and final solution completely different, I enjoyed your article....

Since none of the previous posters mentioned this, let me add a couple of points. If you use the following data set:

create table test (test int)

insert test select null

insert...

I guess there's a lot of things it could be, from the number of columns returned by spEmpErrors to the datatypes, to an error in the procedure itself. However,...

From the standpoint of the SQL engine, distinct is equivalent to a group by that contains all of the columns in the select list. So if you understand the...