Forum Replies Created

Viewing 15 posts - 3,436 through 3,450 (of 49,552 total)

  • RE: Compilations/sec to Batches/sec

    Casper101 (3/16/2016)

    I am almost certain it is not because of new queries because 99% of the code is in existing stored procs being called over and over again.

    I 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

    March 16, 2016 at 4:09 am

    #1865538

  • RE: SQL Server on Linux

    Felipe Maurer (3/15/2016)

    I think many shops are seeing this as a cost reduction alternative. Windows licenses can be a significant part of the TCO.

    Fine if the company already has Linus...

    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 16, 2016 at 3:46 am

    #1865531

  • RE: Is it OK to create this function?

    Can you create it? Yes.

    Is it a good idea? In terms of performance, no (though on smaller resultsets the function overhead probably won't be noticeable)

    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 16, 2016 at 3:42 am

    #1865530

  • RE: Replicas, indexes and different SQL versions

    What exactly do you mean by 'replicas'?

    Availability Groups secondary replicas?

    Transactional replication subscribers?

    Database mirroring secondary?

    Something else?

    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 16, 2016 at 3:41 am

    #1865529

  • RE: Crash dump & TMP files in Program Files (x86)\Microsoft SQL Server\110\Shared\ErrorDumps

    If they're stack dumps, then they're written out when SQL encounters fatal errors (like invalid memory addresses) or some forms of severe corruption. Either way, repeated stack dumps suggest something...

    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 15, 2016 at 10:33 am

    #1865335

  • RE: sys.dm_db_index_usage_stats user_updates higher for a non-clustered index than the PK

    Stats are reset when the index is rebuilt.

    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 15, 2016 at 8:47 am

    #1865265

  • RE: The Data Driven Event

    Gary Varga (3/8/2016)

    I have no hope of making that. 6pm local time on the day my wife is in for knee surgery. Where was the call Redmond?

    I'll look forward to...

    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 15, 2016 at 8:43 am

    #1865263

  • RE: SQL Server on Linux

    jasona.work (3/15/2016)

    he was of the opinion that MS would be releasing a stripped down, over-priced, you want all the features buy Windows version of SQL.

    I don't understand why people would...

    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 15, 2016 at 8:35 am

    #1865261

  • RE: SQL Server on Linux

    ZZartin (3/15/2016)

    Interesting, so is this a move to try to take market share from MySQL?

    Oracle I'd imagine, more than MySQL, especially if you look at their 'free licenses...

    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 15, 2016 at 8:33 am

    #1865259

  • RE: Are the posted questions getting worse?

    yb751 (3/15/2016)

    GilaMonster (3/15/2016)

    A sig that claims an MCSA and can't use SUM?

    You caught that too...makes you wonder if people are using other people's accounts. But why?

    Probably more like boot...

    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 15, 2016 at 8:25 am

    #1865257

  • RE: Are the posted questions getting worse?

    A sig that claims an MCSA and can't use SUM?

    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 15, 2016 at 8:19 am

    #1865254

  • RE: Crash dump & TMP files in Program Files (x86)\Microsoft SQL Server\110\Shared\ErrorDumps

    Make sure the server is patched to the latest version, and if you're still having stack sumps (which usually indicate fatal errors or severe database corruption), open a case with...

    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 15, 2016 at 8:12 am

    #1865245

  • RE: Add two columns to make one total

    You don't need ISNULL.

    Why are you grouping by the things you want to add? Group By should be what you want the totals summed by. If you just want 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

    March 15, 2016 at 8:07 am

    #1865242

  • RE: How to add totals by group

    How about you give us one query, not ~200 lines of code, along with create table statements and some sample data?

    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 15, 2016 at 8:03 am

    #1865238

  • RE: Looking for a Query Statment

    To remove the negation, remove the NOT. So IN.

    But Phil's code does exactly what you asked. It would return all rows except the ones that have the value of x,...

    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 15, 2016 at 8:00 am

    #1865236

Viewing 15 posts - 3,436 through 3,450 (of 49,552 total)