I haven't seen any, but I'm looking for some.

There is one from VMWare, but since they're selling virtual software, not sure how much to trust it:

http://www.vmware.com/files/pdf/SQLServerWorkloads.pdf

You will get some gains as SQL Server is written to be multi-threaded. Something most desktop apps are not.

That can help with internal fragmentation and provide some speed gains.

However, don't shrink the db. That undoes what you do with reindexing.

detach databases, script logins,uninstall, install, add logins, attach.

Is there a date/time field for updates on the source? If so, that makes it easy.

I'd still use DTS. If the table is small, the truncate works fine. If it's...

This is in Control Panel Services. The MSSQLServer service and SQLAgent services are the defaults. Multiple instances will have the instance name listed.

It's in the registry as well. More info...

This help?

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

As stated above, this is informational. If you have multiple instances, you should set them assigned ports so they aren't constantly changing. Your network people should know which ports are...

A few possibilities. And if you like one or find another, write an article!!! 🙂

First, allow each developer to create objects in their own schema. So developer Bob would create...

I don't believe they do either. There is a 2000 DTS runtime you can install on SS2K5 that will run your packages for you. There is also a conversion utility,...

Great article, Brandie!!!

And thanks :blush:

It can be if you hoard information. However I've seen that often a company doesn't want to (or doesn't have time) to upgrade something and no one wants to work...

I'd add my 2 cents

Programmer - Someone hired to write code

Good Programmer - Someone that gets the code written I need written and it works.

Great Programmer - Works faster and...

I'd vote for the File Watcher task. Works well.

Yep, you can batch your transaction if business rules allow it. You still could end up with stuff to clean up, but I wrote about this before:

http://www.sqlservercentral.com/articles/Miscellaneous/batching/151/

You cannot turn off...