Forum Replies Created

Viewing 15 posts - 646 through 660 (of 757 total)

  • RE: whai is the need of adding T845 oarameter in startup in sql server

    c.ajitkumar (11/21/2011)

    Hi,

    Please give me the explanation about when to add T845 parameter in start up

    for LPM(Lock pages in memory) for 32 bit system

    -T845 Does nothing for 32bit systems

    The trace...

    November 22, 2011 at 6:09 am

    #1411395

  • RE: DBCC Shrinkfile

    fitsumkh (11/18/2011)

    I would suggest finding what the underline cause for your transaction log file to increase by a lot, this could be caused by:

    - Full Recovery Model DB without...

    November 20, 2011 at 10:58 pm

    #1410478

  • RE: MIGRATION 2005 => 2008 => but now web site is too slow !

    Not sure if it's relevant

    Have you run DBCC Update usage?

    November 18, 2011 at 3:24 am

    #1409764

  • RE: Alerts & Operators

    deepak.a (11/18/2011)

    derekr 43208 (11/17/2011)

    Dev (11/17/2011)

    Should I suggest you some reading?

    Defining Alerts

    http://msdn.microsoft.com/en-us/library/ms180982.aspx

    No Suggestion needed

    I found what I was looking for.

    can you share the solution which you found ?

    The alert...

    November 18, 2011 at 2:31 am

    #1409739

  • RE: Alerts & Operators

    Dev (11/17/2011)

    Should I suggest you some reading?

    Defining Alerts

    http://msdn.microsoft.com/en-us/library/ms180982.aspx

    No Suggestion needed

    I found what I was looking for.

    November 17, 2011 at 11:56 pm

    #1409694

  • RE: DBCC Shrinkfile

    Thanks All

    derek

    November 17, 2011 at 11:30 pm

    #1409689

  • RE: DBCC Shrinkfile

    GilaMonster (11/17/2011)

    derekr 43208 (11/16/2011)

    GilaMonster (11/16/2011)

    derekr 43208 (11/16/2011)

    For instance: I need it to check the size, check the free space, if the free space > a certain % - it needs...

    November 17, 2011 at 7:56 am

    #1409217

  • RE: DBCC Shrinkfile

    Dev (11/16/2011)

    I don't want too much space in the log if it can be releases to the OS.

    Are you planning to share disk (that contain Log Files) with...

    November 16, 2011 at 11:22 pm

    #1408970

  • RE: DBCC Shrinkfile

    GilaMonster (11/16/2011)

    derekr 43208 (11/16/2011)

    For instance: I need it to check the size, check the free space, if the free space > a certain % - it needs to shrink the...

    November 16, 2011 at 11:08 pm

    #1408964

  • RE: DBCC Shrinkfile

    Ninja's_RGR'us (11/16/2011)

    Yes but that's a little pointless.

    If you have runaway jobs or queries bloating the logs you need to know about them. Then fix the query, then resize the...

    November 16, 2011 at 11:04 pm

    #1408962

  • RE: DBCC Shrinkfile

    Ninja's_RGR'us (11/16/2011)

    Get the log size, do the math, then run the command =>

    DECLARE @a INT

    SET @a =10000000

    DBCC SHRINKFILE(2, @a)

    How can I get this done...

    November 16, 2011 at 8:03 am

    #1408565

  • RE: DBCC Shrinkfile

    Dev (11/16/2011)

    It's possible with DBCC SHRINKDATABASE.

    DBCC SHRINKDATABASE

    ( database_name | database_id | 0

    [ , target_percent ]

    [...

    November 16, 2011 at 7:55 am

    #1408548

  • RE: Index Fragmentation

    GilaMonster (11/11/2011)

    Depends. The terminology around this varies. I've seen this called physical fragmentation, I've seen that term used for file system fragmentation.

    thanks

    November 11, 2011 at 2:21 am

    #1406127

  • RE: Index Fragmentation

    GilaMonster (11/10/2011)

    derekr 43208 (11/10/2011)

    GilaMonster (11/10/2011)

    derekr 43208 (11/9/2011)

    So when a NC index is created, its leaf pages match the order of the data pages

    No, no, no. Nothing whatsoever to do with...

    November 11, 2011 at 12:30 am

    #1406094

  • RE: Index Fragmentation

    GilaMonster (11/10/2011)

    derekr 43208 (11/10/2011)

    GilaMonster (11/10/2011)

    derekr 43208 (11/9/2011)

    So when a NC index is created, its leaf pages match the order of the data pages

    No, no, no. Nothing whatsoever to do with...

    November 11, 2011 at 12:27 am

    #1406093

Viewing 15 posts - 646 through 660 (of 757 total)