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
SQLAuthority News - Author Visit - SQL Server 2008 R2 Launch

SQLAuthority News – Author Visit – SQL Server 2008 R2 Launch

June 14, 2010
Pinal Dave
SQLAuthority News
SQL PASS, SQLAuthority Author Visit

I traveled from Ahmedabad to Mumbai for the SQL Server 2008 R2 Launch event on June 11, 2010, with a laser show, PowerPivot demos and great networking.

Read More
Three dumbbells on a rack, the smallest newly fitted with extra plates held by a red collar

SQL Server 2025 Editions: What Express and Standard Can Do Now

June 13, 2010
Pinal Dave
SQL Tips and Tricks
SQL Licensing, SQL Server, SQL Server Express, SQL Server Installation

Compare SQL Server 2025 editions, inspect Express and Standard limits, identify the installed edition, and review database portability.

Read More
Last date of a date table.

SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE

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

I repeat my DATETIME and DATETIME2 test with GETDATE instead of SYSDATETIME. See how the distinct values in each column compare this time.

Read More
Results window of join fails join.

SQL SERVER – Difference Between DATETIME and DATETIME2

June 11, 2010
Pinal Dave
SQL Performance
SQL DateTime, SQL Scripts

A developer filled a DATETIME and a DATETIME2 column with the same value and got different results. Here is the difference between DATETIME and DATETIME2.

Read More
SQL SERVER - Difference Between GETDATE and SYSDATETIME

SQL SERVER – Difference Between GETDATE and SYSDATETIME

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

What is the difference between GETDATE and SYSDATETIME? GETDATE stops at milliseconds, while SYSDATETIME in SQL Server 2008 goes much finer.

Read More
SQL SERVER - Fastest Way to Restore Database

SQL SERVER – Fastest Way to Restore Database

June 9, 2010
Pinal Dave
SQL Performance
SQL Backup and Restore, SQL Server

A few days ago, I received following email from blog reader where the question was about the fastest way to restore database.

Read More
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
Previous 1 … 453 454 455 456 457 458 459 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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