How to Move Datafiles in SQL Server – Part 1
Introduction There are a number of situations which would warrant the movement of database files or...
Implementing Paging Using OFFSET FETCH NEXT in SQL Server
A database can have hundreds of thousands of records. It is easy to insert and select these records via database management systems like...
Basics of sys.dm_exec_requests
Performance monitoring and troubleshooting in SQL Server is a vast topic. In SQL Server 2005, dynamic management views, also known as...
Main Usage of sys.dm_os_wait_stats
As you know, the main responsibility of the database administrator lies in the monitoring of the...
Conditional Split Transformation: Export Data from SQL Server into Oracle and MySQL Databases
In this article, I have explained how we can divide and export data of SQL Server database table into Oracle and MySQL databases. That...
Compare Execution Plans in SQL Server
Database Administrator always makes an effort to tune SQL Server query performance. The first step in tuning query performance is to...
Fixing Data Loss Using Log Shipping with Delayed Recovery
Introduction Transaction Log Shipping is a very well-known technology used in SQL Server to...
Export data from SQL Server to Excel and Text file via using SSIS package
While using the SSIS data flow, we can perform ETL task that can be used for data migration, data offloading, design and implementation of...
Structured Query Language – Importance of learning SQL
Computer programming language is a set of detailed instructions for computers or machines for performing specific actions. Through a...
Exporting Oracle Table to Excel Worksheet
In this article, I will explain how we can divide and export data of an Oracle database table into...
