Tips for Read/Write Locks Depending on Transaction Isolation Level in MSSQL
Read Uncommitted If data is being changed in one transaction, selection of this data (in other...
Automatic Data Collection: Database Files and Logical Drives in MS SQL Server
Introduction It is important for a database administrator to know when there is no space on a disk. Thus, it is better to automate the...
Entity Framework 6: Extensions You Might Be Unaware Of
Entity Framework 6 was and still remains a ‘workhorse’ for data access incorporate. NET-based applications primarily because of...
Automatic Data Collection of Database Schema Changes in MS SQL Server
Introduction Have you ever faced a situation when you need to make changes in a stored procedure or...
Precise Computation of CLR Object Size
I think many developers have been wondering: How many bytes does an object instance take in managed code? What’s the limit for a CLR...
Automatic Data Collection about Completed Tasks in MS SQL Server
Introduction It is important for a database administrator to know what tasks and how have they been completed. To simplify this process, it...
Optimizing Overlapping Queries Part 1: Introduction & Enhanced T-SQL Solution
Databases that serve business applications should often support temporal data. For example, suppose...
Automatic Deletion of Stuck Processes in MS SQL Server
Introduction There are situations when applications keep the database connection for a long period of time. It seems to be not important....
Comparing Objects by Value. Part 6: Structure Equality Implementation
We have already analyzed peculiarities of structs of the .NET framework that represent Value Types when comparing objects by value –...
Comparing Objects by Value. Part 5: Structure Equality Issue
In my previous publication, I described the fullest and the most correct way to compare objects by...