NULLIF

invert function "isnull()"
important "nullif" not support null value you make sure value is not null

table sample percent sql server

The rows retrieved are random and they are are not in any order
Example 1:
SELECT FirstName,LastNameFROM Person.Contact
TABLESAMPLE SYSTEM (10 PERCENT)
Example 2:
SELECT FirstName,LastNameFROM Person.Contact
TABLESAMPLE SYSTEM (1000 ROWS)

http://blog.sqlauthority.com/2007/05/27/sql-server-2005-limiting-result-sets-by-using-tablesample-examples/

force document mode

 
  http-equiv="X-UA-Compatible" content="IE=Edge">

For explanations, see http://hsivonen.iki.fi/doctype/#ie8 (it looks rather messy, but that’s because IE is messy in its behaviors).

http://stackoverflow.com/questions/10830894/how-to-force-ie9-to-render-in-ie9-document-mode