Forum Replies Created

Viewing 15 posts - 106 through 120 (of 49,552 total)

  • RE: Using an ALIAS table name in a CASE statement

    CTE or subquery only, or use the expression instead of the alias
    Easiest, tbh, would be

    CASE datepart(month,DATEOFBIRTH)
    WHEN 1 THEN 'Yes'
    WHEN 2 THEN 'No'
    ELSE...

    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, 2018 at 7:17 am

    #1999993

  • RE: Unused space; shrink or not shrink

    Don't shrink. The free space will be used for future inserts, future new tables, etc.

    Only time I'd shrink is if more than half of the DB is empty...

    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, 2018 at 6:44 am

    #1999989

  • RE: What does your backup process look like?

    Mike Scalise - Wednesday, August 1, 2018 6:57 PM

    --or if there's a way to have my cake and eat it too.

    Backup WITH...

    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, 2018 at 2:44 am

    #1999972

  • RE: What does your backup process look like?

    My thoughts are as I posted earlier.

    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 1, 2018 at 2:56 pm

    #1999951

  • RE: What does your backup process look like?

    CheckDB before backup. No point in taking the backup if the DB is damaged or hardware is failing

    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 1, 2018 at 1:57 pm

    #1999946

  • RE: Converting a COALESCE statement to varchar

    meichmann - Wednesday, August 1, 2018 5:58 AM

    Drew,
         Thank you for the information.  I didn't know that there was a precedence...

    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 1, 2018 at 6:07 am

    #1999859

  • RE: Question: performance loss on update statistics after upgrade from SQL Server 2012

    Probably related to the new cardinality estimator.

    Identify the queries that have degraded in performance, tune them or add the hint to force the legacy CE.

    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 1, 2018 at 5:50 am

    #1999852

  • RE: temp db files best prectice sql 2017

    As Paul said, don't ever configure 1 file for 1 core by default. Read that blog post, it's still pretty much what's recommended.

    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 1, 2018 at 5:31 am

    #1999848

  • RE: SQL Server detected a logical consistency-based I/O error

    If it's a demo environment, can you get a copy of the DB from elsewhere? Or recreate it from source?
    You can repair, but the problem is that it  doesn't...

    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

    July 31, 2018 at 3:53 pm

    #1999799

  • RE: What does your backup process look like?

    Corruption is (generally) the IO subsystem mangling the data file.
    It's not going to then go and write a structurally correct log record that describes that corruption that can then...

    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

    July 31, 2018 at 2:30 pm

    #1999783

  • RE: repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB

    Scott Coleman - Tuesday, July 31, 2018 2:02 PM

    If it is an index page, and you know what index, you might be...

    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

    July 31, 2018 at 2:19 pm

    #1999776

  • RE: repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB

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

    No replies here please. replies to  https://www.sqlservercentral.com/Forums/1979641/SQL-Server-detected-a-logical-consistencybased-IO-error

    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

    July 31, 2018 at 1:53 pm

    #1999769

  • RE: SQL Server detected a logical consistency-based I/O error

    Got a clean backup? (backup before the corruption occurred)?

    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

    July 31, 2018 at 1:52 pm

    #1999768

  • RE: SQL Server detected a logical consistency-based I/O error

    Is the database with an ID of 9 (according to sys.databases) named SL_AppDemo?

    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

    July 31, 2018 at 1:25 pm

    #1999762

  • RE: What does your backup process look like?

    Mike Scalise - Tuesday, July 31, 2018 12:40 PM

    Gail,

    Thank you. I've taken into account all of the advice. Would you mind taking...

    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

    July 31, 2018 at 1:21 pm

    #1999761

Viewing 15 posts - 106 through 120 (of 49,552 total)