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
Transaction Log Backup Size in Bulk Logged Recovery Model
Assume that I have a database in Bulk Logged Recovery Model, and I perform a bulk operation that is minimally logged. Now, if I take a Log Backup, should not my Log Backup File Size be smaller than if I had performed the same operation in Full Recovery Model? I have seen many people confused by this...
29 Dec 2010
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...
12 Sep 2010
INF: How to re-setup Database Mirroring In SQL Server
One of my friends was asking this to me offline the other day: "I have Database in SQL Server, which is both Mirrored as well as Log Shipped. Log backups happen every 15 minutes; Mirroring happens in Synchronous mode and does not involve a witness. I want to break Mirroring (Remove Mirroring) and...
25 Aug 2010
INF: Automatic Identity Range Management with Merge Replication in Microsoft SQL Server 2005 / 2008
I have been working with SQL Server Replication for over 4 years now; and till now each case that I work on gives me something new to learn. At the same time, every case amazes me by the intricate design that has gone into implementation of SQL Server Replication. With the wonderful GUI design, replication...
21 Mar 2010
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...
17 Mar 2010
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...
12 Mar 2010
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
Registry check-pointing on a Windows Cluster
Over the last few years that I have been in Microsoft, I have come across multiple issues where database administrators have mistakenly made inappropriate changes to the clustered SQL Server registry hives. Later, when SQL Server restarts (either due to manual intervention or during a failover), SQL...
26 May 2009
Server Side Encryption in SQL Server
Hi Friends, After 3 posts on Database Corruption, I hope you would not mind if I divert my attention a bit and post some blogs related to some other topics. This topic that I going to write about is a very interesting topic; so I thought of taking some time out to write a few lines regarding this...
15 May 2009
Property Owner is not available for Database '[DBName]'.
Hi Friends, This issue that I am talking about is a very common issue that I have seen. I have, in my experience, seen many users experiencing this issue; yet, most people do not know how to troubleshoot or fix this issue. Moreover, I have seen this issue on SQL Server 2005; although not tested, I...
5 Apr 2009
Shrinking the Transaction Log files in SQL Server
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 to add. Question: What is a log file, and why...
16 Mar 2009
How to find sizes of all user tables in a database
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 in a particular database. Here goes the script...
16 Mar 2009
Page 1 of 1 (20 items)
© 2014 Microsoft Corporation.
Privacy & Cookies