Mysterious Spacing in text of SQL

Mysterious Spacing in text of SQL

References

Reference NO 1

http://stackoverflow.com/questions/17051200/updating-text-in-using-sql-in-a-database

Reference NO 2

http://sqlmag.com/sql-server/solving-datetime-mystery

Reference NO 3

http://dba.stackexchange.com/questions/19870/how-to-identify-which-query-is-filling-up-the-tempdb-transaction-log

Reference NO 4

http://blog.sqlauthority.com/2010/05/14/sql-server-find-most-expensive-queries-using-dmv/

Reference NO 5

http://rlieving.blogspot.com/2007/09/text-search-in-sql-server-procsviews.html

Reference NO 6

http://oreilly.com/catalog/orsqlloader/chapter/ch01.html

Reference NO 7

http://www.sqlsoldier.com/wp/sqlserver/day28of31daysofdisasterrecoveryrecoveringsqlifthetempdbdrivedies

Reference NO 8

http://www.sqlsandwiches.com/