You're welcome 🙂

Hello,

Did You make any test which would measure the whole operation performance (CPU and memopry usage, IO reads and execution time):

I. preparing XML in an external application

II. executing a procedure...

I am surprised that anyone is still reading it since it was published in february 2008 🙂

And about the Itzik Ben-Gan article (http://www.sqlmag.com/article/sql-server/virtual-auxiliary-table-of-numbers)

I also published script which uses similar...

You're right - this procedure would be much more simple if I used cursors as You did.

I am afraid that there may be a lot of bugs in the procedure to fix up due to the script complication and I was already told that the way...

IMHO not.

Your way seems to me to be more "clean" and I think that it is better than mine (which is perhaps unnecessarily to sofisticated than it should).

It is just...

There has been added a version of this procedure for SQL Server 2000.

It is waiting for approval now.

I have just submitted a new version of the procedure:

- without cursors

- with reseeding identities

- with changing (and restoring) recovery mode

Now it is waiting for approval.

And good point about transaction logs. Mayby the script should check the recovery mode and set it to simple before cleaning the db and restore settings after the work is...

I have already tried to use 'truncate table' but it raises an error if there are any foreign key constraints. I would have to drop them before truncating table unless...

By the way, all bit fields are kept in one byte.

BOL:

"Microsoft® SQL Server™ optimizes the storage used for bit columns. If there are 8 or fewer bit columns in a...

Hmm ...

Right.

My oversight.

Sorry for that.

3.

Moreover, if You had an application using such feature which was changed and You have an option to change a code of it and than prepare an update of binary...

1.

There are a lot of artricles on the SQL Server Central website about undocumented features of the SQL Server and which were found by readers quite useful.

If there is...

The problem is not with the number of rows, but with the sort order. If You try to submit a query select top 100 percent .... from ... order by...