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...

Author: Manoj Pandey (manub22) 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...

Author: Manoj Pandey (manub22) 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....

Author: Manoj Pandey (manub22) 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...

Author: Manoj Pandey (manub22) 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...

Author: Manoj Pandey (manub22) 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()...

Author: Manoj Pandey (manub22) 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...

Author: Manoj Pandey (manub22) 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...

Author: Manoj Pandey (manub22) 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...

Author: Manoj Pandey (manub22) Date: 03/01/2012

DYNAMIC PIVOT

My previous PIVOT UNPIVOT post describes to organize data in a cross tab fashion or to transpose...

Author: Manoj Pandey (manub22) Date: 01/30/2012

ISNULL vs COALESCE

ISNULL & COALESCE with some common features makes them equivalent, but some features makes them...

Author: Manoj Pandey (manub22) 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...

Author: Manoj Pandey (manub22) 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...

Author: Manoj Pandey (manub22) 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...

Author: Manoj Pandey (manub22) Date: 01/20/2012