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...
SQL Server Bulk Insert – Part 1
According to Wikipedia, ”A Bulk insert is a process or method provided by a database management system to load multiple rows of data...
SQL Server CRUD Operations
In database programming, there are four fundamental operations: create, read, update, and delete – CRUD operations. They are the first...
Introduction to SQL Server Identity
In this article, we will explore the basics and details of the SQL Server IDENTITY property and the...
Essentials and usage of NOLOCK hint in SQL Server
The main idea of the SQL Server locking mechanism is that it controls the consistency of transactions. According to this principle, if a...
SQL Database Administrator Interview Tips
Interview is the most significant step of SQL database administrator recruitment. During the interview, a technical person or interviewer...
Basics of sys.dm_exec_requests
Performance monitoring and troubleshooting in SQL Server is a vast topic. In SQL Server 2005,...
Main Usage of sys.dm_os_wait_stats
As you know, the main responsibility of the database administrator lies in the monitoring of the SQL Server performance and intervening in...
Traditional and Natively Compiled Scalar-Valued User-Defined Functions
In the software programming world, there are several approaches used by developers that help them with effortless software development....
Compare Execution Plans in SQL Server
Database Administrator always makes an effort to tune SQL Server query performance. The first step...