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 – 4 :: Designing for better performance contd…

    Few months back, I was working with one of my customers, who was engaged by his client to design a Survey Module. Nothing very fancy about the module, but the kind of reports that were to be delivered made it really tricky. Let me explain the requirements first: When customers click on a Survey Link...
  • Blog Post: Advanced Performance Tuning – 2 :: Which side of the operator

    If you have read my earlier blog post on the Importance of data-types , you might be wondering, “What the heck is going on here?” I had already written in that post the reason behind the slow performance – the EmpCountry column in the Employee table is CHAR(2) which cannot be directly compared with NCHAR...
  • Blog Post: Advanced Performance Tuning – 1 :: Importance of data-types

    Why did we develop DBMS systems? Not just for storing data – but also to be able to search for and retrieve stored data, and we define what our search criteria should be. This was probably true a couple of decades back, but we have come a long way now. With the huge advancement of technology...
  • Blog Post: INF: A missing exception handler can cause blocking and eventual application hang.

    Very recently, I had the opportunity to help troubleshoot a Blocking issue that one of our customer's was experiencing. In my experience, this is a very common scenario that I have seen. However, while troubleshooting this issue, and more so, while we wrote code to reproduce the issue at our end, we...
  • Blog Post: Is NFR set?

    Hi Friends, After a long break of about 8 months, I am back again!! Many things changed recently, and I was quite busy adopting to the changes – the most challenging was, of course, adopting myself to new parenthood. However, I am back again, with some new topics – topics that I have learnt or experienced...
  • Blog Post: Revealing the secrets - Truncating a Transaction Log File

    In my earlier blog post on Shrinking the Transaction Log files in SQL Server , I had mentioned that a VLF can be truncated only when all transactions, that have at least one command written into the specified VLF have either been committed or rolled back. While this is true, I understand that it might...
Page 1 of 1 (8 items)