Viewing 15 posts - 39,376 through 39,390 (of 39,466 total)
I am strictly MS for DB servers (5 SQL2K, 1 SQL7).
I do, however, work on the network architecture and management for our firewall and load balancer.
Steve Jones
August 13, 2001 at 11:01 am
My 2 cents:
Use Log shipping. Both methods will do the job, but when you have a failure and have to move back to the primary, replication will be more problematic.
Log...
August 13, 2001 at 10:58 am
It's hard to pick benchmarks, because what works for one app may not be good for another. Trans/sec is only a good benchmark under a steady load. If your servers...
August 13, 2001 at 10:56 am
August 13, 2001 at 10:50 am
You will likely have to call MS for support. Have any changes, anything at all, even not SQL related been made to this server? When was the SP applied?
Steve Jones
August 13, 2001 at 10:50 am
Use it on both.
export from v6.5 using it IF you are using the v2000 BCP program. You could also use the v6.5 program (on the v6.5 server) and then only...
August 13, 2001 at 10:49 am
What type of remote server? Different providers support different types of operations.
You should be able to add this item as a linked server and perform a delete against it. If...
August 13, 2001 at 10:47 am
You can get around the SQL 7 issue with a password, though you have to be aware of the differences in DTS tasks. Only some of the tasks are available...
August 10, 2001 at 7:56 am
August 9, 2001 at 1:04 pm
Rant does mean the same and nice rant.
I think you will find there will be a movement of the stuff you write in ADO to stuff MS has written. Don't...
August 9, 2001 at 1:03 pm
Not sure what you mean, but you can truncate the table and reload it each day.
Steve Jones
August 9, 2001 at 1:00 pm
I'd keep them local. That way in the event of SAN failure, you could still start SQL server and load the dbs elsewhere, reattach and go.
Steve Jones
August 8, 2001 at 6:07 pm
We should probably break this to a new thread, but did you log into W2K as the SQL account, start Outlook and send mail?
If so, right click outlook and view...
August 8, 2001 at 6:06 pm
If your WHERE clause (or other join clause) only contains the second column, then yes, you need a separate index.
I.E.
table has ColA, ColB
index is testindex( ColA, ColB)
For
select * from table...
August 8, 2001 at 11:11 am
Viewing 15 posts - 39,376 through 39,390 (of 39,466 total)