Seeing your query I don' think your main problem is the CASE statement included in the GROUP BY, I think it more likely related to your CROSS JOIN's to the...

Good...

Okay so there are no scheduled jobs on that server. Is there an SSIS package or something else on another server that is doing a data load?

The script I...

The URL for the pretty SSRS interface isn't http://servername/reportserver it is http://servername/reports. That drives me insane as well.

It will definitely have some impact because now the the QP has to apply the case and then do the aggregation(s) which are may need ordering in addition to...

I'd start by looking in the Default Trace for the Autogrow events for the log files and see what time(s) they are occurring. Then I'd look at Agent jobs...

Team A clearly still needs sysadmin rights.

Now come the questions about Team B:

Are they developing across all DB's or are they divided among DB's?

Do you have dedicated Dev/QA/Prod environments? ...

The only comment I'd have is that your check for availability is outside the transaction, so in theory you could have another session create a conflicting reservation at the same...

Does this help, http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/77c224fd-d3d8-427e-ace8-8c7c237bc830?

Lynn Pettis (2/7/2012)

---

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at...

Nido786 (2/6/2012)

---

Thanks for reply but the link you shared is no longer available.

i am worried this Db corruption due to hardware failure or other reasons.

please guide i will thank to...

Grant Fritchey (2/6/2012)

---

Understood.

I'm just nervous. We've...

What does an article/podcast on "System Logging in the IMB i" have to do with SQL Server 2008 encryption?

I don't know the answer but a quick search turned up this article from Microsoft about making SQL Server compliant with FIPS-140.

SOrry, that's Microsoft Customer Support Services. You might get someone on here or another forum to answer your question, but who knows when.

I did do a quick...