Looks good. I was hoping to see it on the Spatial results tab. 😉

Another quick note - the dmv will only show an index if it has been used (read from or written to).

So you may have an index that is truly not...

vanslly (6/21/2011)

---

There is an alternative. Read: http://www.sommarskog.se/arrays-in-sql-2008.html#TVP_in_TSQL%5B/quote%5D

When I originally read this article (on SQLServerCentral) I thought it may discuss the topic of the article you have linked to...

Thanks Todd - great article. My company uses a similar function for splitting, but I simply have not had the need/opportunity to use it.

I have an upcoming task in...

I believe it is done for performance reasons. Deleting data can occur faster and rollbacks would be faster. Then a process can later update clear up the ghost...

Interesting concept - thanks. I liked the MindSweeper game that was posted also.

I'll have to review the logic of how the usp selects its position. I played four...

Dennis Wagner-347763 (2/17/2011)

---

It would also be very interesting to see how many do this for commercial systems where the client requests a data dictionary vs. internal systems that are only...

Thanks for the excellent info!

I tackled this issue myself previously, but my solution is not quite as "simple" 😉

I'll have to test this and see if I can replace...