Alan:

I think it is cool that you can do this using SQL.

There are so many better tools to use. Why would you use an engine tuned to manage set...

This is a really cool exercise. However, it should remain simply that.

SQL is not HTML

HTML is not SQL

I can't believe nobody else has raised a warning flag on this.

Just...

Sure...

The last version I tested for performance comparisons was SQL Server 2008 R2. So, realistically, my assertion may be incorrect with the latest version. I doubt it, but the assertion...

I have been demonstrating how to create high performance Pivot transformations of data using SQL or Linq. Those queries both use a Pivot Table to enhance the performance of the...

I stand corrected. Please accept my apologies for my phrasing which now appears to me as ungracious. I truly wish your company great success!

The point I really wish to make...

Ok, you already alluded to the fact that others would disagree with you.

I hope your company does not have too much success. If they do, it is possible your SQL...

My concern about the application of this technique is a reliance on the primary key being date specific.

In short, it selects the top N rows where the date < 6...

I find myself convoluted regarding this problem.

Encryption is better performed outside the database in the first place. If you have sensitive data (i.e. credit card information, etc.) that is best...

I was the senior DBA in a PCI certified business. I had zero access to all production systems, and was required to work through an operator for all Ad-hoc changes.

When...

A little history about why one would ever even want no transactions...

Back in the old days when you spent $6k for a server with 32Meg (Yes Meg) of ram so...

Wow! That really goes back. Yes, the first MS version of SQL Server was to take Sybase and port it to run on OS/2.

I am not sure, but as I...

Earlier version of SQL Server did support No Logging.

Bulk Copy was the reason. In those days BCP was non-transacted resulting in higher performance. In order for it to be non-transactional...

Gail,

Excellent point. I should have mentioned that a missing propert for the first column of a composite index results in an index scan. Glad you did.

The technique doesn't work as...

Well done.

One way to get SQL Server to consider an index it would otherwise exclude in preference to a table scan is to provide criteria for all columns of the...

Than you for responding to my question.

Respectfully I disagree with your correct solution.

Losing a constraint of not null simply to modify the column length quickly is not a valid...