Great stuff.

Wondering if there is a way to extend this to include application information, like the application username and ip address that triggered the CRUD operation. We are using NHibernate...

Correct me if I am wrong, but I see a combination of Enterprise Edition and Developer Edition binaries in Node 4. It seems that they can coexist with no problems....

As I specified before, MAXERRORS does not do the trick.

I already checked BOL; seems that there is no other option available.

yes, I have used BCP and I do use it every day.

The problem is that we have production procedures running under VBscript, which runs sql (opening a connection to the...

^^ bump

no one?

Create a temp table with the year, month and Physical Values and make an OUTER JOIN right after the group by.

Unluckily there is no ROWNUM in sql server which can...

1) You might want to shrink the log right after the full backup (or LOG backup). Refer to DBCC SHRINKFILE.

2) You might want to change the recovery model to...

Use ISDATE function in order to see if the format is correct,k and then use CONVERT

I figured out that everytime there is a BEGIN TRANSACTION opening for a DML, and that statement fails, there is no Implicit Rollback.

I had like 30 DMLs going on...

And why does it take so long? Dual Xeon 2.8 Ghz HT, 10k RPM SCSI disks. There should be another way around.

Transaction logs are written sequentially. There is no added benefit to put them in a 0+1 container. I do use RAID 1 for them. 0+1 is the best solutionf for...

That will be awesome. So I can implement Oracle Solutions into Sql Server

Yes ThomasH. I checked the execution plan and the optimizer effectively drops the tables that are not needed and then uses the indexes required just in the table needed. Thanks...

Yes I did veritcally partitioned the table, and the view only has information of the last 14 days. Each day worth of data is stored in a just one table....

A table refers to a client and contains customer information. This customer performs "actions" and they are stored in a huge partitioned view. The partitioned View contains the UID of...