Blogs from Suhas
Dirtying my hands in SQL Server
Copy On Write
Lock Pages in Memory
Minimum Recovery LSN
Not For Replication
SQL Server 2005
SQL Server 2008
Virtual Log File
Browse by Tags
Blogs from Suhas
Tagged Content List
Internals of Database Snapshot – Part 3: Snapshot and Mirroring
In my earlier posts, we have seen how database snapshots work, and how the Buffer Pool is used when we query Snapshot Databases. In this post, we will see how Database Snapshots work, when they are created against Mirrored Databases. Let us assume we have a mirroring setup, as described in the below...
15 Aug 2011
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...
2 Aug 2011
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...
31 Jul 2011
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...
15 Jul 2011
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...
14 Jul 2011
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...
13 Jul 2011
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...
18 Jul 2009
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...
13 Jul 2009
How to configure SQL Server Database Mail to send email using your Windows Live Mail Account or your GMail Account
Hi Friends, This post comes as a response to requests from many of our customers, who want to know the step by step process on how to configure SQL Server Database Mail to send emails using their Windows Live Mail Account or their Gmail Account. If you are using SQL Server 2005 or higher, you might have...
12 Jul 2009
Database Corruption Part 5 :: Dealing with Log File Corruption
Hi Friends, I am back again after a long time. Last month was the end of yet another financial year, and all of us were very busy with the processes involved with each year-end. Now that all those are completed, I could find some time for my next blog post on database corruption. Here, I will be targeting...
11 Jul 2009
Database Corruption Part 1 :: Introduction to Database Corruption in SQL Server
Hello Everybody, I think you will all agree with me that database corruption is one of the nightmares in the life of a DBA. We store precious data in databases and each day the dataset grows bigger and bigger. A database corruption issue not only puts the data at risk, it also threatens to take a toll...
8 Apr 2009
Page 1 of 1 (11 items)
© 2014 Microsoft Corporation.
Privacy & Cookies