Forum Replies Created

Viewing 15 posts - 19,411 through 19,425 (of 49,552 total)

  • RE: Identity column Problem

    dwain.c (4/2/2012)

    The window function was causing an ORDER BY without using that clause explictly. Granted it is kind of contrived. But in some cases it does seem to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 3, 2012 at 1:25 am

    #1468029

  • RE: Can't Restore Differential Backup

    dpollard 96305 (4/2/2012)

    The results were not what I was expecting. It seems like the Backup Type is incorrect. (See Below)

    I would expect the initial backup to be Full (assuming...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 3, 2012 at 1:23 am

    #1468028

  • RE: DBCC shrinkfile while log shipping implemented

    Don't change the recovery model permanently and check that the risks of bulk logged are acceptable before you do so.

    If they are, switch to bulk logged before the index rebuilds...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 2:43 pm

    #1467906

  • RE: Identity column Problem

    sqlserver8650 (4/2/2012)

    Please give some suggestions how to reset the id column

    There's no resetting needed. The results are not in order because you have not specified and order by clause...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 2:42 pm

    #1467905

  • RE: DBCC shrinkfile while log shipping implemented

    soulesidibe2011 (4/2/2012)

    the problem is the log file size , i dont have enough space available for 20 or 25 gb because my log is always around 1GB. i can't leave...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 1:24 pm

    #1467851

  • RE: Identity column Problem

    sqlserver8650 (4/2/2012)

    How can I reslove that problem

    With an ORDER BY clause on your select query.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 1:21 pm

    #1467850

  • RE: Are the posted questions getting worse?

    Evil Kraig F (3/30/2012)

    GilaMonster (3/30/2012)

    I read the end of that and I am not getting involved...

    Initial gut feel - improper transaction management (leaves transactions open) combined with connection pooling. Connection...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 1:17 pm

    #1467842

  • RE: store large live SQLS erver databases

    SQLKnowItAll (4/2/2012)

    Doe it still hold true that on 2008 (not r2), backup compression can only be initiated on Enterprise edition and restored to any edition?

    Yes.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 1:14 pm

    #1467840

  • RE: DBCC shrinkfile while log shipping implemented

    Don't shrink, it won't help with log backup sizes (and may make them larger as the shrink has to be logged, backed up and copied) and a large transaction log...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 1:10 pm

    #1467835

  • RE: store large live SQLS erver databases

    SQLKnowItAll (4/2/2012)

    However, enabling backup compression on top of data compression will not help much (since the data itself is already compressed and does not leave much to be compressed on...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 1:09 pm

    #1467833

  • RE: store large live SQLS erver databases

    Lynn Pettis (4/2/2012)

    It was my understanding that the compressed data was backed up as is, and by using page or row compression you would not be able to restore the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 1:00 pm

    #1467825

  • RE: rebuild index with -2

    You won't be able to find what it was running from SQL, all that SQL can tell you is the locks held. That might provide a hint as to where...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 9:03 am

    #1467670

  • RE: 70-461 - SQL Server 2012 Querying a Datbase

    Ells (4/2/2012)

    There also appears to be a slight time lag in getting the cert track going. Very few books available and learning providers muttering that courses may be a little...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 5:54 am

    #1467577

  • RE: How to SpeedUp Queries

    SqlSpider... (4/2/2012)

    Will you please explain me the further steps to Proceed..

    I did. In the post you quoted.

    p.s. I've never seen or heard of code that confidential. Data, sure. Code is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 5:17 am

    #1467570

  • RE: Reclaim Transaction Log Space

    No way to tell. It's a function of IO throughput, CPU, data size.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 2, 2012 at 5:05 am

    #1467562

Viewing 15 posts - 19,411 through 19,425 (of 49,552 total)