SQL Server: ranking your data

This is the kind of query that kills some servers – ranking.

It’s a bit hard to make programmers understand how important the performance of their code can have a big impact on server speed – they all seems to think that throwing more hardware will solve all world’s problems… unfortunately it does not work that way.

So, after the app is completed and tested and validated by the manager (with a small data-set, of course), it goes live. After a few thousand records are inserted, things start to slow down, and it is exactly the report that the manager will look everyday. If this is familiar to you, take a look at the hints and techniques in this article: Nasty Fast PERCENT_RANK from SQL Server Central folks.

It’s not just the ranking itself, but all types of queries and data manipulation shown there that may help you. And the ideas work in all database engines, of course changing the language to the one you like.

and happy coding!

cya

Advertisements

About mauriciorpp

Hi, I am Piccolo - but not the one from Dragon Ball. I'm from a highly competitive and fast-paced world too, the IT industry, and this space will be used to share some challenges I face daily on my career. As you will see, I don't do brawls but I need to be a fighter! Stay tuned.
This entry was posted in BI, MongoDB, MySQL, Oracle, SQLServer and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s