How to Automate SQL Database Maintenance Tasks using SQLCMD
This article is about automating SQL database maintenance tasks through SQLCMD utility which lets...
The Difference Between Primary Key And Unique Key
“What is the difference between a primary key constraint and a unique key constraint?” This is probably the most frequently-asked job...
How to Export Data to Flat File with BCP Utility and Import data with Bulk Insert
The BCP (Bulk Copy Program) utility in SQL Server allows database administrators to import data into a table and export data from a table...
Overview of DBCC CheckDB Function
Introduction Regular database maintenance is an important part of a Database Administrator’s job...
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 avoid performance issues caused by using...
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...
Concatenation in Transact-SQL
Introduction Assuming you maintain a table containing customer data, and your boss asks you to send him the current list of customers and...
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...
