Gianluca Sartori (10/1/2011)

---

Evil Kraig F (10/1/2011)

---

Lynn Pettis (9/30/2011)

---

Okay, for $250 - $750 USD I want the following:

Need Software with following modules and features...

... an entire software suite from the land...

No.

Not that it matters now, but what would happen if you'd pin a table that has 10 GB of data with only 8GB on the box?

That seems like a good...

Pravasis S (9/29/2011)

---

The problem is, it does not show any error messages when copy paste the URL. I takes me to a default page saying the web page does...

MidBar (9/29/2011)

---

Excellent! yes it works. However, the next proble is sheet names in the same workbook.

They appears as sheet1, sheet2,sheet3.....

But with one individual report and export it actualy gives...

Can you post a screenshot of each (without login / password info).

Thanks for the feedback.

As always SOMETHING changed :-D.

This is simple detective work. See what SSRS is REALLY sending over to sql server and match the where accordingly.

I'm sure you can handle it from there!

Grant Fritchey (9/28/2011)

---

Just check the execution plans on the queries to see what, if anything, changes when the index goes away. It's not a measure of performance, but it's always...

P.S. NEVER use autoclose or autoshrink on the busy db!

The simple-talk article will definitely help if the problem really comes from the server.

Every other operations on that table.

This implies a much more complicated setup unless you have some unit tests ready.

I have a similar setup here.

What I do is use the ALL_ERRORMSGS & NO_INFOMSGS switches that way I get data back only when there's corruption.

Also if you do really have...

That solition can be found in a single query.

Use inner join to match the rows between the tables.

Sum to get the total sales

Group by to (you'll see)

order by DESC...

Profiler might actually help.

You could search for long running transaction.

You can also filter based on the rowcounts column. Look for something freakishly out of the normal range....

Google brent ozar blitz.

That'll give you a script along with a 2.5 horus video that explains how to use it.

Of course this only begins to scracth the surface of what...