Forum Replies Created

Viewing 15 posts - 3,406 through 3,420 (of 49,552 total)

  • RE: indexes-non clustered

    Grant Fritchey (3/24/2016)

    Hugo Kornelis (3/23/2016)

    In almost 20 years of working with SQL Server, I have only once used an index hint in a production query, and that was after I...

    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 24, 2016 at 2:31 pm

    #1867628

  • RE: sql and stored procedure

    Why no temp tables? The normal solution would be to EXEC into the temp table, then query 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 24, 2016 at 10:57 am

    #1867520

  • RE: Are the posted questions getting worse?

    ChrisM@Work (3/24/2016)

    Grant Fritchey (3/24/2016)

    Steve Jones - SSC Editor (3/24/2016)

    WayneS (3/24/2016)

    ChrisM@Work (3/24/2016)

    Stage fright can hit anyone I suppose.

    Yes it does... even those that speak frequently. I know of a fellow...

    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 24, 2016 at 10:48 am

    #1867514

  • RE: NUMA

    A quick google search should answer the first and second at least.

    Why don't you have a read through the search results for the first and second, then once you understand...

    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 24, 2016 at 5:09 am

    #1867363

  • RE: Mutiple file groups

    helper_10 (3/19/2016)

    Multiple file groups in the same drive, Not So Much but If you can divide those file groups in multiple locations (Drives) there is huge positive impact 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 24, 2016 at 5:07 am

    #1867362

  • RE: Mutiple file groups

    Performance, probably not, but trying to keep 20TB in one filegroup is probably not a good idea for backup/restore reasons.

    Designing a filegroup layout for that is complicated though.

    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 24, 2016 at 5:06 am

    #1867361

  • RE: mirrored DB backup help please

    seanthomas2010 (3/24/2016)

    This is not working. 🙁

    You mean you don't like my answers in the other thread?

    Please stick to a single thread, otherwise people end up wasting their time (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

    March 24, 2016 at 5:05 am

    #1867360

  • RE: Multiple ndf file back up solution please

    Not a particularly good idea, as the restore process is more complicated when you do file and filegroup backups. You'll need to take log backups as well and restore those...

    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 24, 2016 at 4:49 am

    #1867356

  • RE: Can i schedule a sql trace through script and have data write to table

    No you can't. Writing directly to a table is a feature of the Profiler GUI (and is usually a bad idea, especially if writing to the instance being traced)

    Schedule your...

    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 24, 2016 at 4:06 am

    #1867342

  • RE: Multiple ndf file back up solution please

    When you back up a database, you back up the entire database. How the backup is written doesn't depend on the file/filegroup structure of the DB.

    By striping the backup (as...

    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 24, 2016 at 4:02 am

    #1867339

  • RE: mirrored DB backup help please

    Please don't post multiple questions for the same problem.

    No replies here. Replies to http://www.sqlservercentral.com/Forums/Topic1772009-24-1.aspx

    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 24, 2016 at 3:59 am

    #1867338

  • RE: Confuse about transaction log, truncation and UNDO management

    Um, the answer to that is exactly the statement that you said you understand.

    You cannot truncate log records which are still needed for something, no matter how many log backups...

    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 18, 2016 at 8:46 am

    #1866156

  • RE: Optimize SP

    Sergiy (3/17/2016)

    Can you name anything else?

    Statistics mostly, table variables don't have them. Lots of rows in a table variable can result in really bad row count estimates by the optimiser...

    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 18, 2016 at 2:52 am

    #1866071

  • RE: Confuse about transaction log, truncation and UNDO management

    szejiekoh (3/17/2016)

    Does it literally means that a truncate will happen after a logbackup (provided there is a checkpoint after the last backup) ,but , the truncation will only truncate up...

    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 18, 2016 at 2:49 am

    #1866070

  • RE: Confuse about transaction log, truncation and UNDO management

    szejiekoh (3/17/2016)

    But given that the checkpoint has run, there might be still uncommitted / active transactions inside the transaction log, can the log be truncated then (even if backup...

    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 18, 2016 at 2:48 am

    #1866069

Viewing 15 posts - 3,406 through 3,420 (of 49,552 total)