Performance of Table Variables in SQL Server
In this article, we are going to touch upon the topic of performance of table variables. In SQL...
Understanding Pivot Operator in SQL
The pivot operator in SQL Server converts each row in the aggregated result set into corresponding columns in the output set. The pivot...
Sending a Query to All Databases of All Specified Servers in MS SQL Server and C#.NET
Often, it is necessary to send a query to all databases of all specified servers. Many DML-queries can be created with built-in tools....
How to Analyze Activity of One Database in SQL Server
Using one SQL Server instance for many projects is not unusual. However, defining the most active...
32-bit Excel and 64-bit SQL Server
What could be simpler than to get data from an Excel table in SQL Server? There are many ways to accomplish this task. You can utilize...
Common Mistakes of DBA in MS SQL Server
In this article, we are going to review DBAs mistakes, the consequences of which were quite perceptible and which I had to deal with. The...
How to Automate Data Collection on the SQL Server Database Growth
Introduction Often, there is a need to control the growth of all tables and files of all databases....
Understanding Transactions in SQL
A transaction in SQL is a unit of execution that groups one or more tasks together. A transaction is considered successful if all the tasks...
Analysis of MS SQL Server for Those Who See It for the First Time
What Problems Will We Consider? If the server notifies “there is no more space on the E drive” – no deep analysis is...
The Lost Update Problem in Concurrent Transactions
The lost update problem occurs when 2 concurrent transactions try to read and update the same data....