SQLRNNR (12/2/2014)

---

Chad Crawford (12/2/2014)

---

Perfmon for us too....

What are you rendering the report as in the subscription?

Not that I'm aware of. If this is for in-house developed databases I'd suggest using source control either with SSDT database projects or RedGate SQL Source Control. RedGate...

The LOOKUP function is what popped into my head, but I'm not positive that this will work.

Sounds like you want to customize the display of the report in Report Manager. Unfortunately SSRS doesn't give us control over how the report manager looks. You could look...

There are all the regular ways in SQL...

Ed Wagner (12/2/2014)

---

GilaMonster (12/2/2014)

---

Sean Lange (12/2/2014)

---

This beauty was around 6,000 lines long. That was not a typo. It was a "single" query with something on the order of 200 instances...

Glad I could. I'm still working in 2008 and I've had the same thing happen to me with some packages written by others.

Igor Micev (12/1/2014)

---

Jack Corbett (12/1/2014)

---

I always point people with MaxDOP setting questions to this KB Article to start with. It sounds like in your situation with only...

I always point people with MaxDOP setting questions to this KB Article to start with. It sounds like in your situation with only 4 cores 0 is probably okay,...

Yes, all these troubleshooting options are useful when the issue is occurring.

It sounds like the database was restarted and whatever transaction that caused the log to grow was lost (the...

Sounds like there are expressions setting the database name. Right-click on the connection manager and select properties. Then expand the Expressions property. This should show you...

The format expression should be MM-dd

Did you restart SQL Server? According to this BOL Article the new name is recognized at SQL server startup.

First thing to look at is the log_reuse_wait_desc in sys.databases. Then you can look at DBCC OPENTRAN() or query the sys.dm_tran_% DMV's to see what the transaction is.

As a...