The percent ranks

Nasty Fast PERCENT_RANK

Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008

Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower values. They are now easier to calculate in SQL, and are useful for reporting; but are the new analytic functions faster and more efficient than the older methods? Dwain Camps demonstrates, and investigates their relative performance.

The new Analytic functions in SQL Server 2012

SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.

RE: Need recommendation on backup for production server

You may want to explore SQL Litespeed. You will be able not only save the time, while doing backup(compare to the regular by MS), but also you will be able to save a lot of space. Ex: over the weekend I backed up my 600GB Database with SQL Litespeed- it took 1 hr 15 mins, resulting […]

RE: composite rights using msas dimension security

To clarify, is this only one user who needs to be looking at all stores but only two vendors, but when focusing on vendors he/she can see them all but only two stores? Or is it two different users, one of which can see all stores but only two vendors; the other can see all […]

RE: Error activating allTempdb files. Cant find DB id 3

You should move Master via the SQL startup parameters.  Never try to detach Master, because if somehow it does succeed you will never get it back.TempDB should only be moved via a ALTER DATABASE statement.  If you detach it, it will NOT re-attach using the correct database id.  You will end up with a TempDB […]

RE: Help! Error message "Length of text, ntext...

quote: Yes, that's true but when you are in the middle of replying to a message, there is no way to tell who is logged in. It's kind of screwy when you are sharing a computer. hit CRTL+N (if you use IE) to create a new instance and look at it in the new instance. […]