2014.01.28

   

   

   

SQL

   

• StarJoinInfo in Execution Plans

  http://www.sqlperformance.com/2014/01/sql-plan/starjoininfo-in-execution-plans

     

• Combining multiple CONTAINS predicates in SQL Server 2012

  http://www.sqlskills.com/blogs/joe/combining-multiple-contains-predicates-sql-server-2012

   

• Negative session_ids

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/27/negative-session-ids.aspx

     

• Vote on Connect Items for SQL Server 2008/2008 R2 and 2012 Service Packs

  http://www.sqlserver.co.uk/index.php/vote-on-connect-items-for-sql-server-20082008-r2-and-2012-service-packs/

     

• Nesting Levels in SQL

  https://www.simple-talk.com/sql/sql-training/nesting-levels-in-sql/

     

• Tweet-up: The Top Gotchas of SQL Server Administration and Development ? and How to Overcome Them.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/27/tweet-up-the-top-gotchas-of-sql-server-administration-and-development-and-how-to-overcome-them.aspx

   

• Transact-SQL (T-SQL) query to return the status and detail information for all SQL Server Full-Text Catalogs on an SQL Server instance

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/27/transact-sql-t-sql-query-to-return-the-status-and-detail-information-for-all-sql-server-full-text-catalogs-on-an-sql-server-instance.aspx

   

• PowerShell ? Memory Details GUI Tool

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/27/powershell-memory-details-gui-tool.aspx

     

• Managing SSIS Security with Database Roles

  http://www.mssqltips.com/sqlservertip/3153/managing-ssis-security-with-database-roles/

     

• Comparing Columns In Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/27/comparing-columns-in-power-query.aspx        

     

LINKS

   

• LAST WEEKS TOP "READING" LINKS #68

  http://www.jasonstrate.com/2014/01/last-weeks-top-reading-links-68/