I'm running the last CTP, not the RC0 that just came out, but I have 8, 9 & 10 compatability modes. That's 2000, 2005 & 2008.

I'd suggest not going. The...

We have to do deployments out of source control. Sometimes they are incremental deployments and we could get away with having an ALTER statement instead of a DROP & CREATE,...

One other point, submit abstracts to speak at the conference. If you get accepted, they usually wave the fee to attend. As far as PASS goes, volunteer and work your...

I worked for several start-ups and they wouldn't send anyone. Larger companies... I sell it to the boss by pointing out sessions on things that we're working on or having...

Which version?

Do you have any particular error messages?

Several people on the forum's here have installed it with little to no issue, so we know that it does install.

From what you described, I'd go with a single table, Organization, to describe the basic attributes of that object. Then, I'd add a table, let's call it OrganizationType, that lists...

Rather than simply spot checking by running sp_who2, you might consider setting up a trace to capture the stored procedures and query calls on the server over a period of...

In SQL Server 2005 or 2000 without some type of structure or mechanism to gather that data, no.

I did a series of tests because I wanted to write an article comparing OPENXML to XQUERY. I couldn't find a fundamental performance difference in query execution time, scans or...

I agree with Jack. It's like you wrote a product description for SSIS.

For going to Oracle, I'd suggest getting this third party destination device. Otherwise, moving the data to oracle...

Thanks Bart. Very useful information. I think I'll be staying away from the list all columns option though. I do like David Poole's tip up above. I need to remember...

You are quick, Gail! I haven't even been able to download the bloody thing yet, let alone get my virtual's upgraded.

Thanks for the post. One less thing to test.

Great report, thanks Steve. I think you're very right about Powershell. It's incorporated into Operations Manager 2007 and Team Foundation Server. I'm seeing more and more bits & pieces suggesting...

Excellent article TJ. Congratulations on a well ordered process.

Any chance of posting the code for the procs that start the traces? I'm curious about some of the details of how...

Updating the stats will certainly lead to changes in the query plan, depending on what happened in the stats. It's possible that you had a plan that was working well...