Scheduled Maintenance of the 24/7 IS Database in MS SQL Server
Introduction This article is a short review of the main scheduled maintenance with a database of...
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 transaction or without a transaction) will...
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....
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 a view very quickly? I have, very...
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...
Optimizing Overlapping Queries Part 1: Introduction & Enhanced T-SQL Solution
Databases that serve business applications should often support temporal data. For example, suppose a contract with a supplier is valid for...
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...
