RANK vs DENSE_RANK gives tied vote totals different cutoff behavior. Keep display ordering separate from the tie criterion and rank each poll independently.
SQL SERVER – FIX : Error: Msg 15123, Level 16 – The configuration option ‘advance option’ does not exist, or it may be an advanced option.
Msg 15123 says the configuration option does not exist or may be an advanced option. Turn on show advanced options with sp_configure first, then set it.
SQL SERVER – Fix : Error : Msg 4621, Level 16, State 10 : Permissions at the server scope can only be granted when the current database is master
Msg 4621 says permissions at the server scope can only be granted when the current database is master. Switch to master with USE master and grant again.
SQL SERVER – 2008 – SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution
SCOPE_IDENTITY can return a wrong value when a query uses a parallel plan on a multi processor server. Run it on one processor or, better, use the OUTPUT clause.
SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users
In SQL Server 2008, Activity Monitor is empty for a user without the right permissions. Here is how to fix Activity Monitor for all users.
geometry STEquals: Equal Shapes Can Have Different Text
geometry STEquals compares the represented point set, which can stay the same when its text representation changes. I separate that question from byte-for-byte text identity. Reversing a line does not necessarily change the places it occupies.
SQLAuthority News – 900th Article – 9 Best Practices – Important Milestones
Today is my 900th article on this blog. You can see list of all the 900 articles here. I suggest you go over the list and read any article you like.