2009-05-11
4,533 reads
2009-05-11
4,533 reads
2009-05-07
4,153 reads
2009-05-06
3,965 reads
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,788 reads
2009-05-04
4,503 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)
5,304 reads
2009-05-01
4,496 reads
2009-04-30
4,062 reads
2009-04-29
4,507 reads
This came up one day at my work when a developer was using it....
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
By Steve Jones
When in doubt, overtip – from Excellent Advice for Living This is close to...
Hi Everyone, I have a question, I am trying to setup a Lab environment...
Comments posted to this topic are about the item Upgrades to SQL Server 2022
Comments posted to this topic are about the item Elements of the SQL Server...
What is the earliest version from which you can directly upgrade to SQL Server 2022?
See possible answers