Viewing 15 posts - 31 through 45 (of 128 total)
You could also try the second query with an exclusive lock in a transaction - same as the first.
March 30, 2005 at 4:50 am
Moved 100GB database from one datacenter to another using the backup, transaction log method.
Just need to know how long it will take your backup to copy over the network...
March 30, 2005 at 4:45 am
What is the row size for this table? Are you using text in row or text pointers?
March 29, 2005 at 2:20 am
Is it possible that the Veritas backup is still doing some cleanup activity - writing logs or doing verification. Can you delay the start of SQL by a minute or...
March 29, 2005 at 1:46 am
You can encrypt dtored procedures and views. But you want to stop the reverse engineering of your logical database design, so you have to make sure that nobody has sa...
March 28, 2005 at 4:23 am
Totally agree with DC - getting a network guru to analyse your traffic 4k is good - but in heavy insert environments I have found 8k to be better as...
March 24, 2005 at 3:07 am
I am currently working on a largish (288 tables) transactional replication. Currently setup as one publication. We are reviewing all tables firstly to see if they need to be replicated...
March 23, 2005 at 12:46 am
Are you able to restart the SQL Server Agent service?
March 23, 2005 at 12:37 am
You wont be able to start the SQL Server Agent service unless the MS SQL Server service is started - that is the dependency service. Can you start sqlserver from...
March 23, 2005 at 12:30 am
I am assuming that in your Control Panel Regional settings you have set either Traditional or Simplified Chinese set. Are you using EM to open the table and return all...
March 22, 2005 at 12:36 am
Agree with Phil - your better off having your own DBAUtil database. You could also encrypt the stored proc, but remember to keep the source in source safe (or the...
March 22, 2005 at 12:21 am
Forget emergency mode - see if you can get it back online by changing the status and then do a backup. Otherwise stop the SQL services and take a copy...
March 21, 2005 at 3:16 am
Overhead of having the log file growing all the time and fragmentation of the log file.
March 17, 2005 at 2:01 am
By having concurrent snapshot processing you are being deadlocked as you cannot obtain the exclusive lock. Maybe to improve performance you can increase maxbcpthreads and do not use concurrent. Thsi...
March 16, 2005 at 2:32 am
Viewing 15 posts - 31 through 45 (of 128 total)