Viewing 15 posts - 1,831 through 1,845 (of 2,436 total)
A quick google search ( http://www.google.com/search?hl=en&q=+QuickShift+for+SQL+Server  turns uop a number of hits ... the first hit is from a very reputable site:
October 6, 2005 at 11:41 am
I'd just make sure that NULL-ability, constraints and referential integrity are matched as well. Even with a perfect bcp format file and clean data, if the other things are not...
October 6, 2005 at 11:33 am
Multiple DBA's supporting multiple SQL Servers ... hmmm ... MSX is still your best bet. Each DBA can script their own JOBs and just select the 'target' servers. System maintenance...
October 6, 2005 at 11:31 am
You also must take into account windows user and directory/file pasmissions that are granted to the SQL Server Service (and possible the SQL Server Agent services as well. Also, let...
October 6, 2005 at 11:16 am
Let's start with a few questions ... Is the SQL Server a member of a domain ? Is the computer you are currently logged into when executing the command a...
October 6, 2005 at 11:13 am
The only other advice I have is to update your MDAC ... I believe the latest version is something like 2.8 SP2 ... this will require a reboot of the...
October 6, 2005 at 11:01 am
This sounds like a perfect opportunity to explore SRS - SQL Reporting Services. The high CPU demand reports can be generated during off hours and rendered on demand whilst smaller...
October 6, 2005 at 10:48 am
Whether you use EM or Transactl-SQL setting the size, growth factors and limits for growth works exactly just like any other user database on your server. There is a small difference on the...
October 6, 2005 at 10:44 am
Just what are "AD issues" ??? If you've got a Domain, I see no reason why you should not be able to cluster servers and then install a SQL Server...
October 4, 2005 at 12:04 pm
Are you using VERIFY ? If you are, try turning VERIFY off in youe maintenance plan. If the failures stop, you are being bitten by an MDAC "bug" - which...
October 4, 2005 at 11:58 am
Chris, you neglected to mention 'Sybase' ...
October 4, 2005 at 11:53 am
If the data load volume is high and the table is truncated before the load each time, dropping and recreating indexes after the load may be the ticket. However, you...
October 4, 2005 at 11:45 am
When the script is complete could you post it ? This would become an invaluable tool for SQL DBAs everywhere due to present EM limitations.
October 4, 2005 at 9:56 am
Here's an invaluable reference for the system tables (while they still exist):
http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.mspx
October 4, 2005 at 9:54 am
Viewing 15 posts - 1,831 through 1,845 (of 2,436 total)