Forum Replies Created

Viewing 15 posts - 1,681 through 1,695 (of 49,552 total)

  • RE: Puzzling INSERT to itself

    Eliyahu - Wednesday, March 8, 2017 6:18 AM

    Is SSMS that smart to add an INSERT to the CREATE INDEX?

    No. SSMS is...

    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

    March 8, 2017 at 7:00 am

    #1932287

  • RE: Puzzling INSERT to itself

    Eliyahu - Wednesday, March 8, 2017 5:33 AM

    Thanks, maybe it indeed didn't fail.
    Can you please elaborate in short what could have happened?...

    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

    March 8, 2017 at 5:45 am

    #1932261

  • RE: Puzzling INSERT to itself

    Looks like the command behind an index rebuild (but that wouldn't fail due to a key violation)

    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

    March 8, 2017 at 5:18 am

    #1932255

  • RE: Whitespace in 3-part name ignored???

    SQL's whitespace behaviour is weird in general.

    This is valid and works:

    SELECT*FROM master

    .     sys  .

    objects ;

    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

    March 8, 2017 at 2:51 am

    #1932233

  • RE: Data getting deleted automatically

    vipinmittalmca - Tuesday, March 7, 2017 10:11 PM

    Sharon i am also facing the same problem in the same manner. 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

    March 8, 2017 at 12:19 am

    #1932218

  • RE: How to overcome the identity column "jump 1000" issue

    Jeff Moden - Tuesday, March 7, 2017 1:00 PM

    Yep.  I get that.  Tell me what that constraint should be for 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

    March 8, 2017 at 12:16 am

    #1932217

  • RE: Where is the information stored regarding the last full backup?

    It's in the database header pages, and it's not accessible.

    Deleting info from MSDB and still being able to take a differential backup should not be a surprise. 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

    March 7, 2017 at 4:42 am

    #1932010

  • RE: Where is the information stored regarding the last full backup?

    MSDB just contains the history about what backups were taken of what databases when. All databases know whether they've had a full backup, what full backup the diffs belong to...

    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

    March 7, 2017 at 3:32 am

    #1931997

  • RE: How to overcome the identity column "jump 1000" issue

    Raymond van Laake - Tuesday, March 7, 2017 2:27 AM

    For me it matters that there are gaps.... in our setup the identity...

    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

    March 7, 2017 at 2:34 am

    #1931990

  • RE: Please explain difference between these terms

    johnwalker10 - Monday, March 6, 2017 10:26 PM

    Windows authentication must be used when working in an Intranet type of an environment.

    SQL Server...

    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

    March 7, 2017 at 12:31 am

    #1931984

  • RE: How to overcome the identity column "jump 1000" issue

    Jeff Moden - Monday, March 6, 2017 9:12 PM

    I have to challenge that advice, ol' friend.  What "natural" key would you use...

    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

    March 7, 2017 at 12:31 am

    #1931983

  • RE: Are the posted questions getting worse?

    jasona.work - Monday, March 6, 2017 12:05 PM

    A bigger problem with this math problem is that you're apparently presuming instantaneous acceleration...

    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

    March 6, 2017 at 1:09 pm

    #1931919

  • RE: All Columns as Included

    Matt Miller (#4) - Monday, March 6, 2017 12:41 PM

    it's not even possible:  the stated limit is 16 columns max or 900...

    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

    March 6, 2017 at 1:07 pm

    #1931918

  • RE: checkdb "Multiple IAM pages for object"

    TheSQLGuru - Monday, March 6, 2017 7:35 AM

    Didn't Gail tell you to drop and recreate the empty tables?

    Yup, because rebuild can...

    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

    March 6, 2017 at 7:40 am

    #1931797

  • RE: checkdb "Multiple IAM pages for object"

    DBCC CheckAlloc is probably what you need to pick those up without a full checkDB.

    Do you really have over 9000 files in that database?

    Index rebuild won'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

    March 6, 2017 at 6:35 am

    #1931773

Viewing 15 posts - 1,681 through 1,695 (of 49,552 total)