Forum Replies Created

Viewing 15 posts - 6,631 through 6,645 (of 49,552 total)

  • RE: SOS - Backups fali error 23 redundancy check falis

    What's the exact command and exact error that you're getting?

    When did you last run CheckDB on that database?

    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 2, 2015 at 7:04 am

    #1774769

  • RE: trouble shoot

    jacksonandrew321 (2/2/2015)

    I do agree with both Gail and Grant, u should check for DBCC and to know more about corruption reasons click here[/url]

    Since that post is a thinly veiled...

    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 2, 2015 at 6:37 am

    #1774758

  • RE: Recovery Plans Selection

    Depends on a huge number of factors. There's no one best.

    You need to consider the RPO, the RTO, the hardware budget if applicable, the skills of the people who will...

    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 2, 2015 at 4:46 am

    #1774739

  • RE: trouble shoot

    Corruption, either disk or memory or some weird race condition perhaps.

    Follow Grant's advice, if it happens again consider contacting Microsoft's customer support.

    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 2, 2015 at 4:20 am

    #1774737

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

    In that case, since you have no clean backup, you're going to have to drop and recreate the table. If the data's important, you should be able to do 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

    February 2, 2015 at 4:09 am

    #1774736

  • RE: Sql Select query is not working on one table but the same is working on copy of the table

    What is the query waiting 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

    February 2, 2015 at 1:36 am

    #1774705

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

    Dell Dude (1/30/2015)

    Msg 608, Level 16, State 1, Line 1

    No catalog entry found for partition ID 72057594131185664 in database 8. The metadata is inconsistent. Run DBCC CHECKDB to check 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

    February 2, 2015 at 1:32 am

    #1774704

  • RE: most important DBCC commands?

    Help, my database is corrupt. Now what? [/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

    February 2, 2015 at 1:30 am

    #1774703

  • RE: SQL Database Backup into a .SQL File (Stored Procedure)

    Before you go that route, consider how such a file would be used.

    Management Studio dies with files over a few hundred MB, so if you script out (and that's what...

    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 2, 2015 at 1:27 am

    #1774702

  • RE: Anyone going to SQLBits XIV, ExCel London, 4th - 7th March 2015?

    Yup. There from the Thursday. Presenting on Thursday and Friday.

    I'm at SQL Sat Vienna the Saturday before Bits, in case you're going there too.

    Will also be at the Friday evening...

    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 2, 2015 at 1:25 am

    #1774701

  • RE: CASE vs ISNULL? Which is faster?

    Please don't post multiple threads for the same question.

    No further replies here please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1656650-3412-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

    February 2, 2015 at 1:20 am

    #1774699

  • RE: CASE vs ISNULL? Which is faster?

    Please don't post multiple threads for the same question.

    No further replies here please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1656650-3412-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

    February 2, 2015 at 1:20 am

    #1774698

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

    jarick 15608 (2/1/2015)

    How about storing all of the data in XML in a compressed binary string and using and using am image datatype to store it in. To read...

    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:25 pm

    #1774650

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

    jwiseh (1/31/2015)

    I remember the pain of working with a system where a developer had chosen the TIME data type to store the number of hours worked in a day....

    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:23 pm

    #1774649

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

    bdcoder (1/31/2015)

    Using MS SQL Server -- I'll be working on a project in the near future where we need to store latitude and longitude ( NO -- we do NOT...

    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:19 pm

    #1774648

Viewing 15 posts - 6,631 through 6,645 (of 49,552 total)