Let us know how this works. I think it should work fine for you on the file fragmentation of the MDF. It shouldn't change any internal fragmentation of tables inside...

Good for you. A few...

brrrr, cold and windy

You can try this: http://ask.sqlservercentral.com/questions/71956/getting-the-source-code-from-a-clr-assembly

The compiled code is stored in the system tables. Decompiling it can be tricky. .NET Reflector from Red Gate may help, or another decompiler, but it...

The idea from GSquared is nice, but it could be a problem as well if you don't document this and make sure alerts will not fire or someone will not...

Not unless you had some type of monitoring or tracing in place. This isn't captured by default.

First, you mean SQL Server 2008 R2. SQL Server 2008 is a completely separate product. If you confuse this, you might find yourself in a lot of trouble.

I don't see...

Fundamental architeture. SQL Server has multiple database per instance, Oracle doesn't. Understanding some of the layout of the internals is helpful.

Backups - Make sure you have a solid grounding of...

I agree with Sean in terms of the GUID. If you have a good reason, use them, if not, use an identity.

If you're worried about data size in a column,...

First, why do you want to reduce the size? Is it too large based on the transactions that occur?

What's the log file size and what's the peak log backup size...

I like what Guras has done. You never know what jobs will change, and you might not want new jobs disabled. Or maybe you do, but if you want specific...

I was cursing a printer a couple years ago, maybe 5, and checking settings, looking for drivers, etc. After 30 min, my wife asked me if I'd checked the cable.

RS-232...

GSquared (12/1/2011)

---

My wife and I are celebrating our 21st anniversary today. As part of that, I'm taking next week off of work (my third vacation since 1988), and probably...

Good luck. Two weeks to cram.

I don't know of any free tools that do the monitoring that is like SQL Monitor. There are some that do some baselining and capturing of information on Codeplex, but...