Auto Create Statistics and Auto Update Statistics
Statistics comprises lightweight objects that are used by SQL Server Query optimizer to determine...
T-SQL SET Operators Part 2: INTERSECT and EXCEPT
In my previous article, I explained the basics of set operators, their types, and prerequisites for their use. I also talked about UNION...
How to Properly Use the T-SQL IsNumeric Function
This article is focused on the T-SQL (Transact-SQL) IsNumeric function and its proper use in day-to-day SQL scripting tasks. We will also...
Advanced SQL: Variations and Different Use cases of T-SQL Insert Statement
In my previous article, I demonstrated: Insert the output of the table-valued function in the SQL...
.NET: Tools for working with multi-threading and asynchrony – Part 1
The need to do things in an asynchronous way – that is, dividing big tasks between multiple working units – was present long before the...
How to Automate the Process of SQL Server Database Schema Synchronization
The goal Keeping two databases in sync is a task we often encounter when working on SQL database development and maintenance. One...
Basic and Complex Uses of Not Equal Comparison Operator in T-SQL
This article is focused on the T-SQL Not Equal comparison operator (<>) and its uses in basic...
T-SQL SET Operators Part 1: UNION and UNION ALL
In SQL Server, we can combine the same type of data from multiple tables using SET operators. After combining multiple SQL statements, it...
Automatic gathering of SQL Server configuration by using PowerShell
At present, the gathering of SQL Server configuration information is no longer a problem— the opportunities to add value through an...
How to use SQL Cursors for Special Purposes
This article describes SQL cursors and how to use them for some special purposes. It highlights the...
