Same principle - you will get a performance gain but it will only be less of an impact.

For more info check the links in my sig for Kimberly Tripp.

If you are seeing an avg_user_impact of 1000, then adding the appropriate index could improve your query performance by 10x. If a query takes 1 second to run with...

What method are you currently using to create your file name?

Add a variable with the datetimestamp and an expression on the filename of your excel output.

What is the error you get when trying to backup your logs?

It's by design. Expanding a column does not require the truncation of data. Call it a safety measure enforced by Microsoft when you reduce the size of a...

My favorite method of those listed is to use SSIS if you are looking to automate it.

As per the best practice for SSRS - if you have resource intense reports and the reports are being hit constantly, then it is recommended to put SSRS on a...

The best way to determine if SSRS is installed (and not just a reportserver database restored to that instance), is to check the services. If the SQL Reporting Service...

Thus evidence taints truth (if emotion, policy and...

Fal (10/4/2011)

---

I had an interesting moment of reflection whilst helping my daughter with her homework the other day.

She had a maths problem like “102 + 44 + 266 + 78...

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

---

Gianluca Sartori (10/4/2011)

---

OzYbOi d(-_-)b (10/4/2011)

---

Thanks & Good question.

My thoughts...

Thanks for the question.

Have you run a profile or trace when running the report?

Panoply, eversions, cubes, dbcc timewarp