Monthly Archives: September 2014

Database Partitioning into SQL Server (Part 1)

While working on large database/tables we come across several issues – may be queries running slow i.e. data performance issues, time to perform certain maintenance operations and replicating/deleting data from these tables. And to deal with these tailbacks, we think … Continue reading

Posted in SQL Server, SQL Server 2008 | 1 Comment

DELETE vs TRUNCATE – SQL Server

Although this is a very simple question that ‘what is the difference between using DELETE vs TRUNCATE statements in SQL Server’, & both are being used very frequently serving more or less the same purposes, but there are various aspects … Continue reading

Posted in SQL Server, SQL Server 2008 | Leave a comment