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...

It could be compiling & storing the execution plan, or it could be caching the data, or it could be both.

We ran into a similar situation once. What we...

It's going to depend on the service contract you have with Microsoft. It may be a free upgrade per your contract or it may be added cost. It's not automatically...

For 2005/2008, take a look at sys.dm_exec_syessions. It will give you a basic breakdown of information for the connections in the system, including start times on the last batch. For...