I would like to see it broken down, even further than just 3 general areas. I think there is value in proving T-SQL skills alone. Probably value in overall administration...

WayneS (4/5/2010)

---

I don't know. But, there is a SQL Saturday this weekend in Richmond, VA that I'll be attending. If we can have something ready by then, I'll do what...

I like the idea of carrying my environment on a flash drive. I just think I want to wait for USB 4.0 before I really do it and get some...

If you can, it would be great for you to capture a workload and then some CPU/mem/disk stats before and after compression. That would make a great article on a...

If that's the case, you might be surprised what compression does for you.

So data compression can help because it substantially lowers I/O. It sounds crazy since it will use more CPU to do the compression, but you end up saving resources if...

Why are you doing this? Is it for reporting or are you considering storing the data in this format?

We used to do something similar for sending email here on the site. we had multiple machines that sent, and needed to read a database table to get their list...

Just a quick note here. Can someone take a moment and summarize what they see as the consensus here and start a new thread in the Certifications forum? (http://www.sqlservercentral.com/Forums/Forum10-1.aspx)

Not to...

SELECT client_net_address, client_tcp_port

FROM sys.dm_exec_connections

Note that there is also a WITH TIES option.

Here's the BOL entry for TOP http://msdn.microsoft.com/en-us/library/ms189463.aspx

I think from this entry (http://www.sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-12-Should-you-create-multiple-files-for-a-user-DB-on-a-multi-core-box.aspx) I'd say it might help. Paul mentions that SS2K8 has some parallel enhancements here.

Unless you can separate things out physically, however, I would...

CirquedeSQLeil (4/5/2010)

---

Nostalgic yes - But I have found that a bunch of mine were unreadable after several years in storage. I think I still have some, but most were...

A couple years ago someone gave out a complete copy of W95 on floppy disks as a white elephant gift at Christmas. That was pretty funny.

I think I've trashed all...

Thanks for the update. It happens, and this thread might help someone else figure out their issue earlier because of your post.