Partitioning Tables in SQL SERVER

Partitioning is helpful for managing and accessing smaller chunks of data very efficiently and at a faster pace without compromising on data integrity.

SQL Server supports Range Partitions. This means that the partitioning is based on data ranges.

Comments

Post a Comment

Popular posts from this blog

“Unable to retrieve the metadata for …” Error while using ASP.NET MVC 3

While adding a controller in ASP.NET MVC 3 application, you might get a error “Unable to retrieve the metadata for …”. This error is due to the incorrect connection string name or the connection string in the web.config. I had encountered the same error and the issue was that the name of my DBContext was different from that of the web.config connection string name. When I made it same it was able to create the controller.
Read more

Getting Started with ASP.NET MVC, SignalR KnockoutJS

Image
This article describes a simple application intended to notify users when a new user is created. To build the same we are using the technologies like ASP.NET MVC 4, SignalR, KnockoutJS, ToastR, Twitter BootStrap. First lets create a ASP.NET MVC 4 Web Application. Lets add the SignalR, KnockoutJS, ToastR, Twitter BootStrap by using the Package Manager Console into the project. install-package knockoutjs install-package Microsoft.AspNet.SignalR install-package Twitter.Bootstrap install-package Toastr We added a new page "CreateUser.shtml" and the code looks like as shown below < h2>User Creation < script src="../../Scripts/jquery-1.9.1.js" type="text/javascript">     < script src="../../Scripts/knockout-2.3.0.js" type="text/javascript"> < script src="../../Scripts/bootstrap.js" type="text/javascript"> < div class="container-fluid">     First Name: < input typ...
Read more

2012 - > 2013 : Happy New Year

Looking back at the year that has gone past, it has a lot of memories. I thank god for the year that has gone by and what he has done in my life.  On professional front, it was a good year with new challenges and new opportunities. There was travel involved as well. Learned new things on technology and management perspective. I was privileged to attend some of the high end management workshops which is great for my career progression.  On personal front, i had the home project of giving a new look to my house. Had got the house repainted and replaced the front gates. Also growing on the spiritual side as well, learning to know god more and more.  Now the new year 2013 is in, I hope this year will be great. I attended the watch night New Year service yesterday at Palace Grounds, it was an amazing service. The promise for this year is "Supernatural Breakthrough - Habakkuk 3: 17 - 19"  "17 Although the fig tree shall not bloss...
Read more