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.

You still have a package!?!?!?!?!

Geek alert! Whoop!

I don't think I had good bootable images until W2K or XP even. Seems like I always had some rigamarole when I downloaded an...

Definitely this isn't something you fix for free. That's one I'd document as well if someone gave me a requirement of "no FKs"

Just to add to what Rob wrote, SQL updates ALL indexes on the table when a record is modified. For NCIs (nonclustered) , that can mean adding in new rows...

Didn't w98 will require some DOS boot stuff for setup? Not sure since I stuck with W95 until W2K

Ho, eye mike meesteaks alll teh tmie

Seth, you're in a tough spot.

I think you know what makes sense, and perhaps the best idea is to go for things in a piecemeal fashion. Try to get some...

I think that any exam can be gamed to an extent, and despite all the efforts put into doctors, we still turn out poor doctors because the real world isn't...

I hate to get the black and white "wrong" in there. There is an exception to every rule, including mine. While I'd argue that 99.99% of the time if you...