Database Optimization & Structure

Creating Database Maintenance Plans

Database administation, Database Optimization & Structure

Using database maintenance plans, we can automate basic database administration activities....
Read More

Configuring Database Mail in SQL Server

Database administation, Database Optimization & Structure • One Comment

SQL Server Database Mail has been introduced in SQL Server 2005. Database Mail is a component that can send emails using SQL Server Engine....
Read More

Compare Execution Plans in SQL Server

Database administation, Database Optimization & Structure

Database Administrator always makes an effort to tune SQL Server query performance. The first step in tuning query performance is to...
Read More

Configuring Heterogeneous Database Replication – SQL Server to Oracle

Database administation, Database Optimization & Structure

Introduction SQL Server Replication is an SQL Server feature that allows us to transfer data from...
Read More

How to Copy SQL Server Databases from One Instance to Another

Database administation, Database Optimization & Structure

Copying or moving databases is one of the most common tasks for data professionals who regularly deal with deploying scripts or new...
Read More

Missing Indexes in MS SQL or Optimization in no Time

Database administation, Database development, Database Optimization & Structure, Indexes • One Comment

When executing a query, the SQL Server optimizer tries to find the best query plan based on existing indexes and available latest...
Read More

Database Optimization: Indexes

Database administation, Database development, Database Optimization & Structure, Indexes

I noticed that very few people understand how indexes work in SQL Server, especially Included...
Read More

How to Analyze Activity of One Database in SQL Server

Database administation, Database Optimization & Structure

Using one SQL Server instance for many projects is not unusual. However, defining the most active project may be quite difficult. Today, I...
Read More

Analysis of MS SQL Server for Those Who See It for the First Time

Database administation, Database Optimization & Structure

What Problems Will We Consider? If the server notifies “there is no more space on the E drive” – no deep analysis is...
Read More

Synchronizing database structure between applications

Database administation, Database Optimization & Structure

Anyone who has ever developed applications that use a database has probably faced the problem of...
Read More
Close