I don’t believe many of the people discussing in-person events are selfish (or dumb as the word used by another post).

I think they legit want to know if it’s possible...

• This reply was modified 3 years, 10 months ago by  Ed Pollack.

As a SQL Saturday organizer, I can say that this is a huge challenge and not as easy as it sounds.  I personally miss in-person events and want them to...

Hi Deepak,

Those indexes are not considered overlapping/duplicate indexes as they do not share sorting functionality. For the sorting columns, order matters. The first index begins with ID, whereas...

This is a common mistake or oversight. Occasionally, there may be a potential use case for creating an additional index on the primary key column(s) with a select...

Yes! SQL Server 2016 removes most of the restrictions, both on In-Memory OLTP, and on natively compiled stored procedures. In 2014 the exceptions were the rule in that...

Michael L John (5/20/2016)

---

N_Muller (8/6/2014)

I didn't mean a "permanent" in-memory table, but a table variable, which is in-memory. The advantage of the table variable is that it is kept...

These specific examples were on smaller data sets---specifically taken from a question asked online prior to this article's original publication. I've tested window functions on other data sets (anywhere...

If I ever thought that one comment couldn't lead to this much discussion, then I now certainly know better 🙂

Jeff Moden (6/27/2015)

---

Ok... Chris' code on the subject of logical reads...

MSDB has pretty straightforward definitions for the data in question:

https://msdn.microsoft.com/en-us/library/ms184361.aspx

If their documentation is wrong, then I'd definitely like to see some sort of proof of that (query/IO measurements,...

This is an innovative way to generate a comma-delimited list, but performance is my main concern here. If you SET STATISTICS IO ON and turn on your actual execution...

An excellent, well-written stairway on a feature that I am very fond of. Thanks!

Misha_SQL (12/3/2014)

---

Thank you for sharing your approach! Am I correct in saying that this would not work if multiple users happen to run this simultaneously? (because of the...

bubenik.1 (12/3/2014)

---

I may have missed it, but is the database status accounted for anywhere in the final version of the procedure? I know that's something that I've run into...

kenambrose (10/30/2014)

---

very simple solution to all the nonsense.

MAKE ALL COLUMNS NOT NULLABLE.

If you can't figure out how to design a schema where that works for your business requirements, you...