Service Industry, not Mfg.

So the back and forth is bi-directional bandwidth!

Makes a lot more sense now, thank you for taking the time.

I hope for the most part, you have a...

Koen Verbeeck (12/10/2013)

---

Billing...

If a customer can change back and forth several times during the month, I'm missing some concept.

Why would this freeze at the end of the month?

It almost sounds like for...

Koen Verbeeck (12/10/2013)

---

L' Eomot Inversé (12/10/2013)

---

I suspect that "ColX IS NULL" is a faster text than "ColX = 'Billable'" but that's not the point, if you do this with a...

Always current month?

Or rolling into a historical table?

Dimension implies SSAS, which also can be an influence.

I would tend to think in terms of NOT EXISTS and check performance.

I'm sure you...

SQL Server runs MSSQL Service, and needs to be registered to the machine and service.

Reporting Services runs HTTP service on a machine.

Unsure from your description if these are running on...

Tasty? Or just plain well deserved?

The count only tells part of your contribution.

Also be aware that should an owner be deleted in AD, it can cause issues with subscriptions.

So this may be more helpful in the long run than anticipated.

I agree more table definition would be helpful.

And the counts in the tables would also be nice to know.

It appears you are looking for adjustment records that have no adjustment...

Reporting Services is HTTP for a service, not SQL.

Make sure the SSRS service account is trusted for delegation, as well as the machine it is running on.

If possible, you may...

Here is your error that needs to be fixed.

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'incide_pk'....

ChrisM@Work (12/3/2013)

---

Steve Jones - SSC Editor (12/2/2013)

---

L' Eomot Inversé (11/24/2013)

---

I think the idea of "Core TSQL" isn't unreasonable, but no set of knowlege which is just about T-SQL and not...

Gary Varga (11/29/2013)

---

Jeff Moden (11/29/2013)

---

The exception to that rule is that spelling errors are simply not forgivable and incorrect substitution of correctly spelled words (for example, you meant to use...

Turkey and Nap go together very well.

Sad that some stores are starting Black Friday early.

Hope everyone had a great day, both here and abroad.

jasona.work (11/27/2013)

---

Greg, thanks for the suggestion, thankfully the method of "upgrading" here is to deploy a new server, clean-loaded with the new OS. I think what's potentially going on...