What is the Delayed Durability in SQL Server? This is a dangerous feature introduced in SQL Server 2014. Also known as lazy commit, It is

What is the optimize for ad hoc workloads option? When you write a query in SQL Server, the query optimizer needs to create a “Plan” of

The disk is the slowest part of the computer. Proper configuration storage systems are critical to the optimal performance and operation of SQL Server. Below

Category: Reliability Item:  SQL Agent Jobs without notifications SQL Server Agent permits you to run a wide variety of tasks within SQL Server. Its built-in

It is not common to have SQL log files larger than data files. If it is, this may indicate a potential problem: A possible bad

Disable keys and constraints to improve the performance of load data is a common practice in large data warehouses and other environments with big tables.

Category: Performance Item:  Windows visual Effects not optimal By default,  Windows is optimized for a beautiful display, but this is not very important for a

Category: Performance Item: Instant File Initialization access right What’s Instant file initialization (IFI)? Instant file initialization is a Windows feature that enables your  SQL Server to

Category: Reliability Item:  Full Recovery Mode without backup logs Why should you care about it? If you are using a database is in Full Recovery Model or

Why should you care about SQL Server query hints? Hints in SQL queries is like a double-edged sword. While you might find a better query

What is Dynamic management views (DMVs)? Introduced within SQL Server 2005, Dynamic management views (DMVs) are significant features of SQL Server. There are several DMVs

The security model offered by Microsoft SQL Server is highly configurable and very robust when all security best practices are followed. Why should you care