The Curious Engineer

All blogs / Databases

SQL with Manoj

learn.microsoft.com/en-us/archive/blogs/manub22

SQL Server (TSQL) Programming, DB concepts, Tips & Tricks… comments welcome!!!

DatabasesMicrosoft blogsMSDN archive

’15’20’25
Posts
14 from 20 Jan 2012 to 30 Jun 2015
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/manub22/feed.xml

2015 2

  1. Temporal Data with System Versioned Tables in SQL Server 2016
  2. Export SQL Table or a Query data to JSON string format | SQL Server 2016

2014 3

  1. Maintaining Uniqueness with Clustered ColumnStore Index | SQL Server 2014
  2. Top SQL Blogs – Windows 8 App | from MSDN, MVPs and Top Bloggers
  3. Another reason to use THROW clause instead of RAISERROR

2013 2

  1. New THROW statement in SQL Server 2012 (vs RAISERROR)
  2. Use new TRY_PARSE() instead of ISNUMERIC() | SQL Server 2012

2012 7

  1. Using FullText search with FileTables in SQL Server 2012
  2. SQL Server 2012 (a.k.a Denali) – New feature | FileTables
  3. DYNAMIC PIVOT
  4. ISNULL vs COALESCE
  5. Combine multiple ROWS into Comma Separated String… and vice-versa
  6. Table variables are not stored in memory, but in tempdb
  7. Temporary Tables vs Table Variables