Create a new SQL job from existing one

Hi All,  Today’s post is devoted to very lazy DBA’s.  Some time ago I created a SQL job for defragmenting indexes in a very huge table (about 300 million records). The job included 2 steps and was scheduled at 6:00a.m. Job “DB_Index_Fragmentation” was created and running successfully according to its schedule.   Some months later … More Create a new SQL job from existing one

Page Life Expectancy

Hard disks are slow; memory is fast. This is a fact of nature for anyone that works with computers. When we’re talking about performance and memory we’re talking about a problem how to write data from slow storage into fast memory. Once loaded, your data can perform very fast and only need to go back … More Page Life Expectancy

Parallelism. How to set up advanced options?

What is Parallelism? Parallelism means that SQL Server is able to run operators in an execution plan across multiple worker threads. The goal of parallelism is to improve the throughput of your queries. The first configuration option that influences parallelism in SQL Server is the so-called Cost Threshold for Parallelism: Cost Threshold for Parallelism – … More Parallelism. How to set up advanced options?

Index defragmentation with (MAXDOP = 4)

SQL Server database indexes are created mainly to optimize performance. Different types of indexes such as clustered index, non-clustered index are put in place to make query process run faster. However over time, DML statements (insert, update, delete) cause information scattered across database hence resulting table or index fragmentation. Fragmentation happens when the data logical … More Index defragmentation with (MAXDOP = 4)