Forum Replies Created

Viewing 15 posts - 9,811 through 9,825 (of 49,552 total)

  • RE: moving filegroups/physical files from one database to another

    yurdik (3/5/2014)

    So... i have to move all the data over the partitioned table in production database?

    Yes

    What would you do ?

    SSIS, bcp or T-SQL scripts to transfer the data over. Probably...

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

    #1694244

  • RE: Query of 100 mil rows with multiple parameters

    ChrisM@Work (3/5/2014)

    If I script out the nc index containing the cluster key as an include column from the code I posted above, the cluster key column still shows in...

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

    #1694242

  • RE: Help - How to get a DB out of (...Restoring) state

    Edvard Korsbæk (3/5/2014)

    Next step was, that he used 'Tivoli' to restore from the old DB to the new db - And that went wrong. It was the old db 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

    March 5, 2014 at 5:34 am

    #1694237

  • RE: moving filegroups/physical files from one database to another

    Files/filegroups cannot be moved from one database to another.

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

    #1694235

  • RE: Query of 100 mil rows with multiple parameters

    ChrisM@Work (3/5/2014)

    GilaMonster (3/5/2014)

    A column cannot be present in an index twice.

    Yes I know but...

    Not 'cannot be specified twice', actual 'cannot be present twice', so precluding SQL putting a column...

    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 5, 2014 at 4:23 am

    #1694227

  • RE: Help - How to get a DB out of (...Restoring) state

    That's not very useful 🙁

    A DB won't go into the restoring state by itself, someone has to run a command to do so.

    RESTORING or RECOVERING (important question)

    Error log, from Object...

    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 5, 2014 at 4:20 am

    #1694225

  • RE: Help - How to get a DB out of (...Restoring) state

    What was the backup command which you ran? What options did you specify?

    RESTORING or RECOVERING?

    Any entries in the SQL error log relating to this DB from about the time 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

    March 5, 2014 at 4:12 am

    #1694219

  • RE: Query of 100 mil rows with multiple parameters

    ChrisM@Work (3/5/2014)

    - The size stats of the two ordinary indexes is virtually the same.

    Exactly.

    A column cannot be present in an index twice. If a column is explicitly specified as part...

    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 5, 2014 at 4:07 am

    #1694218

  • RE: Query of 100 mil rows with multiple parameters

    CREATE TABLE ReallyStupidTable (

    ID CHAR(100),

    OtherID INT

    )

    GO

    CREATE UNIQUE CLUSTERED INDEX idx_Silly ON ReallyStupidTable (ID)

    GO

    INSERT INTO ReallyStupidTable (ID, OtherID)

    SELECT ANumber, ANumber FROM (

    SELECT TOP (5000000) ROW_NUMBER() OVER (ORDER BY...

    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 5, 2014 at 3:42 am

    #1694214

  • RE: Reboot during large offline clustered index rebuild

    adlan (3/5/2014)

    With the database in recovering state, would all of the log backups have been needed to allow SQL to roll back the index?

    No. Since the transaction (the index rebuild)...

    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 5, 2014 at 3:41 am

    #1694213

  • RE: Query of 100 mil rows with multiple parameters

    ChrisM@Work (3/5/2014)

    "Given that, why is an index which explicitly and implicitly includes a GUID going to be any larger than an index which only implicitly includes the GUID?"

    Why do 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

    March 5, 2014 at 3:30 am

    #1694209

  • RE: Reset memory cache for query tuning?

    My preference is to run queries/procs I'm testing multiple times and ignore the durations/IOs of the first result, rather than clearing plan and data cache after every single execution.

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

    #1694204

  • RE: Query of 100 mil rows with multiple parameters

    ChrisM@Work (3/5/2014)

    If a multi-column clustered index includes a GUID, a nonclustered index which incorporates that same column either as a key or include column is going to be significantly...

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

    #1694201

  • RE: Reboot during large offline clustered index rebuild

    adlan (3/5/2014)

    1. If people think that this was likely to have caused corruption.

    No.

    2. If the offline index would have come back on line any sooner by rebooting the server.

    No, exactly...

    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 5, 2014 at 3:07 am

    #1694199

  • RE: How to shrink log in 2008 r2? URGENT!!!!!!

    Jeff Moden (3/4/2014)

    Almost forgot. The log file won't shrink past the last VLF currently in use. It is sometimes necessary to first take a backup of the database...

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

    #1694172

Viewing 15 posts - 9,811 through 9,825 (of 49,552 total)