Thanks for the reply, Peter. 50 hours per week, you say? Thank the Maker I'm a contractor

This sounds like two very different jobs for one salary. Considering it would demand at least 60 hours per week to perform adequately, I would expect the salary to be...

Thank you Vincent for taking the time to write this article. It is coherent, concise, and useful. Well done!

In the section titled "Fact Table Partitioning" (near the bottom) I...

Great article, thank you. I think bitmasking is particularly useful for dealing with data permutations (e.g. dimension members in a data mart). And for those people who think 100 columns...

Reading the post again I just want to say, SQL 2000 is soo 6 years ago

Or to put it another way, the future was...

Ah Bill, still looking are you? Maybe consider offering this as a contract position in the $75/hr range? The job content itself looks excellent but the level of person you...

A couple that stuck in my craw:

1.3 Uninstalling SQL Server 2005 SP2

Once SQL Server 2005 SP2 has been applied, it cannot be removed without uninstalling the entire product.

-- You can...

Hmmm, super generous in Jacksonville. So, about $800/day then? That's less than a big consultancy will charge you for senior SQL...even the Indian ones.  I would consider that super generous...

Considering the Denver tech sector is in it's 5th straight year of decline AND had the 3rd highest home foreclosure rate in the nation for Q3, I'd say anyone moving there...

The bullets say $100k but the "3 years experience" says less. Certainly would be nice to see these job reqs framed in terms of a mutually beneficial relationship. Basically: 1)...

Colin: As I live in Sydney I think I can speak with some authority. $80k is about $40/hr over 12 months. That's a little low if you are in Sydney...

Seth,

I'd think you'd be better off focusing on solutions and then finding a technology that suits. For example, you might find it useful to start a series of SQL agent jobs...

Now, here's a question: Typo aside, does anyone actually find this job interesting? The reason why is that I've been doing SQL work in various roles for about 7 years...at...

Brent,

The detach/attach option requires exclusive access to the database. That means only you can connect to it while running the sp_detach_db command. Don't forget that you also need to factor...

Brent,

Colin kind of alluded to this, but have you tried attaching a copy of the database rather than restoring the DB backup? A backup doesn't necessarily preserve every bit at...