Forum Replies Created

Viewing 15 posts - 10,081 through 10,095 (of 49,552 total)

  • RE: Faster way to move all the data from one database to another ( without backups)?

    ALTER DATABASE <database name>

    MODIFY FILE (Name = <file name>, OFFLINE);

    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 7, 2014 at 1:04 pm

    #1687208

  • RE: Faster way to move all the data from one database to another ( without backups)?

    No, no, no, no, don't do that.

    What's the exact state_desc of the file? (sys.database_files)

    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 7, 2014 at 12:02 pm

    #1687188

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (2/7/2014)

    I don't think that 30 seconds interval changes anything so far as altering data is concerned- nothing can be written to database pages on disc for which...

    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 7, 2014 at 11:56 am

    #1687185

  • RE: Faster way to move all the data from one database to another ( without backups)?

    And if you try to drop the filegroup? An error that it's not 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

    February 7, 2014 at 11:53 am

    #1687183

  • RE: Faster way to move all the data from one database to another ( without backups)?

    ricardo_chicas (2/7/2014)

    I would love to drop that filegroup but on the current state everything I have tried returns an errors saying that it is not possible because the filegroup 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

    February 7, 2014 at 11:15 am

    #1687163

  • RE: Faster way to move all the data from one database to another ( without backups)?

    Can you not just drop the filegroup? It should work, though may need a couple other steps first.

    What's the corruption-related errors? Might be an option that doesn't involve recreating the...

    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 7, 2014 at 10:55 am

    #1687151

  • RE: memory issue: manual memory settings

    JudithK (2/7/2014)

    Just in case the obvious has been missed... The max server memory setting won't take effect until you restart the sql server instance. 🙂

    The Max server memory setting takes...

    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 7, 2014 at 10:38 am

    #1687145

  • RE: Are the posted questions getting worse?

    jasona.work (2/7/2014)

    ChrisM@Work (2/7/2014)

    Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?

    /Using my best George Takei imitation

    Ooh My...

    😉

    At least he's not imagining us wandering...

    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 7, 2014 at 7:58 am

    #1687069

  • RE: Are the posted questions getting worse?

    jasona.work (2/7/2014)

    Is it in any way, shape, or form, possible to have a functional SQL database, with its log file in an offline state. Could you somehow 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 7, 2014 at 7:55 am

    #1687067

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (2/7/2014)

    GilaMonster (2/7/2014)

    Koen Verbeeck (2/7/2014)

    Ed Wagner (2/7/2014)

    That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because we...

    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 7, 2014 at 7:19 am

    #1687040

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (2/7/2014)

    Ed Wagner (2/7/2014)

    That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because we enjoy doing it,...

    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 7, 2014 at 7:12 am

    #1687030

  • RE: Memory related questions?

    SQL will use as much memory as it is allowed to. By setting max server memory to 8GB, you've told it that it may use 8GB and hence it 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 7, 2014 at 6:24 am

    #1687006

  • RE: Memory related questions?

    Target and total memory are measured in KB. 8GB = 8*1024 MB = 8*1024*1024 KB = 8 388 608KB. So SQL is using exactly the amount of memory you told it 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

    February 7, 2014 at 5:35 am

    #1686985

  • RE: SQL SERVER 2008 R2 transaction log shipping

    sanku.raghuram (2/6/2014)

    Thanks sharing the details. I have one more question. I see that I have set the restore job to happen 2 min dalay.

    so when my job runs first it...

    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 6, 2014 at 7:52 am

    #1686610

  • RE: Number of times a function is accessed.

    ben.brugman (2/6/2014)

    To see how efficient code is working I want to count how many times a function is accessed.

    Depends on the execution plan. The rule that functions cannot have side...

    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 6, 2014 at 7:46 am

    #1686603

Viewing 15 posts - 10,081 through 10,095 (of 49,552 total)