SQL with Manoj
SQL Server (TSQL) Programming, DB concepts, Tips & Tricks… comments welcome!!!
Temporal Data with System Versioned Tables in SQL Server 2016
SQL Server 2016 will be coming with Temporal Data support following the ANSI SQL 2011 standard. This...
Date: 06/30/2015
Export SQL Table or a Query data to JSON string format | SQL Server 2016
As many of you know that in SQL Server 2016 there will be support for JSON data, and with the...
Date: 06/14/2015
Maintaining Uniqueness with Clustered ColumnStore Index | SQL Server 2014
Column Store indexes were introduced in SQL Server 2012 with a flavor of Non-Clustered index i.e....
Date: 08/11/2014
Top SQL Blogs – Windows 8 App | from MSDN, MVPs and Top Bloggers
After I published my first App [SQL with Manoj] on Windows 8 Store, I thought to create an another...
Date: 03/13/2014
Another reason to use THROW clause instead of RAISERROR
In my previous post [link] I talked about the new THROW clause introduced in SQL Server 2012 and how...
Date: 02/03/2014
New THROW statement in SQL Server 2012 (vs RAISERROR)
The new THROW keyword introduced in SQL server 2012 is an improvement over the existing RAISERROR()...
Date: 12/30/2013
Use new TRY_PARSE() instead of ISNUMERIC() | SQL Server 2012
I was working on a legacy T-SQL script written initially on SQL Server 2005 and I was facing an...
Date: 12/23/2013
Using FullText search with FileTables in SQL Server 2012
In my previous post sometime back I talked about FILETABLES, [link]. This is a new feature...
Date: 12/21/2012
SQL Server 2012 (a.k.a Denali) – New feature | FileTables
new kid on the blog... this is my first post on MSDN Blogs after joining Microsoft very recently...
Date: 03/01/2012
DYNAMIC PIVOT
My previous PIVOT UNPIVOT post describes to organize data in a cross tab fashion or to transpose...
Date: 01/30/2012
ISNULL vs COALESCE
ISNULL & COALESCE with some common features makes them equivalent, but some features makes them...
Date: 01/27/2012
Combine multiple ROWS into Comma Separated String… and vice-versa
There are times when you want to combine values from multiple rows of a single column into a CSV...
Date: 01/23/2012
Table variables are not stored in memory, but in tempdb
Table-Variables just like Temp-Tables also gets stored in tempdb. This is a misconception among...
Date: 01/21/2012
Temporary Tables vs Table Variables
Every time there is a lot of debate on #Temporary Tables & Table Variables. And everyone cites...
Date: 01/20/2012