Archives: June 2013
With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in the SQL Server database engine. It is based on VertiPaq in-memory data compression technology. The xVelocity memory optimized columnstore indexes are one of the most significant performance and scalability enhancements… Read more
SQL Server Agent Jobs are crucial to any SQL Server environment as they are created and scheduled to perform critical business and operational tasks. As a database administrator (DBA) or developer, it is our responsibility to monitor SQL Server Agent Jobs to make sure they are running successfully, without any… Read more
Checkout the part-2 of my two part article series on SQL Server Transactions and Locking here, in which you will learn how to manage transactions, how to set the transaction isolation level, and how some isolation levels use locking, while others use row versioning.
This article is published on… Read more
Whether caused by hardware failure, software errors or malicious actions, there is always a possibility of data loss. You should be prepared to deal with the loss of data and where possible recover your data. How well you plan for the possibility of failure, design of data protection strategy and… Read more
SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests from many clients, there is a strong possibility that conflicts will occur because different processes request access to the same resources at the same time. A conflict in which one… Read more