Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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