Viewing 15 posts - 30,616 through 30,630 (of 39,754 total)
We've scanned for service accounts, but that might not help with Express/MSDE.
The only good way is to get a list from SMS, then connect to each instance and run select...
November 26, 2007 at 11:09 am
Unspecified means there was an error, but no one wrote a handler for it.
You can try a few things. If you can manually run the DTS package, run it against...
November 26, 2007 at 11:07 am
Turn it off: http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/28/turn-auto-shrink-off.aspx
It could cause blocking, but it's a bad idea.
November 26, 2007 at 11:06 am
If F is R1+0, I'm not sure that adding one drive and moving logs there helps that much. How much log activity do you see? How many drives are on...
November 26, 2007 at 11:05 am
From my understanding, if the query is completely on the remote server, it is passed through (WHERE clause and all). If this is a distributed query, meaning you are joining...
November 26, 2007 at 11:01 am
I believe the SQL 2000 standard sees 2 CPU sockets, but the architecture will spread the SQL 2000 threads on 8 cores. I'll ask around and see.
November 26, 2007 at 10:57 am
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
Viewing 15 posts - 30,616 through 30,630 (of 39,754 total)