SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median, such as statistical, financial or vector medians. Calculating Medians are essentially a row-positioning task, since medians are the middle value of an ordered result. Easy to do in SQL? Nope. Joe Celko explains why.
2009-05-06
2,024 reads
2009-05-05
4,787 reads
2009-05-04
4,500 reads
Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
2010-05-24 (first published: 2009-05-01)
4,996 reads
2009-05-01
4,494 reads
2009-04-30
4,058 reads
2009-04-29
4,506 reads
2009-06-01 (first published: 2009-04-28)
2,834 reads
2009-04-28
3,712 reads
This article discusses a common mistake while making date comparisons in T-SQL and its resolution. From new author Manish Sinha.
2009-04-28
15,750 reads
By Steve Jones
I have often made an effort to attend conferences in the past to grow...
Another discussion in Gothenburg (such a great group of people) around Extended Events lead...
Let's be honest – SQL can be a bit of a beast. At first...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers