Viewing 15 posts - 30,691 through 30,705 (of 39,823 total)
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:
November 26, 2007 at 10:56 am
You will get some gains as SQL Server is written to be multi-threaded. Something most desktop apps are not.
November 26, 2007 at 10:54 am
That can help with internal fragmentation and provide some speed gains.
However, don't shrink the db. That undoes what you do with reindexing.
November 26, 2007 at 10:53 am
detach databases, script logins,uninstall, install, add logins, attach.
November 26, 2007 at 10:51 am
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...
November 26, 2007 at 10:48 am
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...
November 26, 2007 at 10:45 am
November 26, 2007 at 10:44 am
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...
November 26, 2007 at 10:42 am
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...
November 26, 2007 at 10:41 am
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,...
November 26, 2007 at 10:38 am
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...
November 26, 2007 at 8:52 am
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...
November 26, 2007 at 8:50 am
I'd vote for the File Watcher task. Works well.
November 26, 2007 at 8:47 am
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...
November 26, 2007 at 8:46 am
Viewing 15 posts - 30,691 through 30,705 (of 39,823 total)