Perhaps SQL 2005 would be happy assuming that the intent is to use Assets.Location since that is what is referenced in the field list (I don't have enough experience with...

For some reason I didn't or have not yet received email notification of your replies!

Anyway, the table is 4100 rows of about 300 bytes, so not very big. Permitting...

Unfortunately my box has four drives, all in RAID-5 config, so I'm fighting from the get-go (it was that way when I got here). The case has two more...

There are some reasons to look for the next step in your career, regardless of whether or not it is with the same organization. The first is blocking. ...

I tend to agree, Tim. Perhaps it's a matter of scale. In a large organization with a large DBA staff, perhaps a highly skilled DBA with an MBA...

Wow. I had heart surgery when I was 18 months old and I can't imagine what my parents went through prior to that. Reading what her parents have...

Sounds very cool! One of these days I hope to spend some time in the UK as my wife is Scottish (her parents came to America in the 50's)....

Unfortunately the blog is inactive and frozen, so there's no easy way to ask him his reasoning directly. I agree, unless your disk system is optimized to take advantage...

I was fortunate. I had been doing database development for about a decade in dBase/Foxbase/Wang Pace/DataFlex (don't THOSE bring back memories!) when we bought SQL Server: I think version...

Wow. I was expecting 3rd quarter for SQL 2008. I've got a server migration and upgrade from 2000 Standard to Enterprise and I was considering taking it to...

Thanks for the suggestions, Ken, I think it's on the right track. I've created a group on the server with my limited rights test account as the sole member...

James, if you're not a 24/7 shop (or in your next maint window), how about stopping and restarting the instance to reset tempdb, then have SQL Profiler monitor the heck...

Excellent reply, Stephanie! Wanna come work for us?

Congrats, Jacob! I look forward to your XML series! (I'm not an XML fan, but I do have a somewhat open mind)

I've managed to avoid XML thus far, but it's lurking around the corner for me. I've got two laboratory database systems that apparently I'll have to use XML to...