SQL Server Partitioning: Managing Large Tables

Table partitioning splits large tables into smaller, manageable pieces while appearing as one table. Essential for billion-row tables. Partition Function Partition Scheme Partitioned Table Benefits Fast archival with partition switching Partition elimination…

SQL Server 2008 SP1 CU #9 is available for download

The SQL Server Release Services team recently announced that they have released a new Cumulative Update for SQL Server 2008 SP1: http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/07/19/cumulative-update-9-for-sql-server-2008-service-pack-1.aspx This update will bring you to build 10.00.2789.  From the…

All1 min read

Back-2-Basics: Diff Types of Joins in SQL Server

Back to Basics – Series ::  Cool links for getting to know about the Different Types of Joins in SQL Server. http://www.c-sharpcorner.com/UploadFile/raj1979/SqlJoins10012008164642PM/SqlJoins.aspx http://programming.top54u.com/post/Types-of-Joins-in-Sql-Server-2005.aspx Have Fun!! Happy Coding!!!

All1 min read

SQL Server 2008 R2 is finally RTM

Microsoft has finally released the upcoming version of their SQL Server, called “Sql Server 2008 Release 2(R2)”. Previously i have mentioned in my post that SQL Server 2008 R2 RTM is Nearer .…

All3 min read

SQL Server 2008 R2 RTM is Nearer

It was quite a surprise to see a forum post claiming the SQL Server 2008 R2 – Release Candidate 1, i first thought it was just a bogus information. Since so far i…

All3 min read