Hugo,

No offense and you brought up some great points, but honestly when I'm working on questions, I work in one area, try to write 3-5 questions on something in that...

http://www.sqlservercentral.com/columnists/sjones/3044.asp

Got a second part coming as well.

You ALWAYS want free space in your data files. This is so as you add data, it has a place to go. The only time you'd want 0% free space...

If I understand, you want to create a new log file and then remove the old one from your database? AFAIK this isn't possible. You can "move" the log to...

I don't live in Iowa and I use Google too. I've been disappointed in Live, though the MS folks at TechEd claim it's much better.

I'm sure Google made the decision...

Wow, you guys are overthinking this. The questions aren't intended to cover every possible option on your server. It's intended to help you learn about one tiny aspect of SQL...

And enjoy yourself!!!

Have fun, joke with friends and co-workers, smile, take "fun breaks", run to Dairy Queen/Starbucks/Jamba Juice, keep a football around and throw it with a friend for 5...

Redd has a great explanation and I'll just add my little bit to it.

The memory above 4GB is "swapped" or "mapped" (not sure which) down into the OS section of...

I've heard great things about both Red Gate and Innovartis (dbGhost) as products from people. Haven't really used either, but people seem to like both.

Best thing is store the data that needs to be Net Sent in a table somewhere. You can make a copy or even just add a field in your table...

Are you talking about data changes? What type of history are you planning to maintain? Entire life of a row? How big a job is that in terms of tables?...

That's a local setting on the client. I have one machine that pops a new tab in Firefox. The other opens a new window in IE. Not sure what I...

The energy savings only really occur on CRTs. If you've moved to LCDs, it's the same energy no matter what. And it's a good point that if you are using...

The article was commissioned by Red Gate and sent to me, same as any other article, though I'm honestly not sure if me, being SSC, is paying for it or...

FYI, Wal-Mart is also installing solar on a number of stores. Another company that many people are not happy with