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
Fresh, fitted replacement and set-aside tiles surround one coordinated restoration tray.

SQL SERVER – MERGE Insert Update and Delete with an Isolated Example

June 8, 2010
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts, SQL Server

Merge Operations can combine conditional inserts, updates and deletes. I inspect the plan before making any claim about scans or speed.

Read More
Execution Plan For Query.

SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2

June 7, 2010
Pinal Dave
SQL Performance
SQL Joins, SQL Scripts

In part 2, Paulo R. Pereira compares IN, EXISTS, SOME and JOIN plans, and shows again that the SQL Server Engine knows the best plan for a query.

Read More
Execution plan for SQL Server query.

SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best

June 6, 2010
Pinal Dave
SQL Performance
SQL Joins, SQL Scripts

Subquery or join, IN or EXISTS? Four queries return the same result, and the execution plans show the SQL Server engine knows the best way to run them.

Read More
SQL SERVER - Convert IN to EXISTS - Performance Talk

SQL SERVER – Convert IN to EXISTS – Performance Talk

June 5, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL Server

A training attendee asked for a simple way to convert IN to EXISTS for better performance. Here is my example with the execution plans.

Read More
SQL SERVER - Generate Database Script for SQL Azure

SQL SERVER – Generate Database Script for SQL Azure

June 4, 2010
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Scripts, SQL Server

Scripts from a regular SQL Server database used to fail on SQL Azure. With SQL Server 2008 R2 you can generate a database script for SQL Azure. Here is how.

Read More
SQL SERVER - Stored Procedure and Transactions

SQL SERVER – Stored Procedure and Transactions

June 2, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure

Is a stored procedure transactional by itself? No. A simple example with three tables shows why stored procedure and transactions are separate things.

Read More
SQL SERVER – Precision of SMALLDATETIME – A 1 Minute Precision

SQL SERVER – Precision of SMALLDATETIME – A 1 Minute Precision

June 1, 2010
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts

The precision of SMALLDATETIME is 1 minute. Seconds are rounded up or down to the nearest minute, and this simple example shows exactly how.

Read More
Previous 1 … 256 257 258 259 260 261 262 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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