Lynn Pettis (8/20/2009)

---

Grant Fritchey (8/20/2009)

---

Lynn Pettis (8/20/2009)

---

Kit G (8/20/2009)

---

RBarryYoung (8/20/2009)

---

FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. ...

Lynn Pettis (8/20/2009)

---

Kit G (8/20/2009)

---

RBarryYoung (8/20/2009)

---

FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. as before, if you...

RBarryYoung (8/20/2009)

---

FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. as before, if you guys could cover for...

I checked the output from the default trace when you script it, and for EventID 10, there was no Column 1. You might try using column 2. Here's what was...

ruancra (8/20/2009)

---

there is a maintenance plan that runs every night on the user db's to reorganize all indexes, there are 15 user db's on the server, 3 of which heavily...

I don't think anyone has mentioned it, but man, is that query going to run slowly. All those correlated sub-queries are going to be painful. You might want to explore...

If you aren't already, I'd strongly suggest you start treating the database just like your code. Get it into source control and only do your builds & deployments from there...

Also, you need to know, tempdb is used for a lot more than just temp tables. It's used for sorting data, frequently from ORDER BY statements. If you're using snapshot...

To get them execution permissions, I'd suggest giving them execute on the schema:

GRANT EXECUTE ON SCHEMA :: Dude TO Somebody;

In order for them to create procedures, you have to give...

GilaMonster (8/19/2009)

---

Do that...

GilaMonster (8/19/2009)

---

Comment...

Congrats

I would say there's no advantage. The normal backup process is very light-handed. It's transactionally aware, so you get good, clean backups, all without interrupting user access. Why on...

I'd be willing to do it. I like the general concept of a contract-to-hire position.

I don't have a clue. It'd be fun to have that problem though.