Analytical functions available in SQL Server 2012

Question

Post reply

Analytical functions available in SQL Server 2012

Junior Galvão - MVP

SSCertifiable

Points: 6951
More actions
May 16, 2015 at 3:14 pm

#398470

Comments posted to this topic are about the item Analytical functions available in SQL Server 2012

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

Nice Question, thanx!

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

TomThomson SSC Guru Points: 104773 More actions · Answer 2

Straightforward question,

It's a bit surprising how many have it wrong so far (more than half) because the four functions in the three wrong options have all been around since long before 2012.

Tom

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 3

Nice question on a topic which I have rarely used excepted with my old Developer edition 2008.

I have only hesitated about CUM_DIST which I have already seen but for 2012 or 2014 ? I was not sure. I attempted this choice successfully.

Thanks for this point I got ( in a lucky way )

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

A good, straightforward question and there was no ambiguity. Since I use window functions quite a bit and am still on 2008 for a little while longer, it was simple for me because I know what I don't get to play with and push yet. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Eirikur Eiriksson SSC Guru Points: 182916 More actions · Answer 5

TomThomson (5/17/2015)
Straightforward question,
It's a bit surprising how many have it wrong so far (more than half) because the four functions in the three wrong options have all been around since long before 2012.

The ratio is getting better, guess waking up helps:-D

😎

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

TomThomson (5/17/2015)
Straightforward question,
It's a bit surprising how many have it wrong so far (more than half) because the four functions in the three wrong options have all been around since long before 2012.

+1

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events