Troubleshooting long running queries in MS SQL Server
Preface There is an information system that I administer. The system consists of the following...
SQL Server: Useful Tips for Newbies
In this article, we will discuss typical errors that newbie developers may face with while designing T-SQL code. In addition, we will have...
Comparing Objects by Value. Part 4: Inheritance & Comparison Operators
In the previous article, we analyzed how to compare objects by value on a particular example with the Person class that includes:...
Implementing SQL Server Performance Indicator for Queries, Stored Procedures and Triggers
Preface Sooner or later, a DB administrator would like to have a performance indicator for SQL...
Automating Index Defragmentation in MS SQL Server Database
Preface The World Wide Web offers a bunch of information on SQL Server index defragmentation or SQL Server index rebuild. However,...
Insight into SQL Server Unique Constraints
What are unique key constraints? A unique constraint is a rule that restricts column entries to unique. In other words, this type of...
Comparing Objects by Value. Part 3: Type-specific Equals and Equality Operators
In Part 1 and Part 2, we have analyzed how to modify a class to compare objects by value. Now, we...
In Search of Fast Local Storage
Recently, I was involved in the development of the functionality that required a fast and frequent transfer of large volumes of data to...
XML performance tips
Parsing data from XML using XQuery is a routine practice. In order to do this most effectively, little effort is required. Suppose we need...
Common Examples of SSIS Expressions and Variables
Introduction This article helps to enrich the functionality of SSIS. It is possible for example to...