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...

Fine if the company already has Linus...

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)

What exactly do you mean by 'replicas'?

Availability Groups secondary replicas?

Transactional replication subscribers?

Database mirroring secondary?

Something else?

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...

Stats are reset when the index is rebuilt.

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...

I don't understand why people would...

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

Probably more like boot...

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

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...

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...

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

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,...