Internal to SQL Server, they peform almost identically. The main difference is that OPENXML has to instantiate an XML parser that chews up a ton of memory outside of SQL...

In my opinion, this would not be a primary counter for checking performance. I'd use it once I've already identified range scans as an issue because of excessive waits or...

Are you looking for an Islands and Gaps solution?

This is from Itzik Ben-Gan's Inside TSQL Querying and identifies missing values

SELECT cur+1 AS start_range, nxt-1 AS end_range

FROM (SELECT col1 AS cur,

...

My XQuery knowledge is unfortunately new and grossly incomplete, but from what I do know, I don't think it's possible. XPath queries are a way of navigating the XML to...

1. Logical reads are all reads, physical from the disc as well as from memory. To determine physical reads as seperate from cache reads, you need to get performance monitor...

And, check your connection settings. See if the TSQL connection & the ADO connection are the same.

Does your table variable have a primary key and is that used to join to the other tables? If not, that's going to be a performance problem right there since...

I just remembered. There's this great book by Craig Mullins called Database Administration. It doesn't dwell on technology, but goes over general concepts quite well. I'd recommend that one too.

True, but have you seen the Suite license cost per seat? We'll be adding procedures for the developers for some time to come.

Oh yeah, you can have the project deploy or drop objects, yes. It's getting objects into the project (or out) that is the problem. My developers all have the Developers...

Database design and indexing design is a tough topic and it takes time to get it right. Two books that you might want to add to your library are Inside...

Nope. The one issue that we've had, and believe me the developers have howled, is that they can not simply add procedures (or drop them either). They have to let...

To capture the rows moved have a look at the OUTPUT clause.

It's simply scanning an index along the logical chain of the index instead of along the storage chain, an allocation scan. This is usually from an ORDER BY, but can...

I'm pretty sure I'm old fashioned, but I still use OUTPUT parameters in some situations. Let's say you have a situation where the application normally creates a row in a...