ChrisM@Work (11/2/2011)

---

Jeff Moden (11/2/2011)

---

I just got done with some testing of my theory that having temporal based and persisted calculated columns in the detail would help this problem. Sure,...

Jeff Moden (11/2/2011)

---

I just got done with some testing of my theory that having temporal based and persisted calculated columns in the detail would help this problem. Sure, I...

WayneS (11/1/2011)

---

Work just got us all online training from PluralSight (which I've never heard of before). In looking at the SQL Server items, there are some from an author of...

L' Eomot Inversé (10/31/2011)

---

SQLRNNR (10/31/2011)

---

GilaMonster (10/31/2011)

---

SQLRNNR (10/31/2011)

---

L' Eomot Inversé (10/31/2011)

---

Thomw (10/31/2011)

---

Thanks! I noticed that the thread has 'drifted' after my post and have edited to at least not...

Jeff Moden (11/1/2011)

---

Kiara (11/1/2011)

---

Oh, I'm game to experiment. I'm not afraid of my test environment in the slightest, and I won't move something into production unless I'm convinced it will...

Ninja's_RGR'us (10/31/2011)

---

WayneS (10/31/2011)

---

Ninja's_RGR'us (10/31/2011)

---

WayneS (10/31/2011)

---

Ninja's_RGR'us (10/31/2011)

---

WayneS (10/31/2011)

---

Just browse to the SSRS web page. You'll have to...

Evil Kraig F (11/1/2011)

---

Jeff Moden (10/31/2011)

---

I was simply going to add the date, EmpID, and 3 calculated columns to the detail table and hide them from the app using a...

Jeff Moden (10/31/2011)

---

Evil Kraig F (10/31/2011)

---

That's what I thought you meant at first, but I can't see how combining those into this will give performance gains when you still end...

Steve Jones - SSC Editor (10/30/2011)

---

Just a quick note. I have an iPad 1 and use a bedside charger station. It always says "not charging", but it charges, albeit slow....

ChrisM@home (10/30/2011)

---

Here's a few preliminary results from queries posted so far, and another which I'm guessing is Jeff's preaggregate. The preaggregate works fastest but not by a fat lot. I've...

Jeff Moden (10/30/2011)

---

ChrisM@home (10/30/2011)

---

Here's a few preliminary results from queries posted so far, and another which I'm guessing is Jeff's preaggregate. The preaggregate works fastest but not by a fat...

Jeff Moden (10/29/2011)

---

Kiara,

Any interest in a bit of table redesign that will greatly improve performance for this particular query? One that will give the reporting performance you seek without...

andersg98 (10/28/2011)

---

I would suggest that you do not run this kind of reporting against a busy OLTP database. Use replication to copy the relevant tables to a reporting database...

Jeff Moden (10/28/2011)

---

Gah... Now that I've had time to look at it, I see that my problem with generating the test data was that not all usages of the Tally...

J Livingston SQL (10/28/2011)

---

but my real question is that you say you need this in "real time"....but with 170k reults what is anyone going to do in real time that...