Glad I could help.

It depends on the power users and what they were trying to do.

If they were just writing reports, we'd probably give them access to the SSRS adhoc reporting tools. On...

Looks like you either need to split the column to multiple smaller columns or do a LEFT() on the column to fit it into Excel.

Alternatively, you could export it as...

Column run_duration is in sysjobhistory.

EDIT: You also already have the start time. It's column run_time in sysjobhistory. Just pull it separately. Do a CASE to check the job status, the...

Or a disk controller is going. Or someone messed...

Bad behavior is policed by this wonderful thing called a REPORT...

I wouldn't try to restore system databases to the new server as it could cause multiple issues when those dbs upgrade. You shouldn't really need much out of master, but...

I think understanding security is a big must. I don't know if you are assuming that as part of DBA management, but regardless of what kind of DBA you are,...

robert.sterbal 56890 (11/16/2015)

---

So I would recommend after the 2nd or 3rd question that seems lazy for the reply to be:

-------------------------------------------------------

You are asking a question that could be looked up easily...

And if you happen to already be backing up the transaction log, then you may have bigger issues than just a full disk drive. Such as a runaway process that's...

My Patented Wet Noodle <tm> no less. Shame.

EDIT: BTW, I'm teasing you, Lynn.

Ed Wagner (11/16/2015)

---

GilaMonster (11/16/2015)

---

Brandie Tarvin (11/16/2015)

---

Ed Wagner (11/16/2015)

---

BrainDonor (11/16/2015)

---

djj (11/16/2015)

---

I will be the first to admit I am not the smartest person, but at least I try to ask questions...

Ed Wagner (11/16/2015)

---

BrainDonor (11/16/2015)

---

djj (11/16/2015)

---

I will be the first to admit I am not the smartest person, but at least I try to ask questions by providing requested information with...

I've been looking at the data (i.e., the column names) and I just realized this is Adventure works. So I looked again at the problems, actually reading them this time...

ScottPletcher (11/12/2015)

---

He wants to do nothing himself. I tried to walk him thru the logic of how to code #4 in his original q, here:

http://forums.sqlteam.com/t/need-help-case-statement-should-work/4070

but he refused, instead basically...