Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Home
Topics

database performance

100 posts about database performance

Optimizing Bulk Import Pipelines with Minimal Logging

Rajesh Gami

Rajesh Gami

9moPublished Dec 2, 2025, 10:56 AMUpdated Dec 2, 2025, 11:18 AM

1k

Accelerating Large Delete Operations With Batching

Rajesh Gami

Rajesh Gami

9moPublished Dec 1, 2025, 1:23 PMUpdated Dec 2, 2025, 5:16 AM

2.2k

SQL Materialized Views for Complex Aggregates in SQL Server | Practical Guide with Real-World Patterns

Rajesh Gami

Rajesh Gami

9moPublished Dec 1, 2025, 10:10 AMUpdated Dec 1, 2025, 10:21 AM

3.9k

10 Most Common SQL Server Mistakes Every Developer Should Avoid

Amit Mohanty

Amit Mohanty

9moPublished Nov 14, 2025, 11:32 AMUpdated Dec 1, 2025, 5:55 AM

1.3k

Refactoring N+1 Queries in Transactional Systems

Rajesh Gami

Rajesh Gami

9moPublished Nov 26, 2025, 2:30 PMUpdated Nov 27, 2025, 9:34 AM

2.1k

Mastering Real-Time Analytics with SQL Server 2025 using In-Memory OLTP & Columnstore Indexes

Abhishek Yadav

Abhishek Yadav

9moPublished Nov 26, 2025, 6:50 AMUpdated Nov 27, 2025, 8:00 AM

3.4k

How to Optimize Slow SQL Queries | Beginner-Friendly Techniques with Practical Developer Case Study

Vishal Gami

Vishal Gami

9moPublished Nov 25, 2025, 7:32 AMUpdated Nov 25, 2025, 12:36 PM

5.1k

SQL Views vs Stored Procedures vs Functions — What’s the Difference?

Vishal Gami

Vishal Gami

9moPublished Nov 25, 2025, 7:22 AMUpdated Nov 25, 2025, 12:25 PM

2.6k

Understanding Indexes in SQL Server — What, Why, and When to Use Them?

Vishal Gami

Vishal Gami

9moPublished Nov 24, 2025, 7:44 AMUpdated Nov 25, 2025, 10:25 AM

2.8k

Smart Index Lifecycle Manager (Auto-Create, Auto-Drop, Usage Tracking in SQL Server)

Rajesh Gami

Rajesh Gami

9moPublished Nov 21, 2025, 10:14 AMUpdated Nov 24, 2025, 6:31 AM

559

Efficient Data Partitioning in SQL Server: A Practical Guide for Tables with Millions of Records

Ck Nitin

Ck Nitin

9moPublished Nov 15, 2025, 11:12 AMUpdated Nov 15, 2025, 11:16 AM

2.6k

Using AI to Suggest Database Indexing Strategies in SQL Server: Intelligent Optimization for High-Performance Applications

Rajesh Gami

Rajesh Gami

10moPublished Nov 11, 2025, 7:37 AMUpdated Nov 11, 2025, 9:57 AM

3k

SQL Server Indexing Strategies for Faster Query Execution

Rajesh Gami

Rajesh Gami

10moPublished Oct 31, 2025, 7:57 AMUpdated Nov 5, 2025, 6:12 AM

1.4k

Common Mistakes Developers Make in SQL Queries (and How to Fix Them)

Rajesh Gami

Rajesh Gami

10moPublished Oct 31, 2025, 7:36 AMUpdated Oct 31, 2025, 8:48 AM

4.1k

PostgreSQL Connection Pool Exhaustion — Lessons from a Production Outage

Dipen Shah

Dipen Shah

11moPublished Oct 13, 2025, 12:00 AMUpdated Oct 14, 2025, 5:18 AM

3.6k

How to Optimize SQL Queries for Faster Execution in Large Databases

Ananya Desai

Ananya Desai

11moPublished Sep 23, 2025, 12:00 AMUpdated Sep 23, 2025, 6:23 AM

5.6k

How to Choose the Right Loading Strategy in EF Core?

Jay Krishna Reddy

Jay Krishna Reddy

11moPublished Sep 14, 2025, 12:00 AMUpdated Sep 15, 2025, 9:02 AM

1.8k

🚀 Top 30 Proven Ways to Optimize SQL Server Database Performance (with Examples)

Ck Nitin

Ck Nitin

1yPublished Sep 9, 2025, 10:17 PM

1.9k

Table Sharding in SQL: Types, Examples, and Best Practices

Ayush Gupta

Ayush Gupta

1yPublished Jun 10, 2025, 8:40 AM

2.3k

Keyset Pagination in Entity Framework Core for Efficient Data Retrieval

Jignesh Kumar

Jignesh Kumar

1yPublished Mar 10, 2025, 4:31 AM

6.6k

Understanding Azure CosmosDB Failures and How to Fix Them

Shenbagapandiyan P

Shenbagapandiyan P

1yPublished Feb 24, 2025, 5:04 AM

4.2k

Efficient Data Handling in SQL Server with Table-Valued Parameters

Sanjay Kumar

Sanjay Kumar

1yPublished Oct 27, 2024, 12:00 AMUpdated Oct 27, 2024, 5:52 AM

2.1k

Memory Management in SQL Server

Ajay Kumar

Ajay Kumar

2yPublished Jun 21, 2024, 12:00 AMUpdated Jun 21, 2024, 6:46 AM

4.7k

VLFs - The Forgotten Foe

Monica Rathbun

Monica Rathbun

2yPublished Feb 19, 2018, 12:00 AMUpdated Mar 27, 2024, 9:52 AM

10.7k

Connection Pooling

Munir Shaikh

Munir Shaikh

3yPublished Aug 11, 2007, 12:00 AMUpdated Sep 13, 2023, 7:10 AM

75.7k

«
1
2
3
4
»

76 - 100 of 100