QA is the step that follows Production Deployment.

Question and Answer to how the new code works.

If there are no Questions to Answer, and we did any testing between Dev and...

Even if everything is available and installed, it may not run well on the same server.

But you should be able to see what you own.

It is always good to look...

Enterprise Editon?

Data Driven Subscriptions come to mind, especially with Quarterly and Yearly you mentioned.

Each subscription could pass the different dates easily.

I see you are running R2.

The reason for asking about other applications - especially SSAS - is that SQL and SSAS will use all the memory you can give them.

Flushing...

Is this a dedicated SQL Server?

Or are other applications running on it?

SQL 2008 or 2008 R2?

R2 has some improvements in how it handles memory.

Especially if you are running both SQL...

I assume that you are on SQL 2008 R2 even though this is a SQL 2005 thread.

This version of SQL server has a number of BI enhancements.

You might want to...

Here is a link that explains Kerberos for the whole stack.

It is long, but covers much more than RS.

All machines involved need to be setup.

i.e. - not just the Reporting...

Jeff Moden (10/17/2012)

---

Sean Lange (10/17/2012)

---

Jeff Moden (10/16/2012)

---

Wow... recent interview of a Web Developer interviewee just set a new record. Interviewee claimed 14 years experience in SQL (mostly Oracle) and...

Consider windows page file, tempdb, db files, and log files as candidates to move.

Also part of the picture is as others point out, what kind of IO patterns there are.

And...

Koen Verbeeck (9/19/2012)

---

jcrawf02 (9/19/2012)

---

L' Eomot Inversé (9/18/2012)

---

No,...

Brightened my morning. 😀

Jing - free version has 5 minute limit, which is enough...

This might start your day out with a chuckle.

It sure made my day.

I had one of my users ask me to troubleshoot a query.

She said this one and several other...

The rapid posting must have defrosted hundreds of pork chops. 😀

Four banded?

I heard rumors a Trebuchet is in the works.

Kudos to Jeff on the restraint shown.

And some of the others.

Dog...

Sean Lange (7/16/2012)

---

L' Eomot Inversé (7/15/2012)

---

Thanks to "El" Jerry, Jason, Lynn, Paul, Stefan, Gianluca, Bex, Grant, Brandie, Greg, Kiara, Revenant, Sean, Craig, Rodders, Dwain, Ray, Jeff, Jack, Wayne, Jan, and...