Hey guys.
We have this disk servicing only one database (logs and data). And it's this disk that goes out of scale randomly (not very often)
We have a few...

Thanks a lot for your reply 🙂
I've been testing it, and it's working as expected 🙂 When there is pending IO, this query will get you information about it.

So I guess all the following errors are related:

This failure occured while attempting to connect to the Failover server

This failure occured while attempting to connect to the Principle server

And a...

mtillman-921105 (3/7/2012)

---

agustingarzon (3/6/2012)

---

mtillman-921105 (3/6/2012)

---

i wouldn't want to tackle this myself.

But, as sort of a hybrid approach, if you could at least provide a skeleton of the tables and...

mtillman-921105 (3/6/2012)

---

i wouldn't want to tackle this myself.

But, as sort of a hybrid approach, if you could at least provide a skeleton of the tables and add customizable...

Honored with your suggestion, Jeff 😉

Thanks guys, I thought there would some difficulties crossing the database boundaries but with your suggestions it seems that this could work seamlessly.

Best regards,...

Chrissy321, I'm reviewing your suggestion now.

LutzM: I meant what would be your suggestion SQL wise, e.g. using the same database, using a schema, a second database, or a third approach....

Both databases would be on the same SQL Server instance, in case I forgot to mention :unsure:

guerillaunit: Will investigate the linked server suggestion. Option 3 would be the best if we were able to join to the primary database.

LutzM: What we would be offering would be...

bleh...

it seems all the cool features require the Enterprise Edition of Sql Server :^s

Guys I really appreciate your suggestions and comments. You get me going in the right directions really quick.

I'll try Craig's suggestion first, to see if I can gain some milliseconds...

It's just a naming convention, there are tables named like

WILC.Property.LAND

and tables named like

Property.LAND

I'm attaching the actual exec plan and the view def, hehehe go nuts !

What do you mean with un-3part named tables ? All the tables are in the same database.

So...

Each of the tables have more or less columns, with different names.

The UNION ALL puts them all together in one place, the data types and the meaning is the same.

I...

Barry, Paul, Jeff, Will, thanks a lot for your participation. I hope to get you that involved in future threads, hopefuly not that often 🙂

Kind regards, Agustin