sqlfriends (2/5/2013)

---

Thanks ALL.

I read a tutorial and recommend this option should be enabled for all instances. Read and still a little confusing about when I should enable or disable it.

I...

GilaMonster (2/5/2013)

---

SQLRNNR (2/5/2013)

---

If you have a ton of one off types of queries - this can be helpful. The downside is that you may start seeing parameter sniffing and...

It's really a preference for the most part.

If it were me, I'd use compression in my backups from the start.

Yes :crying:

Ad hoc workloads is there to help with plan cache pollution. If you have multiple single use queries, a stub is saved instead of the entire plan. If...

:w00t:;-):cool::hehe:

Expanding on Steve's script a little, here is one that I did:

SELECT T1.Name AS DatabaseName

,ISNULL(t2.database_name, 'No Backup Taken') AS LogBackupAvail

,T1.recovery_model_desc

,'Log' AS BackupType

,ISNULL(CONVERT(VARCHAR(23), CONVERT(DATETIME, Max(T2.backup_finish_date), 131))

, CASE WHEN T1.recovery_model_desc =...

This was 2+ years ago. I don't recall the version. We did contact EMC and got nothing in return.

You're welcome.

jasona.work (2/5/2013)

---

Well, the choice was made yesterday, and the car picked up last night.

Due to Subaru instructing their dealers: "Sell at MSRP and NO LOWER" on the BRZ, we got...

Ray K (2/5/2013)

---

Lowell (2/1/2013)

---

in my youth, i owned plenty of GM, Fords, even a Dodge or two...back then all i could afford was used cars, which are usually someone elses...

The way I like to do it in SSRS is start first with the tsql that will create your report dataset. So in this case, what is the tsql...

Nice job with the question Tom.

Just connect to the database engine where your ReportServer database resides (no need to connect to reporting services in management studio).

Run the query from within management studio pointed at your...

Are you using reporting Services 2008 or 2005?