SQL Server Articles
The IDENTITY property for a column of a numerical data type is a frequently used method to achieve system-generated “uniqueness” for each row in a table. Such a column then in turn is a quite popular choice for the PRIMARY KEY constraint. Most of the times one would choose the data type int for the […]
When using the BETWEEN operator on multiple columns, you are likely using a 2D range query. Such queries perform very poorly in SQL Server. This article will tell you how you can often use additional information to rewrite such queries for much better performance. We’ll conclude by rewriting an actual BETWEEN query in a manner […]
General In this article I introduce a simple process that saves tables size information at points in time which latter allows for tracking down table growth over time. The process is useful in monitoring data growth over time and lets you see what tables are growing rapidly in what databases and can also help in […]
Applications typically make connections to the SQL Server databases in large numbers but what if those connections are not successfully closed? How you can monitor them? This short article describes the methods we can use to monitor unclosed connections. Sample Application Let us start with a simple C# WinForms application which has the following UI. […]
Almost from birth, database developers are taught that their databases must be normalized. In many shops, failing to fully normalize can result in anything from public ridicule to exile to the company’s Siberian office. Rarely discussed are the significant benefits that can accrue from intentionally denormalizing portions of a database schema. Myths about denormalization abound, […]
Setting up Transactional Replication in SQL Server 2008 R2. Replication is one of the High Availability features available in SQL Server. Transactional Replication is used when DML or DDL schema changes performed on an object of a database on one server needs to be reflected on the database residing on another server. This change happens […]
This article demonstrates how the performance benefits of implementing front-end caching in performance.
First part of a three part series demonstrates how to get boost performance using caching in SharePoint.
General Database concurrency can be defined as the number of users that can work at a given database at the same time while not effecting or interfering with eachother’s work. The greater the number of users working at the same time the higher concurrency is. SQL Server holds Locks on user data to protect data […]
As DBAs, we are often required to set up alert notification emails for various tasks. For example, there might be a requirement to set up notification alerts if a particular backup job fails. A while back, I came across the situation where I was asked to write a script which sent an email alert to […]