SIVANANDA REDDY GANGIREDDY

 To clear or shrink the log files in SQL Server and free up space, you can use DBCC SHRINKFILE along with a few preparatory steps, dependin...

  Below query is helpful to find next business date by excluding weekends. We can use  same logic to find out the weekend. 1. Find next busi...

  Microsoft introduced a new feature called SPARSE in SQL server 2008.This will help to reduce the space of column having high proportion of...

This post can help you in capturing SQL Server Transactions per day. Sometimes we need to capture the average number of transactions per d...