Forum Replies Created

Viewing 15 posts - 18,166 through 18,180 (of 49,552 total)

  • RE: How to convert all PK columns in database from numeric(12,0) to int

    That would be a huge amount of work. You would need to:

    Drop all indexes

    Drop all foreign keys

    Drop all primary keys

    Convert all columns in all tables, one at a time (ALTER...

    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

    June 9, 2012 at 3:21 pm

    #1499057

  • RE: tran log backup confused 2.5gb log file but 70gb log backup size

    Bulk-logged recovery is why.

    http://www.sqlservercentral.com/articles/Recovery+models/89664/

    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

    June 9, 2012 at 3:17 pm

    #1499056

  • RE: Shrinking Transaction Log the right way

    Please read through this - Managing Transaction Logs[/url]

    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

    June 9, 2012 at 3:16 pm

    #1499055

  • RE: DATABASE CRASHED-Urgent Help

    If you have every single file in the primary filegroup, you should be able to bring the DB online. Of course, any filegroups with missing files will be unavailable. If...

    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

    June 9, 2012 at 3:15 pm

    #1499054

  • RE: creating NON CLUSTERED INDEX on table

    http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

    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

    June 9, 2012 at 3:14 pm

    #1499053

  • RE: SQL server 2008 r2 program

    Just Management Studio? Or the SQL Server database engine as well?

    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

    June 9, 2012 at 7:29 am

    #1499013

  • RE: How to find out who has looged on to my machine yesterday

    You can check the default trace, it shows schema changes. Other than that, unless you had some auditing in place you're unlikely to find much out.

    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

    June 9, 2012 at 7:16 am

    #1499012

  • RE: Are the posted questions getting worse?

    Chad Crawford (6/8/2012)

    SQLRNNR (6/8/2012)

    As for the bluetooth - I think that would be far too unreliable for me. Unreliable because I intentionally leave my phone at the desk...

    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

    June 9, 2012 at 4:27 am

    #1499010

  • RE: sys.dm_io_virtual_file_stats - doesn't looks like it is cummulative

    sqldba_newbie (6/8/2012)

    GilaMonster (6/8/2012)

    Autoclose enabled?

    Database restored?

    DAtabase taken offline?

    Database detached and attached?

    Autoclose enabled? Not sure what this is

    The database setting autoclose.

    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

    June 8, 2012 at 5:03 pm

    #1498981

  • RE: sys.dm_io_virtual_file_stats - doesn't looks like it is cummulative

    Autoclose enabled?

    Database restored?

    DAtabase taken offline?

    Database detached and attached?

    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

    June 8, 2012 at 3:54 pm

    #1498965

  • RE: Zeroing out bad block?

    Then I would say take at least one more snap backup and proceed with caution (and frequent CheckDBs)

    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

    June 8, 2012 at 3:43 pm

    #1498961

  • RE: Zeroing out bad block?

    CheckDB comes back clean after doing so?

    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

    June 8, 2012 at 2:08 pm

    #1498933

  • RE: Are the posted questions getting worse?

    Anyone with leet XML skills want to lend a hand here? http://www.sqlservercentral.com/Forums/Topic1312818-391-1.aspx

    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

    June 8, 2012 at 12:06 pm

    #1498875

  • RE: Execution plan shows Number of executes 24

    Should have done more than that.... Might not have time til tomorrow to look again, but I'm sure that others here will help in the meantime.

    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

    June 8, 2012 at 11:22 am

    #1498863

  • RE: Are the posted questions getting worse?

    I've heard mutterings about using Kinect for that. With it's facial recognition it can lock the computer when you get up, unlock when you sit down.

    Would probably take a...

    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

    June 8, 2012 at 10:59 am

    #1498852

Viewing 15 posts - 18,166 through 18,180 (of 49,552 total)