I say get a book on the exam. They're all similar and the help focus you on the tasks you need to learn and the knowledge required to answer questions....

Congrats!

Do you have the log set to not grow beyond a certain point? I think this wizard has to actually bulk move all data, so that's a lot of log...

I'm curious how you determine that 1000 pages is too high. Paul Randal mentioned this week that he made up that number, as an educated guess when talking with various...

Travel safe, and enjoy the conference.

david_wendelken (11/3/2010)

---

Steve, your analogy about the Mission Impossible vs the Mystery Men teams was a good attempt, but it fails in one seriously important aspect.

Even the Mystery Men team...

I would create new roles, and double check what rights are granted them. Using db_reader/writer is a way to unintentionally allow access to tables.

Make sure that the instances are secured,...

It's yours. Write up a short article and submit it.

Peso,

Take it. I'll close this thread for now.

There's likely some caching going on. I'll have to get someone to flip through the .net code to get me the query.

Wayne has already tackled this. Thanks anyway.

Congrats to the Giants. I saw the 3 run shot in a restaurant last night and I knew then that the Rangers were done.

SSMS does a good job of administration. I'm not sure of a better one. In terms of performance, you have a few choices:

Red Gate is releasing SQL Monitor next week,...

Excellent, and thanks

Doh, my mistake here, and apologies Mike. I misread the first code you posted, thinking you were changin permissions for the sproc at compile time.

The AS DBO at the end...