Thanks for the responses. I've been looking at this for a few days on and off. Today I've been sitting here watching the counters because I am seeing such weird,...

Yeh, right now I'm running a server side trace and a few more measures to see if I can match up activity to counters. As I said, though, there's no...

This solution apparently does not quite work.

When sum against the fact_product purchase cost is executed, it is executed against the entire product cost table. In other words, the result...

Cheers, I will try the second option and see if it does what I expect. I am suspicous... that seems like too simple a solution lol.

Charles Hearn (8/29/2012)

---

allmhuran (8/29/2012)

---

I think you need to have your granularity at a lower level, such as rental transaction and add a proper date dimension. Once you have your...

Using this solution:

The status of a region is held in the relationship table.

A region with no offices assigned to it will have no rows in the...

Cheers, the separation of SQL and windows cluster responsibilities with respect to this new tech wasn't quite clear to me. Makes sense now.

I just saw this, which describes the desired scenario and states that it would result in a senario in voliation of the AG constraint:

The following example scenario illustrates how this...

Certainly looking forward to that article.

I haven't explained the situation clearly enough. Imagine the following:

Cluster = C1

Servers = S1, S2.

SQL Server instances = SQL1 (clustered), SQL2 (not clustered).

Database = DB1.

Configuration:

Instance...

sp_helptext is a built in procedure which will do just that: given an object name (3 part name allowed) it spits out the definition.

Alternatlively, Redgate SQLPrompt is nice for a...

Jeff Moden (5/23/2012)

---

No... we're not off topic. You asked for my opinion and I gave it. Then you argued with it and I tried to give you some...

Yes indeedy, your rundown mimics very closely the various options currently used where I work, and indeed at pretty much everywhere I've ever...

Jeff, In a perfect world where I wasn't already working lots of overtime and surviving almost entirely on a neurochemical dependency on stress, spending the time to put together some...

Jeff Moden (5/11/2012)

---

True ernough but if it were only 4 or 5 people who wanted a single spreadsheet, it wouldn't really be a problem, would it? The real problem...

I definitely agree, but of course the usual problem is resourcing. The business may want 100 extracts...