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
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
SQL SERVER - Tools for Proactive DBAs - Central Management Server - Notes from the Field #024

SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #024

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

Tools for proactive DBAs: after many AlwaysOn Availability Group projects, John Sterrett hears the same two questions and answers both in this Notes from the Field episode.

Read More
SQL SERVER - Drop All the Foreign Key Constraint in Database - Create All the Foreign Key Constraint in Database

SQL SERVER – Drop All the Foreign Key Constraint in Database – Create All the Foreign Key Constraint in Database

April 11, 2014
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts

Need to drop all the foreign key constraints in a database and create them again? Here is a script by SQL expert Swastik Mishra that does both.

Read More
Three different protective cases hold a complete arrangement, additional pieces and a sequence of linked fittings.

SQL SERVER – Last Full Differential and Log Backup Finish Times

April 4, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server

I check backup time separately for full, differential and log backups. One latest timestamp cannot describe the entire recovery chain.

Read More
SQL SERVER - Say No to DB Data Roles - SQL Security - Notes from the Field #022

SQL SERVER – Say No to DB Data Roles – SQL Security – Notes from the Field #022

April 3, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Scripts, SQL Server, SQL Server Security

Brian Kelley explains why he avoids the fixed DB data roles db_datareader and db_datawriter, and how they can compromise your server security.

Read More
MySQL - List User Defined Tables - Two Methods

MySQL – List User Defined Tables – Two Methods

April 1, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts, SQL Server, SQL System Table

There are different methods to list out user defined tables in MySQL. We will see two methods in this post.

Let us create the following tables in the database named Test

Read More
Previous 1 … 176 177 178 179 180 181 182 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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