A good database design provides the best performance during data manipulation which results in the best performance of an application. During database designing and data manipulation we should consider the following key points: 1). Make sure that every table in your database has a primary key : This will ensure that every table has a …
Monthly Archives: October 2016
In the series of SQL SERVER 2016, this is a new post. in this post, we will discuss DATEDIFF_BIG and how it is helpful. So, before jumping into directly in technical details, we all know that time is very important and every second valuable and countable but sometimes every microsecond & nanosecond is also countable …
In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have a comma or other separator string and if you have to split it by separator field then for such task in previous SQL SERVER versions either you will write a function which split the string …
This is another article in the series of SQL SERVER 2016 Journey . I am pretty much sure you might aware of Gzip Compression algorithm. If not then try this link. So, SQL SERVER 2016 introduce this two awesome functions for Compress & Decompress the data. Before SQL SERVER 2016 version we have data compression …
In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a new cool feature which introduced in SQL SERVER 2016 which is DROP IF EXISTS (DIE) . In our development many times it happens that we need to drop a table and as a best practice …
In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a new cool feature which introduced in SQL SERVER 2016 which is DROP IF EXISTS (DIE) . In our development many times it happens that we need to drop a table and as a best practice …
Although, I know I am bit late to share this thing on our blog but it says in Indian proverb “Der aai durust aai” means it’s OK you came late but you came that is more important. Anyways, so you all might aware that Microsoft launched SQL SERVER 2016 officially in June 2016. You can …
Although, I know I am bit late to share this thing on our blog but it says in Indian proverb “Der aai durust aai” means it’s OK you came late but you came that is more important. Anyways, so you all might aware that Microsoft launched SQL SERVER 2016 officially in June 2016. You …