Technical Article

Top 10 steps to optimize data access in SQL Server. Part I (Use Indexing)

’ll focus on the issues that you need to follow to make sure that you have done everything that you could do to optimize the data access codes you have written or you are going to write in future. The Database Administrators (DBA) also has great roles to play in optimizing and tuning the database performance. But, optimization scopes that fall into a DBA’s area are out of scope for these articles.

SQLServerCentral Editorial

Holiday Coverage

It seems that IT people often get stuck working on the holidays, whether being on-call or even dealing with maintenance. We need to remember to rotate that coverage fairly since all of us deserve a break. Steve Jones also reminds you to negotiate compensation.

Blogs

PlanTrace Now Supports PostgreSQL

By

PlanTrace Now Supports PostgreSQL The same plan analysis you know from...

A New Word: the Kinder Surprise

By

the kinder surprise – . the point in your early adolescence when you realize...

Crash-Consistent Snapshot Cloning - Hyper-V Edition

By

If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...

Read the latest Blogs

Forums

BCA KCP Pantai Indah Kapuk Tlpn/wa0853.7373-7551

By alena 71510

Tlpn/wa0853.7373-7551 Jl. Pantai Indah Selatan Blok DF No.1 & 2, Kapuk Muara, Kecamatan Penjaringan,...

BCA KCU MENARA BIDAKARA Telp/WA0851•8812•0691

By poojasharmaji

BCA KCU MENARA BIDAKARA Telp/WA0851•8812•0691 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan...

Alamat Kantor BCA Finance - Depok Tlp/WA.(+62 821°3111°179

By Freightagency

Tlp/WA.(+62 821°3111°179 Komplek Perkantoran, Ruko Pesona View, Jl. Pesona Khayangan Jl. Ir. H. Juanda...

Visit the forum

Question of the Day

SSoL Support on the OS

On which Linux versions is SQL Server 2025 on Linux supported?

See possible answers