Thank you!

Sure that is easy. You would use the pivot relational operators.

Sean Lange (7/9/2013)

---

Vertigo44 (7/9/2013)

---

Ok I have finally had time to circle back around to this query. In my attempts to follow the Forum Etiquette thread I ran into a slight...

Ok I have finally had time to circle back around to this query. In my attempts to follow the Forum Etiquette thread I ran into a slight problem in that...

The tables are views and scripting out the create to would not work here... Should I create a custom one for this purpose?

I have added more details that I hope will clearly explain what it is I am looking to gather... Thank you!

I think I got it using a full outer join.

Lynn,

Wouldn't that give me Visits with or that have doc name B? I'm looking for the ones that do not have a specific document...that are missing a document. You could...

Tony++ (3/27/2013)

---

As noted previously, SQL itself doesn't care.

What does sometimes care is antivirus (not to start a thread on good idea or not, just that some shops do run AV...

Interesting. I did not realize that. I am still going to relocate if off the data drive tonight and move it over to a dedicated log drive.

Thanks again Gail!

Thank you! I was able to Reindex all the user tables that were above 30% fragmentation successfully within the maintenance window. This server is in high demand since it runs...

Quick update: I ended up getting a disk presented to the server for DTC. I then added the disk though Cluster Failover Manager and added dependencys. I then failed it...

Perry Whittle (6/27/2012)

---

If you do this you'll need to put the DTC resources in the same cluster group...

Well we have a backup from Saturday. I don't know if that is a good...

Yes but mine did not say 0% remaining. Mine said 0% COMPLETE after sitting for about 45 minutes. I've got MS on the line and I think we might try...