Blogs from Suhas

Dirtying my hands in SQL Server

March, 2009

Posts
  • Blogs from Suhas

    Shrinking the Transaction Log files in SQL Server

    • 6 Comments
    Hi Friends! This blog post is mainly to address concerns about increasing log file space, and how to go about to shrink the file. I am adding a priliminary content here as of now, but I will update this content as and when I get time and new content...
  • Blogs from Suhas

    SQL Server Agent is unable to come online on a cluster

    • 4 Comments
    Going through Varun's blog on Lock Pages in Memory in SQL Server 64-Bit , I remembered an issue that I had seen very recently. Thought of putting this down in my blog, to help anybody facing a similar issue. This issue happens typically on 32 bit environments;...
  • Blogs from Suhas

    How to find sizes of all user tables in a database

    • 6 Comments
    Hi Friends! Recently I was asked to write a query that would us us know the sizes of all user tables in a database. Thought of sharing the script; this might be useful to people who would like to know the amount of space being used by each of the tables...
  • Blogs from Suhas

    Working with Multibase Differential Backups

    • 2 Comments
    While working with databases, SQL Server Database Administrators are required to take various types of backups to ensure minimum data loss caused by a failure. Backups include full database backups, file and filegroup backups, differential backups and...
Page 1 of 1 (4 items)