If you're doing transactional replication you can minimize blocking by doing a 'concurrent' snapshot. Requires you to check the box in the pub options in SQL2K, is the default in...

Correct, pretty common to see user procs defined as usp_blah rather than sp_blah.

You should definitely write something. All too often those 'new features' end up hurting those of us used to a certain behavior and they kinda forget to put that warning...

What changes in 2005 do you attribute the perf increases to?

Assuming the table is big enough to be worth partitioning (big enough that you don't just get scans by default) you should always see a performance boost when doing a...

Absolutely the not for replication option existed in SQL 2000, but it was not used if you set up a standard transactional pub - in other words if you had...

I disagree that building the sql instead the proc is the better option. It's a valid option, but if you're building a really advanced search it's just cleaner to build...

I use procs for everything except dynamic searches, ones where they can select the columns, tables, etc based on some type of search UI. Just too ugly to do any...

If you're adding or dropping columns from a transactional pub you can do so without dropping the article, either using the repl gui or sp_repladdcolumn/dropcolumn. For column changes you typically...

You could script the creation of the articles each day, I think over time that might get unwieldy unless you're also dropping off old tables at some time interval. Not...

Did you check that you were using the same set options in both places. Some of the settings can result in different performance.

I'll add my own 'nicely done' - I dont think there is any such thing as a simple migration!

Glad to hear you got it resolved, and without the extra weekend!

How many inserts/sec are you doing that you cant afford a clustered index, on the tables that have a...

SQL2k or 2005?

I agree with using stored procs for most data access, the exception being truly dynamic cases like searches - those can typically be done client side more easily, but you...