2012.12.21

MSSQL

• How It Works: CMemThread and Debugging Them

  http://blogs.msdn.com/b/psssql/archive/2012/12/20/how-it-works-cmemthread-and-debugging-them.aspx

   

• SQL Server Performance Monitoring Tools

  http://www.mssqltips.com/sqlservertip/1067/sql-server-performance-monitoring-tools/

   

• SQLCLR and sp_OA* procedures are not compatible

  http://blogs.msdn.com/b/psssql/archive/2012/12/20/sqlclr-and-sp-oa-procedures-are-not-compatible.aspx

   

• Which SQL Server MVP Has Two Thumbs and a Hadoop Certification?

  http://www.brentozar.com/archive/2012/12/which-sql-server-mvp-has-two-thumbs-and-a-hadoop-certification/

   

• New THROW statement in SQL Server 2012 (vs RAISERROR)

  http://sqlwithmanoj.wordpress.com/2012/12/20/new-throw-statement-in-sql-server-2012-vs-raiserror/

   

• SQL Server 2012 Cluster with TempDB on Local Disk

  http://www.mssqltips.com/sqlservertip/2817/sql-server-2012-cluster-with-tempdb-on-local-disk/

   

• SQL SERVER ? Difference Between CURRENT_TIMESTAMP and GETDATE() ? CURRENT_TIMESTAMP Equivalent in SQL Server

  http://blog.sqlauthority.com/2012/12/20/sql-server-difference-between-current_timestamp-and-getdate-current_timestamp-equivalent-in-sql-server/