Forum Replies Created

Viewing 15 posts - 31 through 45 (of 279 total)

  • RE: AWE

    sudhakara (7/28/2010)

    jezza101 (7/28/2010)

    sudhakara (7/28/2010)

    But i dont know why only 4 GB can able to access even if i have 6 GB of RAM in my system.

    You might find the answer...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 28, 2010 at 7:43 am

    #1199237

  • RE: Disable All Triggers

    Good question and use of the undocumented sp_MSforeachdb.

    Now, I have a remark here, the question stated "...disable all triggers in a database".

    As Hrvoje noted above, Database scoped triggers as well...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 1, 2010 at 7:39 am

    #1187661

  • RE: PRINT vagaries

    Great question.... something new learned 🙂

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 30, 2010 at 12:27 pm

    #1187268

  • RE: SQL SERVER 2005 Users cloning

    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...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 25, 2010 at 12:41 pm

    #1185207

  • RE: SQL SERVER 2005 Users cloning

    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...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 25, 2010 at 7:48 am

    #1185000

  • RE: Predict the size of database growth

    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...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 24, 2010 at 7:23 am

    #1184479

  • RE: Upgrade to 2008 from 2005 failed due to sa account being renamed

    Maybe try:

    sqlcmd -E -A -Q"alter login [sysdba1] with name = sa;"

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 23, 2010 at 9:06 am

    #1184017

  • RE: whats is exactly going to send to mirror from principal (all tlog or just delta)

    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?

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 22, 2010 at 8:07 am

    #1183352

  • RE: whats is exactly going to send to mirror from principal (all tlog or just delta)

    sivaji (6/22/2010)

    Being a programmer with no database knowledge/experience, I am requesting answers to following questions as I am kind of stuck now:

    1. I have a doubt regarding sql server...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 22, 2010 at 7:36 am

    #1183326

  • RE: Mirroring and triggers - effect on transaction log sizes.

    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.

    ...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 17, 2010 at 1:21 pm

    #1181808

  • RE: Mirroring and triggers - effect on transaction log sizes.

    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...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 14, 2010 at 12:23 pm

    #1180043

  • RE: Pass dynamic arguement to sp_start_job

    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

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 8, 2010 at 2:00 pm

    #1177657

  • RE: Disk Queue length

    Great stuff Randy. Thanks for the info you shared.

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 4, 2010 at 9:35 am

    #1176597

  • RE: Disk Queue length

    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...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    June 2, 2010 at 7:07 am

    #1175261

  • RE: Insert with OUTPUT clause

    Nice question... with a twist from the QOD from the other day 😀

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    May 19, 2010 at 7:01 am

    #1169396

Viewing 15 posts - 31 through 45 (of 279 total)