Viewing 15 posts - 31 through 45 (of 275 total)
As Lowell mentioned, it makes no difference if you use different users when they touch the same tables.
I would actually look at the underlying code that causes the blocking. In...
June 25, 2010 at 12:41 pm
Performance will definitively not be an issue.
Having an user per application allows you to be more granular on permissions for each one, so that is actually not a bad practice.
If...
June 25, 2010 at 7:48 am
Same here. We use #1.
Of course you might have fluctuations in that if you change your normal pattern of data processing, but using the backup size trend is pretty accurate...
June 24, 2010 at 7:23 am
Maybe try:
sqlcmd -E -A -Q"alter login [sysdba1] with name = sa;"
June 23, 2010 at 9:06 am
As mentioned, having big tlog files because of lack of backups has its penalty on resources. It could be that it simply is trying to catch up to synchronize them?
June 22, 2010 at 8:07 am
sivaji (6/22/2010)
1. I have a doubt regarding sql server...
June 22, 2010 at 7:36 am
logicwonder (6/15/2010)
The t-log size for the Database A would only grow if the mirroring is not happening. By the way, which t-log is growing?
t-log of Database A is only growing.
...
June 17, 2010 at 1:21 pm
1) How do you have the mirroring setup, with or without witness (async or sync mirroring)?
The t-log size for the Database A would only grow if the mirroring is not...
June 14, 2010 at 12:23 pm
More like this:
DECLARE @JOB TABLE(JOB_ID nvarchar(50))
DECLARE @JOBID nvarchar(50)
INSERT into @JOB (JOB_ID)
exec dbo.GetJobIDForReplicationSnapshot
set @JOBID = (select * from @job)
USE [msdb]
exec sp_start_job @job_id = @jobid
GO
June 8, 2010 at 2:00 pm
I had the same discussion with our SAN admin. He says that the I/O is spread over 10 disks anyway, so having different drives on the same SAN wouldn't make...
June 2, 2010 at 7:07 am
Nice question... with a twist from the QOD from the other day 😀
May 19, 2010 at 7:01 am
It seems that lately there's another wave of spammers.... the really bad thing is that the links they have in their post leads to highly infected websites. I got my...
May 19, 2010 at 6:54 am
You can create a linked server and then query it into your MS SQL DB. Do a little search on this forum about linking MySQL to MS SQL 😉
May 19, 2010 at 6:39 am
You can actually go with mountpoints and hence not deal with one big drive or drives for the images. Just have different Mountpoints and with those either balance or divide...
May 18, 2010 at 1:45 pm
Viewing 15 posts - 31 through 45 (of 275 total)