Forum Replies Created

Viewing 15 posts - 24,511 through 24,525 (of 49,552 total)

  • RE: very slow query

    SQLkiwi (8/2/2011)

    It is hard to imagine a plan where this type of query would be slow, even if the primary key is non-clustered, so I too look forward...

    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

    August 3, 2011 at 1:24 am

    #1362845

  • RE: couldn't kill a query as it is in roll back process..but it has been rolling back fro more than a day now

    Doesn't need a reboot. Just a restart of SQL. Stop, start.

    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

    August 2, 2011 at 4:16 pm

    #1362748

  • RE: couldn't kill a query as it is in roll back process..but it has been rolling back fro more than a day now

    Ninja's_RGR'us (8/2/2011)

    GilaMonster (8/2/2011)

    Restart SQL. I've seen it a few times, a restart fixes it.

    afraid to ask...

    and nothing else?

    Nothing that I've tried in the cases I've seen

    Couldn't it be that it's...

    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

    August 2, 2011 at 3:59 pm

    #1362735

  • RE: Backup gives error message System.Data.SqlClient.SqlError

    LOOKUP_BI-756009 (8/2/2011)

    Is there any other solution that I can try before restarting the service, as I have may more application database on this server ?

    You could wait, but last time...

    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

    August 2, 2011 at 3:56 pm

    #1362731

  • RE: Backup gives error message System.Data.SqlClient.SqlError

    Restart the SQL service.

    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

    August 2, 2011 at 3:43 pm

    #1362715

  • RE: couldn't kill a query as it is in roll back process..but it has been rolling back fro more than a day now

    Restart SQL. I've seen it a few times, a restart fixes it.

    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

    August 2, 2011 at 3:40 pm

    #1362712

  • RE: huge log backup after reorg

    frankie11 (8/2/2011)

    Statement 2 – “In full/bulk-logged recovery it takes a log backup to make portions of the log reusable”. - Will a log backup before shrink make portions of 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

    August 2, 2011 at 1:41 pm

    #1362570

  • RE: database size

    Ninja's_RGR'us (8/2/2011)

    GilaMonster (8/2/2011)

    chess.chess (8/2/2011)

    GilaMonster (8/2/2011)

    chess.chess (8/2/2011)

    I realize that the sizes vary but I am just trying to get an idea for the average for a large application .

    The point...

    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

    August 2, 2011 at 12:30 pm

    #1362486

  • RE: database size

    chess.chess (8/2/2011)

    GilaMonster (8/2/2011)

    chess.chess (8/2/2011)

    I realize that the sizes vary but I am just trying to get an idea for the average for a large application .

    The point we're trying...

    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

    August 2, 2011 at 12:22 pm

    #1362474

  • RE: database size

    chess.chess (8/2/2011)

    GilaMonster (8/2/2011)

    chess.chess (8/2/2011)

    I realize that the sizes vary but I am just trying to get an idea for the average for a large application .

    The point we're trying...

    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

    August 2, 2011 at 12:19 pm

    #1362470

  • RE: database size

    chess.chess (8/2/2011)

    I realize that the sizes vary but I am just trying to get an idea for the average for a large application .

    The point we're trying to make...

    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

    August 2, 2011 at 12:11 pm

    #1362453

  • RE: database size

    Ninja's_RGR'us (8/2/2011)

    Biggest table I have now is around 20M rows, 2.5GB.

    Biggest I've heard of was 100 000 000 000 rows (no idea of size or what it stored)

    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

    August 2, 2011 at 12:08 pm

    #1362446

  • RE: database size

    chess.chess (8/2/2011)

    Thanks . Just curious .

    ... how many tables and views would that be ?

    Between 10 and 100000 with possible outliers on either side.

    Seriously, there's no normal value for...

    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

    August 2, 2011 at 12:02 pm

    #1362439

  • RE: database size

    This is a classic 'It depends'. There's no normal values for database size, table count or row count.

    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

    August 2, 2011 at 12:01 pm

    #1362438

  • RE: Adding/Removing Columns

    Roger Sabin (8/2/2011)

    Let me make sure I have this.

    If I use ALTER TABLE to change the varchar size (e.g. varchar(20) to varchar(50)), SQL Server will not duplicate the table but...

    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

    August 2, 2011 at 12:00 pm

    #1362435

Viewing 15 posts - 24,511 through 24,525 (of 49,552 total)