We had something similar, but it was a network issue. If I remember correctly, it was dueling domain controllers(?) generating different information. It was also only happening every 4 hours,...

Congratulation Gus!

Jeff Moden (12/30/2010)

---

Roy Ernest (12/29/2010)

---

On another note, I have been noticing for quite some time that the patience level of the forum regulars has gone down couple of notches. There...

This post (in the discussion of the article) references both the safety check and the modification to it, and includes the resultant code sample with both applied.

dbursey (12/29/2010)

---

This is not a question asking "how to" do either one of these things - I know how to do them. I'm just curious with regard to preference/performance...

You'll have to use dynamic sql to run it that way.

Matthew,

Thanks for following up with the code that shows it working - it will help out others in the future when they have a similar issue.

How does this run performance-wise...

This sounds like a job for the row_number() function with the optional partition by clause. This article[/url] might help you out with understanding it.

First, let's put the data into a table so that it can actually be worked with:

And here are 3 different methods to extract the ISBN and Group for just the...

If you definition of unused is that it has zero records, you can run a query to determine this.

Otherwise, you'll probably have to run a server-side trace to track what...

Sounds like a partitioned view here will handle things - see this link for how to handle this. The trigger will insert into the view, which will properly put the...

jbon007 (12/29/2010)

---

sorry i wasn't clear enough.

from the two views i want the two results to be combined into one view.

i.e

NoDaycase noElective Dis_Spec...

Matthew Darwin (12/29/2010)

---

I was wondering if it's possible to generate some sort of unique row id that will always be consistent from the xml document that I can pass into...

This will generate the ALTER TABLE statements for you.

SELECT 'ALTER TABLE ' + QUOTENAME(ss.name) + '.' + QUOTENAME(st.name) +

' DROP CONSTRAINT '...

Nic,

Very interesting. Thanks for posting your solution - I've learned something out of this!