I have the 4 system DB's IDs memorised. It's quicker when reading through syslockinfo. Come to think of it, I have half of my user DB's ids memorised too... :hehe:

I...

Amanda Walshaw (9/29/2007)

---

dear forum,

So dettached the mydatabse from enterprise manger (no one is on the system by the way its a sunday here) deleted the log file and in...

Jeff Moden (9/29/2007)

---

I can't tell you the number of folks I've interviewed who have Masters or PHDs in mathematics that couldn't tell me what bit will be set by 2⁴...

The only time I've ever had to directly modify the system tables was to fix stuff-ups caused by idio^H^H^H^H other DBAs directly modifying the system tables.

Ever seen a table with...

Consider service broker. The triggers just insert messages into the queue. Message delivery (may be the same db) triggers off a async process that goes off and does whatever necessary...

Won't work with 2005's encryption routines. They're...

Maybe. I picked GMT-2, not SA specifically. Maybe DST is enabled for all zones by default. Hmmm, checking DST has no effect, neither does unchecking it. Very weird.

Isn't a big...

Congrats. When's the party? 🙂

Damon Wilson (9/28/2007)Like GilaMonster mentioned, you may get 2 Case Study questions in your pool of 25 (or however many) exam questions. You have the entire 90 or 60...

iirc, it wasn't a class. Was during supper on friday night. Was a group of 12 or so of us and most of the people at the table were MVPs...

May I ask what you're trying to do and why you find it necessary to change the system tables? That way lies madness

If I may suggest, do your formatting on the front end, not in SQL. VB has far more options for date formats than SQL does and it quite a bit...

MSDB is a perfect example of how not to design a database. Every time I have to get data from that DB I end up tearing more hair out.

The...

p.s. If you can, go and sit with one of the users who is complaining so that you can see what's happening.

I heard a good story at PASS. One guy...

Jeff Moden (9/27/2007)

---

You could start by running sp_Lock during the periods of slowness. Running sp_HelpDB will allow you to figure out the DBID for TempDB... check for blocking on...