Tag: performance

dbForge Edge: Your Best Universal Tool for Multidatabase Challenges

MySQL, Oracle, PostgreSQL, SQL Server, Tools & technologies

Handling several database management systems simultaneously is inevitable in working on multiple...
Read More

SQL Server Transactional Replication Issues

Database administration, Performance Tuning, Transaction Log, Troubleshooting Issues

We started talking about SQL Server Transactional Replication issues earlier. Now, we are going to continue with a few more hands-on demos...
Read More

A Simple Use Case for Indexes on Primary Keys

Database administration, Database development, Indexes, Performance Tuning, SQL Server • 3 Comments

Introduction Recently we encountered an interesting performance problem on one of our SQL Server databases that process transactions at a...
Read More

Top 3 Tips You Need to Know to Write Faster SQL Views

Database development, Views

Friend or foe? SQL Server views have been a subject of heated debates when I was in my first year...
Read More

How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective

Database development, Performance Tuning, Tables, Work with data

We often see poorly written complex SQL queries running against a table or tables in databases. Those queries make the time of execution...
Read More

How To Create SQL Trace To Capture SQL Server Events

Database administration, Database development, Events, Performance Tuning

Facing an SQL Server performance issue, you need to identify the source of that performance problem fast. Therefore, a tool for tracking...
Read More

Workplace Encounters: Reclaiming Space from an Oversized Database

Database administration, Memory Optimization

INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on...
Read More

SQL Server Lock Escalation

Database administration, Work with data

Introduction Relational databases follow the ACID properties in how they implement transactions – Atomicity, Consistency, Isolation, and...
Read More

Update SQL Server statistics using a database maintenance plan

Database administration, Database Optimization & Structure

Database backups, integrity checks, and performance optimizations are core regular tasks of DBAs. The client data is very important for a...
Read More

Overview of Data Compression in SQL Server

Database administration, Work with data

The database is a critical and vital part of any business or organization.  The growing trends...
Read More