Database Recovery

Quick insights about SQL Server Indexes

In this article we explore the role of Indexes in SQL Server performance One of the most complicated features considered by many working on SQL Database is its indexes. Although, a bit confusing, SQL Indexes play a very important role in your overall performance and you can really work faster and efficiently with some great indexes. On the other hand, poorly managed indexes can make you feel helpless working on SQL database. In this article, you will learn some quick insights about SQL...

Read more »

Looking to Boost Scalability of your SQL Server- Here’s What You Need To Do!

In this article we look at ways to scale up a SQL server implementation Whether you agree or not but deep inside your heart you must be wishing to optimize your SQL Server Database; but since scaling out a SQL Server running on multiple cores is bit difficult you might have hesitated to do so. Good news is that now you can easily boost the scalability of your individual SQL Server and in fact, now scaling up is easier than scaling out. In order to scale your existing SQL Server, you need...

Read more »

Locking in SQL Server

In this article we look at how locking happens in Ms SQL server and learn about their types Whether you know or not, the credit for handling a number of transactions in SQL Server goes to its Locking strategy. There are in fact, different types of locks for different types of query plans. This is not all; a user can make the server create more locks like the shared, holdlocks and noholdlocks for specific queries. Locking in SQL server can be done both at a larger level and at a smaller...

Read more »