Forum Replies Created

Viewing 15 posts - 1,531 through 1,545 (of 49,552 total)

  • RE: creating new partition files on table

    Cool. Will reply in detail over coffee tomorrow morning (~12 hours from now).

    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

    April 19, 2017 at 12:46 pm

    #1938921

  • RE: creating new partition files on table

    lkennedy76 - Wednesday, April 19, 2017 9:13 AM

    Got it Gail. I created new files and filgroups, created tables for each month...

    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

    April 19, 2017 at 12:24 pm

    #1938911

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Wednesday, April 19, 2017 8:27 AM

    Brandie Tarvin - Wednesday, April 19, 2017 7:40 AM

    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

    April 19, 2017 at 12:22 pm

    #1938910

  • RE: tempdb curiosity

    Jeff Moden - Wednesday, April 19, 2017 8:38 AM

    While I certainly agree that TempDB should be sized for the anticipated usage,...

    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

    April 19, 2017 at 12:22 pm

    #1938909

  • RE: creating new partition files on table

    No.

    I mean, you can do that, but you're looking at a couple of days for each split, and to get that table back into the correct partitions, you...

    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

    April 19, 2017 at 8:18 am

    #1938832

  • RE: creating new partition files on table

    ??? You posted the alter function and alter schema commands in the first post. They're correct, but the split will run for ages, because it's moving a whole pile 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

    April 19, 2017 at 7:56 am

    #1938820

  • RE: creating new partition files on table

    In object explorer, expand out the database -> storage - > partition functions. right click the function -> script. Do the same with the partition scheme

    That query should have returned...

    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

    April 19, 2017 at 7:27 am

    #1938800

  • RE: creating new partition files on table

    Well that partially answers the question. At least 2.1 billion rows need to move to the new partition. :crying:

    This is  NOT going to be a quick process,...

    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

    April 19, 2017 at 6:58 am

    #1938784

  • RE: tempdb curiosity

    I dug into this a while back while testing how to recover from a crashed instance.

    If the TempDB files are there, they're reset to the starting size 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

    April 19, 2017 at 4:51 am

    #1938761

  • RE: Deadlocks on Clustered Index

    Ken McKelvey - Wednesday, April 19, 2017 4:18 AM

    A bit a long shot, but you could try creating an unique constraint 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

    April 19, 2017 at 4:46 am

    #1938759

  • RE: Backup (sort of) when no backup is available

    a_ud - Wednesday, April 19, 2017 3:44 AM

    One last question:  being this a SQL script, if I run this .sql on 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

    April 19, 2017 at 4:15 am

    #1938752

  • RE: tempdb curiosity

    andrew gothard - Wednesday, April 19, 2017 2:32 AM

    Also, with a tempdb anywhere near that size, I would make sure that Instant...

    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

    April 19, 2017 at 3:16 am

    #1938740

  • RE: Deadlocks on Clustered Index

    Add a hint to the UPDATE statement WITH (XLOCK)
    That means that the update goes for an exclusive lock straight off, not update lock first (which is done for performance...

    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

    April 19, 2017 at 3:15 am

    #1938739

  • RE: Backup (sort of) when no backup is available

    In SSMS object explorer, right click the database -> tasks -> generate scripts. That will let you script tables, views, procedures, etc.

    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

    April 19, 2017 at 3:12 am

    #1938737

  • RE: tempdb curiosity

    Set it in the GUI (or via ALTER DATABASE), then on the next restart TempDB will start with those values. Check autogrow settings as well, should be the same 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

    April 19, 2017 at 1:06 am

    #1938726

Viewing 15 posts - 1,531 through 1,545 (of 49,552 total)