Forum Replies Created

Viewing 15 posts - 6,646 through 6,660 (of 49,552 total)

  • RE: The Number that shouldn't be a number

    sparky-407434 (1/31/2015)

    On the plus side, storing telephone number as int uses less storage than a varchar. Ok you won't need to use any numeric functions on it, but you probably...

    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

    February 1, 2015 at 12:16 pm

    #1774647

  • RE: Is the DELETION of a SQL Server 2008R2 database logged anwhere?

    Bhushan Kulkarni (1/28/2015)

    you can check the log file of master database. U can use

    Select [Transaction SID],* from ::fn_dblog(null,null) where [Transaction Name] ='dbdestroy'

    Master is in simple recovery model, meaning 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

    January 30, 2015 at 11:17 am

    #1774429

  • RE: Is the DELETION of a SQL Server 2008R2 database logged anwhere?

    Siberian Khatru (1/28/2015)

    Wondering if it's possible to make the default bigger (longer)

    Nope.

    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

    January 30, 2015 at 11:15 am

    #1774426

  • RE: Clustered index not in Sys.Partions (The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption)

    Database 19 will probably be the hidden snapshot that CheckDB creates.

    To be honest, I suspect dropping the table will be about the only solution here, although I'd like to see...

    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

    January 30, 2015 at 10:43 am

    #1774414

  • RE: Help with query - Find recovered customers

    Nasty way to store the date. Can you not store the year and the month separately? Or as a proper Datetime set to the first day?

    Either would make this easier.

    This...

    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

    January 30, 2015 at 7:29 am

    #1774345

  • RE: Difference between Truncateonly and NoTruncate

    The statement is technically correct. Shrinkfile on a log file does not move information around in the log when truncateonly is specified. The problem is that it's easy to assume...

    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

    January 30, 2015 at 6:05 am

    #1774310

  • RE: Difference between Truncateonly and NoTruncate

    tom.pester (1/30/2015)

    Hi GilaMonster

    I'm researching this and I think TuncateOnly is useful on log files as well

    "The TRUNCATEONLY option does not move information in the log, but does remove inactive VLFs...

    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

    January 30, 2015 at 3:12 am

    #1774282

  • RE: Backup to clear the transaction log

    rob.lewis 86087 (1/30/2015)

    If you have a 20gb transaction log file in simple a recovery model

    A full back up is run

    A check point is made

    The transaction log off the back of...

    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

    January 30, 2015 at 2:25 am

    #1774272

  • RE: Which of these indexes should be deleted?

    sm_iransoftware (1/30/2015)

    Because I read somewhere , PK and Clustered index, can be separate (These two do not necessarily Be one thing)

    They can be, yes.

    And it's better that clustered index...

    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

    January 30, 2015 at 2:16 am

    #1774268

  • RE: What does 2 periods after DB name mean?

    Please note: 7 year old (answered) thread.

    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

    January 30, 2015 at 1:51 am

    #1774263

  • RE: Clustered index not in Sys.Partions (The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption)

    If the metadata is corrupt, you're not going to be able to drop the index, no matter what commands you try.

    Before trying any more shotgun approaches...

    Do you have a backup...

    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

    January 30, 2015 at 1:49 am

    #1774262

  • RE: most important DBCC commands?

    None.

    Nightly may to be too frequent for integrity checks, unless you only keep your backups for 1 day. It's certainly not something that has to be run every day.

    As 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

    January 30, 2015 at 1:39 am

    #1774261

  • RE: Where do senior SQL DBAs land finally?

    Sean Lange (1/29/2015)

    Alan.B (1/29/2015)

    I am certainly not anywhere at the same DBA skill level as say Jeff, Gail or Sean...

    Gosh I am humbled to be grouped with those two in...

    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

    January 30, 2015 at 1:36 am

    #1774259

  • RE: Which of these indexes should be deleted?

    sm_iransoftware (1/29/2015)

    I run this query on my database.

    Most of the result are : PK_ ... ?

    Those are probably the indexes enforcing the primary keys.

    What do I do now?

    change cluster? delete...

    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

    January 30, 2015 at 1:33 am

    #1774258

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/29/2015)

    Jeff Moden (1/29/2015)

    GilaMonster (1/29/2015)

    Brandie Tarvin (1/29/2015)

    GilaMonster (1/29/2015)

    Brandie Tarvin (1/29/2015)

    Here's one for everyone. Does anyone have an environment where Enterprise is the production edition and Standard is the Dev...

    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

    January 29, 2015 at 8:52 am

    #1774040

Viewing 15 posts - 6,646 through 6,660 (of 49,552 total)