zlika's

As we can read in Books Online in SQL Server
Ranking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Ranking functions are nondeterministic.
I have created simple example for usage of the Ranking function DENSE_RANK().

If you use Outlook 2010 and you prefer to have your data files on external hard drive, you have to point your file location as you add your account manually :-)

I’ve passed the Exam 70-431: Microsoft® SQL Server™ 2005 – Implementation and Maintenance (Transcript ID: 907652, Access Code: 38959BBD) on May 25, 2010 at Prometric Testing Center in Montreal. What’s next? Microsoft® SQL Server™ + .NET :-)
Félicitations