Jeff Moden (7/28/2009)

---

Grant Fritchey (7/28/2009)

---

Jeff Moden (7/27/2009)

---

Grant Fritchey (7/27/2009)

---

Man, I'm clearly not doing things correctly. I've had to present twice a year for the last three years. I have the...

There is no process for creating system catalog views. They are part of the normal running of the system and will be there after a successful install.

Are you sure...

there is just no way to be sure. You have to know all the processes that access the system inside & out. For example, even if you monitor the system...

Jeff Moden (7/27/2009)

---

Grant Fritchey (7/27/2009)

---

Man, I'm clearly not doing things correctly. I've had to present twice a year for the last three years. I have the hardest time getting anyone,...

Lynn Pettis (7/27/2009)

---

Well, it is now official. We are down one daughter in our household.

Kassondra is now on her way to Fort Jackson in South Carolina to start her...

I have yet to see someone eliminate code duplication within a database. It's just too easy to start doing... whatever. Generally a good naming convention will tend to inform the...

My younger sister had plates that read IODADDY or something like that. I always read them as 'I/O Daddy' like some sort of nifty geek hipster, not 'I owe daddy'...

Huge topic. You might want to start off defining your role. Take a look at Craig Mullins book called "Database Administration." It's system agnostic and very useful.

If you mean that you intend to use functions instead of referring to the tables or views, excercise a great deal of caution here. An in-line table valued function can...

I'm not trying to be obtuse, I just don't understand what you are referring to. Do you mean queries coming from Reporting Services?

Oh, sorry, I couldn't tell you. I haven't even seen a beta yet.

GilaMonster (7/27/2009)

---

Roy Ernest (7/27/2009)

---

Bill Wunder. He is the co founder of the group. 🙂 So it was easy to get the first speaker. But after 3 months, I am planning...

When you say SQL, do you mean an individual SQL statement? One that is currently running? I'm not entirely sure, but you may not be able to drill down to...

I'd like to second Gail's suggestion. It sounds like a great candidate for some re-work, re-design & tuning.

Roy Ernest (7/27/2009)

---

Bill Wunder. He is the co founder of the group. 🙂 So it was easy to get the first speaker. But after 3 months, I am planning to...