Viewing 15 posts - 1 through 15 (of 93 total)
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...
February 2, 2021 at 10:34 am
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...
February 1, 2021 at 6:55 pm
In the stored procedures you have used as an example you have two queries....
July 2, 2018 at 6:38 am
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...
July 11, 2016 at 5:01 am
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...
July 8, 2016 at 11:17 am
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...
May 23, 2016 at 11:07 am
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...
May 20, 2016 at 12:53 pm
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...
December 18, 2015 at 6:05 am
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)
June 27, 2015 at 9:18 am
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,...
June 26, 2015 at 8:25 am
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...
June 26, 2015 at 6:37 am
An excellent, well-written stairway on a feature that I am very fond of. Thanks!
June 10, 2015 at 6:07 am
Misha_SQL (12/3/2014)
December 3, 2014 at 11:44 am
bubenik.1 (12/3/2014)
December 3, 2014 at 8:31 am
kenambrose (10/30/2014)
MAKE ALL COLUMNS NOT NULLABLE.
If you can't figure out how to design a schema where that works for your business requirements, you...
October 30, 2014 at 8:54 am
Viewing 15 posts - 1 through 15 (of 93 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy