Tips

External Article

Free eBook: 45 Database Performance Tips for Developers

  • Article

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.

2014-01-02 (first published: )

17,207 reads

Blogs

A New Chapter: Why I Made the Move from Dayforce to ESO

By

A New Chapter: Why I Made the Move from Dayforce to ESO Over the...

Lean Six Sigma – Brief

By

When you have a project or system, it has to be optimized, tuned, and...

T-SQL Tuesday #200: Bad Query signals

By

NO AI was used to generate this content. Grammarly was used to check and...

Read the latest Blogs

Forums

Reading Parquet using openrowset

By saum70

Hi, We are looking out to read parquet file directly from on premise shared...

Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019

By abdalah.mehdoini

We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...

Forward Deployed Engineers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Forward Deployed Engineers

Visit the forum

Question of the Day

DBCC CHECKDB Limits II

I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?

See possible answers