JohnSQLServerCentral (5/9/2011)

---

Partially answering my own question, for the benefit of the next person. Edit the query, change at least the following two lines from a 0 to a 1:...

No, I was just joking...

Interesting read.

I do have to question the idea that the 3-6 month BI project is a junior role and a good way for someone to "get their feet wet."...

bradmcgehee@hotmail.com (2/14/2011)

---

The SSC cluster is an active/active cluster, and SQL Monitor is monitoring both of them with ease. Node 1 runs the SSC databases, and node 2 runs the Simple-Talk...

No. It's more of a server-wide picture, with occasional...

Having actually had two managers (and then, later, three) at one point in my...

The newest versions of AD use SQL Server (or at...

CELKO (1/31/2011)

---

Nice piece! Now let's go one step further. How do you write constraints to prevent cycles (and orphans) in an adjacency list model?

The best I have...

Garbage in,...

Glad to hear that it worked!

Why did it cause a problem? Well, the fact is that XML indexes in SQL Server are really not well integrated with the query optimizer....

I'm getting a very different plan than you are -- and a much more efficient one at that. The biggest difference? My plan uses only the primary XML index, and...

Just to be clear, you run one file at a time, and it takes 8 minutes?

Can you post the schema of the actual table, a few rows of sample data, number of actual rows, and the query plans for both? I'm sure if the CROSS...

Perhaps this will help you?

http://sqlblog.com/blogs/adam_machanic/archive/2009/08/03/uniquely-identifying-xml-nodes-with-dense-rank.aspx

Solomon Rutzky (12/29/2010)And that article was done before SQL Server 2008 added the ability to go beyond the 8k memory limit (with a MaxSize set to -1) so adding that...