Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Jeff Moden - Tuesday, May 2, 2017 2:21 PM

    Do you know how to stand up a VM? 

    Yes. Hyper-V, VirtualBox, VMWare Player,...

    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

    May 3, 2017 at 2:46 pm

    #1941002

  • RE: Procedure Doing Only Select

    Rechana Rajan - Wednesday, May 3, 2017 4:58 AM

    GilaMonster - Tuesday, May 2, 2017 5:11 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

    May 3, 2017 at 6:48 am

    #1940878

  • RE: Procedure Doing Only Select

    Thom A - Tuesday, May 2, 2017 5:13 AM

    Rechana Rajan - Tuesday, May 2, 2017 4:59 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

    May 2, 2017 at 6:33 am

    #1940690

  • RE: Procedure Doing Only Select

    Rechana Rajan - Tuesday, May 2, 2017 4:59 AM

    The procedure have a parameter which is the where clause and the write occurs...

    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

    May 2, 2017 at 5:11 am

    #1940675

  • RE: Looking for examples

    the WHERE clause is used to filter out data. If you just need all the zip codes, in order, you just need

    SELECT ZipCode
    FROM Address
    ORDER...

    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

    May 2, 2017 at 3:21 am

    #1940659

  • RE: Procedure Doing Only Select

    Worktables, hashes (sorts, aggregation), spools, etc. There's plenty of reasons why SQL would write data (and it'll be to TempDB) during execution of a query

    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

    May 2, 2017 at 3:08 am

    #1940657

  • RE: SQL help - help me write the SQL stmt

    Can you show us what the full results from that sample data set should look like?
    At most two of each date in the columns?

    PIVOT may work, but...

    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

    May 1, 2017 at 3:21 pm

    #1940615

  • RE: Kill sleeping SPIDs

    Um..., ok. If you're testing that, you probably don't want the filter to only retrieve sessions that haven't done anything for two days, or it's going to be a very...

    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 28, 2017 at 6:38 am

    #1940363

  • RE: Kill sleeping SPIDs

    deanodiergaardt - Friday, April 28, 2017 6:00 AM

    Hi,

    I've written a query to loop through a all the sleeping SPIDs and kill 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

    April 28, 2017 at 6:20 am

    #1940353

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Friday, April 28, 2017 5:53 AM

    Thom A - Friday, April 28, 2017 2:32 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 28, 2017 at 6:18 am

    #1940352

  • RE: creating new partition files on table

    lkennedy76 - Thursday, April 27, 2017 8:38 AM

    GilaMonster - Thursday, April 27, 2017 8:14 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 27, 2017 at 3:07 pm

    #1940317

  • RE: creating new partition files on table

    lkennedy76 - Tuesday, April 25, 2017 8:28 AM

    Will I switch the inventory_deafault file group back to the inventory table?

    Huh? You don't switch...

    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 27, 2017 at 8:16 am

    #1940217

  • RE: creating new partition files on table

    lkennedy76 - Wednesday, April 26, 2017 9:25 AM

    They won't switch back into the partitioned table,

    ALTER TABLE SWITCH...

    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 27, 2017 at 8:14 am

    #1940215

  • RE: creating new partition files on table

    No. It has 2.9 billion rows (see the output of sys.dm_db_partiton_stats earlier)

    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 27, 2017 at 8:11 am

    #1940214

  • RE: SQL Server core usage

    tbh, I would recommend rather have 4 virtual servers, each with 16 cores and 1 instance of SQL Server 2012. You get far better seperation of resources (like memory) doing...

    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 27, 2017 at 8:11 am

    #1940213

Viewing 15 posts - 1,471 through 1,485 (of 49,552 total)