Replacing SQL Cursors with Alternatives to Avoid Performance Issues
In this article, we’ll look at some alternatives to using SQL cursors which can help...
Advanced SQL: CROSS APPLY and OUTER APPLY
In this article, we’ll look into the “APPLY” operator and its variations – CROSS APPLY and OUTER APPLY along with examples of...
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 importance of SQL cursors along with...
Concatenation in Transact-SQL
Introduction Assuming you maintain a table containing customer data, and your boss asks you to send...
Running SQL Database Maintenance Tasks Using SQLCMD
This article is about developing an advanced understanding of the Sqlcmd utility which lets you run T-SQL commands directly from the...
Transferring Jobs and Schedules between Instances using T-SQL
Introduction Quite often, there is a need to transfer Agent jobs to a different instance of MS SQL Server. Restoring a msdb database will...
SQL Server Bulk Insert – Part 2
In the previous part of this article, we discussed how to import CSV files to SQL Server with the...
Automatic Deletion of Forgotten Transactions in MS SQL Server
Introduction It is often the case when an MS SQL Server transaction is being forgotten by the initiator. The best example would be the...
Advanced SQL: Insert output of the parameterized table-valued function in SQL table
In this article, I am going to demonstrate the following: How to insert the output of a table-valued function in a SQL table. How to insert...
Bulk Insert Data Files Into SQL Server
According to Wikipedia, the bulk insert is a process or method provided by a database management...
