This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - Synchronize Data Exclusively with T-SQL

SQL SERVER – Synchronize Data Exclusively with T-SQL

May 1, 2014
Pinal Dave
SQL Tips and Tricks
Devart

Many tools sync data between databases. Here I build the functionality to synchronize data exclusively with T-SQL, step by step, from structure to triggers.

Read More
SQL SERVER - Faster Application Performance with In-Memory OLTP

SQL SERVER – Faster Application Performance with In-Memory OLTP

April 30, 2014
Pinal Dave
SQL Tips and Tricks
Safepeak, SQL Server

How in-memory OLTP engines give faster application performance and better scalability for SQL Server databases, with a focus on SQL Server 2014.

Read More
Three swimmers waiting in line on a jetty for a swimmer in a red cap to leave the only diving board

Signal Waits: Telling CPU Pressure From Slow Disks

April 29, 2014
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Performance, SQL Wait Stats

Measure signal waits over an interval, compare scheduler queues and file latency, and separate CPU scheduling pressure from storage delays.

Read More
SQLAuthority News - An Amazing Event - Presented at North India's Largest Conference C Sharp Corner

SQLAuthority News – An Amazing Event – Presented at North India’s Largest Conference C Sharp Corner

April 28, 2014
Pinal Dave
SQL Tips and Tricks
SQL User Group, SQLAuthority Author Visit

There are few feelings which are hard to describe in words as this note is about an amazing event on the C Sharp Corner.

Read More
Smooth wooden balls resting in separate shallow channels beside a crowded wooden bowl on a table.

When In-Memory OLTP Helps and When It Does Not

April 27, 2014
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Learn when In-Memory OLTP can reduce transaction contention, which limitations still matter, and what to measure before changing tables.

Read More
A small scoop rests beside a glass jar of mixed dried beans on a wooden table.

What the Cardinality Estimator Does and When It Is Wrong

April 26, 2014
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Understand how the cardinality estimator predicts rows, why estimates go wrong, and which statistics and plan checks help you investigate.

Read More
Heavy snow boots on a hot sandy beach beside a pair of red sandals

MySQL Habits That Trip Up Developers Moving to SQL Server

April 25, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Collation, SQL Migration, SQL Server

Replace six MySQL habits with SQL Server equivalents for LIMIT, AUTO_INCREMENT, quoting, GROUP BY, duplicate inserts, and collations.

Read More
SQL SERVER - Database File Names and Extentions - Notes from the Field #025

SQL SERVER – Database File Names and Extentions – Notes from the Field #025

April 24, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore

What is in a name? Plenty, when it comes to database file names and extensions. Tim Radney shares a funny story on why naming standards matter.

Read More
Data Scientist.

Data Science: A Step Forward from Business Intelligence – Data Scientist

April 23, 2014
Pinal Dave
SQL Tips and Tricks
Business Intelligence

Who can predict which customer is going to cancel a newspaper subscription before it actually happens? It’s a Data Scientist.

Read More
A fence painted halfway, a red-handled brush resting in the paint tin where the paint stops

Resumable Index Rebuilds: Pausing Maintenance Without Losing Progress

April 22, 2014
Pinal Dave
SQL Performance
DBA, Maintenance Plan, SQL Index, Transaction Log

Run a resumable index rebuild with ONLINE and MAX_DURATION, pause and resume it, inspect progress, and weigh edition and log costs.

Read More
Previous 1 … 304 305 306 307 308 309 310 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com