Eirikur Eiriksson (10/4/2014)

---

Alan.B (10/2/2014)

---

I have a few dev boxes running 2014 and have have experienced some instances where 2014 is giving me a parallel query plan where on 2012 I...

Thanks for posting that ddl and other info. Sorry I did not reply sooner; if not...

edward_hall76 (10/3/2014)

---

I am working on an ssrs report and they want to be able to search by 3 parameters City, zip code and state and have it where you can...

Do you have any DDL/Sample data for the three tables in question?

Can you post the query plan for the ad-hoc SQL or Stored proc that drives this report?

I know this was originally published a while back but I just read through it; it solves a problem I have been struggling with.

Very well written. Clear and to...

I don't know; wish I could tell you. I'm replying to this post because no one else has.

Here's a great article by Itzek Ben Gan that will get you on...

I have a few dev boxes running 2014 and have have experienced some instances where 2014 is giving me a parallel query plan where on 2012 I get a serial...

Just to add to what everyone has said... any index that does not get used is one index too many. This is a huge topic but here's a few rules...

You can add a tooltip. I don't have access to ssrs 2005 at the moment but I'm pretty sure you can't add a tool tip directly to the plus sign....

pietlinden (10/1/2014)

---

Is there any alternative to building your own SSAS cubes to report against? I would have sworn that SSAS creates an object that can be reported on using...

pietlinden (10/1/2014)

---

Is there any alternative to building your own SSAS cubes to report against? I would have sworn that SSAS creates an object that can be reported on using...

Good article, very interesting.

In the meantime you can use the one that I created.

I am working on an article I plan to submit...

As a general note, I suggest looking through this free book (free when downloaded as PDF): SQL Server Transaction Log Management by Tony Davis and Gail Shaw. It's the best...

You can't (not without making serious changes to your...