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  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 6, 2005 at 10:44 am
REMEDY ? As in Help Desk Tracking ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 4, 2005 at 12:41 pm
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 4, 2005 at 11:58 am
Chris, you neglected to mention 'Sybase' ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 4, 2005 at 9:54 am
Viewing 15 posts - 1,831 through 1,845 (of 2,436 total)