Blogs from Suhas

Dirtying my hands in SQL Server

Browse by Tags

Tagged Content List
  • Blog Post: Internals of Database Snapshot – Part 2: Snapshot and the Buffer Pool

    In my earlier post, we have seen what Database Snapshots are, and how the Database Snapshots are maintained by the SQL Server Database Engine. In this post we will see how the data and index pages, belonging to the Snapshot, are managed in the Buffer Pool. Before we start drilling down further, let me...
  • Blog Post: Internals of Database Snapshot

    In this post, we will explore the internals of Database Snapshot. Most of this information is already available in the Internet, in the posts authored by the SQL Server Development Team and the CSS Escalation Team; however, through this post we will attempt to consolidate all of these information for...
  • Blog Post: Advanced Performance Tuning – 3 :: Designing for better performance

    If you have read my earlier post , you might be saying “Heck! This guy loves to post questions without providing proper answers!” Believe me, that is not my intention. My intention here is to help you understand common mistakes that people make, so that you can avoid them in your projects. The biggest...
  • Blog Post: Step-by-step guide to configure Database Mirroring between SQL Server Instances in a Workgroup

    This post is again in response to requests from customers who want to know how to configure Database Mirroring between instances of SQL Server 2005 in a WORKGROUP. As you might have noticed, while configuring Database Mirroring using the GUI, it requires us to enter FQDNs of the servers; hence using...
Page 1 of 1 (4 items)