Forum Replies Created

Viewing 15 posts - 1,456 through 1,470 (of 49,552 total)

  • RE: Downgrading database from SQL Server 2016 to SQL Server 2012

    SSIS and bcp/bulk insert should be about the same speed, and faster than lots and lots of INSERT INTO statements, as they have the bulk-loading optimisations.

    175GB isn't that...

    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

    May 10, 2017 at 8:36 am

    #1942021

  • RE: Cannot create a row of size 8208 which is greater than the allowable maximum row size of 8060.

    Can you post the table definition (all of it)?
    Do you have either of the ALLOW_SNAPSHOT_ISOLATION or READ_COMMITTED_SNAPSHOT_ISOLATION database settings on?

    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

    May 10, 2017 at 7:21 am

    #1941989

  • RE: Downgrading database from SQL Server 2016 to SQL Server 2012

    Don't script out the data. Script out the database structure, bcp (or SSIS) for the data.

    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

    May 10, 2017 at 7:10 am

    #1941987

  • RE: Choose the result NOT in a JOIN-query

    larsp777se - Monday, May 8, 2017 11:51 PM

    GilaMonster - Sunday, May 7, 2017 2:44 PM

    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

    May 9, 2017 at 2:21 pm

    #1941898

  • RE: Index_ID of the PK in In-Memory-Tables

    Query returns 2 rows on SQL 2016 SP1

    Plus, the title for the question is misleading. Afaik, there's no guarantee that if there are multiple indexes created on...

    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

    May 8, 2017 at 5:36 am

    #1941559

  • RE: Choose the result NOT in a JOIN-query

    WHERE Registrations.CourseId NOT IN (
    SELECT Registrations.StudentId

    Is that ever going to work?

    That's like saying "Give me all the employees...

    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

    May 7, 2017 at 2:44 pm

    #1941490

  • RE: Choose the result NOT in a JOIN-query

    larsp777se - Sunday, May 7, 2017 2:21 AM

    That gives me all courses that student with ID = 3 doesn't attend. But since...

    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

    May 7, 2017 at 5:50 am

    #1941464

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Friday, May 5, 2017 7:41 AM

    question that I'd appreciate everyone's input on, but particularly Mr. Moden's, since it's his fault,...

    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

    May 5, 2017 at 8:42 am

    #1941325

  • RE: How to convert string to "data type" ?

    Seriously, avoid this kind of design. It smells like an EAV table, and those are so hard to work with and perform terribly. I've seen them far too often, and...

    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

    May 5, 2017 at 7:55 am

    #1941307

  • RE: Why would SQL throw a Severity 016 alert?? following a successful db restore?

    Use the GUI, script out the command instead of running it, cancel the gui.

    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

    May 5, 2017 at 7:46 am

    #1941302

  • RE: Why would SQL throw a Severity 016 alert?? following a successful db restore?

    What's the exact command that you're running for the restore?

    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

    May 5, 2017 at 7:07 am

    #1941277

  • RE: Why can't I put database in READ_ONLY using SQLCMD from a remote Server?

    To explain...

    The NO_WAIT option on the ALTER DATABASE means that if the exclusive DB lock cannot be obtained immediately, the command should abort, not wait to try and...

    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

    May 5, 2017 at 7:04 am

    #1941273

  • RE: Query Completed with Errors but no error message

    peter.adams 60541 - Friday, May 5, 2017 2:14 AM

    It's probably the length of the script.

    Please note: 5 year old 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

    May 5, 2017 at 3:27 am

    #1941217

  • RE: How to build a field name in a select statement

    anthony.green - Friday, May 5, 2017 2:52 AM

    If your worried about SQL Injection, you could have a look at Gail's "catch all"...

    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

    May 5, 2017 at 3:26 am

    #1941216

  • RE: Choose the result NOT in a JOIN-query

    Roughly:

    SELECT whatever you need FROM Courses WHERE CourseID NOT IN (Select the courseIDs from Registrations for that student)

    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

    May 4, 2017 at 4:11 pm

    #1941174

Viewing 15 posts - 1,456 through 1,470 (of 49,552 total)