Overview of DBCC SHRINKFILE Command
Running DBCC Shrink commands is quite a controversial issue across the SQL Server community. In...
How to Automate SQL Database Maintenance Tasks using SQLCMD
This article is about automating SQL database maintenance tasks through SQLCMD utility which lets you run T-SQL commands directly from the...
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...
Overview of DBCC CheckDB Function
Introduction Regular database maintenance is an important part of a Database Administrator’s job which helps to ensure that critically...
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...
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 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...
