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
A wooden pigeon loft at dusk with a pigeon in every nesting box except one empty box with an open door.

Tracking Job Failures Across Servers

October 30, 2008
Pinal Dave
SQL Tips and Tricks
DBA, SQL Monitoring, SQL Scripts, SQL Server Agent

Tracking job failures across servers takes a daily msdb report, a central instance list, and notifications that reach someone who can act.

Read More
Execution plan for merge join.

SQL SERVER – INNER JOIN using LEFT JOIN statement – Performance Analysis

October 25, 2008
Pinal Dave
SQL Performance
SQL Joins, SQL Scripts

Can you write an INNER JOIN using LEFT JOIN? Yes, and the result is the same, but my performance analysis in AdventureWorks shows why you should not.

Read More
Gouache painting of a square bolt beside a round nut that does not fit, with the round nut painted red

Incorrect Syntax Near: When Compatibility Level Is the Cause

October 21, 2008
Pinal Dave
SQL Tips and Tricks
Compatibility Level, SQL Error Messages, SQL Scripts

Incorrect syntax near means the parser met a word it did not expect, and a low compatibility level is one cause. This post reproduces the error, shows how to read and raise the level, and covers the other common causes.

Read More
SQL SERVER - Transaction and Local Variables - Swap Variables - Update All At Once Concept

SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept

October 20, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security, SQL Transactions

Two ideas with examples: transactions have no effect on local variables, and an UPDATE applies all its changes at once, which lets you Swap Variables in one go.

Read More
SQL Server project new project dialog box.

SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure

October 19, 2008
Pinal Dave
SQL Performance
CLR, Software Development, SQL Scripts, SQL Stored Procedure, SQL Utility

An introduction to CLR in SQL Server 2005 and later, with a simple CLR Stored Procedure built in Visual Studio that prints the current system datetime.

Read More
Execution time statistics.

SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2

October 18, 2008
Pinal Dave
SQL Performance
Best Practices, SQL DateTime, SQL Function, SQL Scripts

Which way to select only date part from DATETIME is faster? After more tests on large tables, I now suggest the DATEADD and DATEDIFF method over CONVERT.

Read More
SQL SERVER - Get Common Records From Two Tables Without Using Join

SQL SERVER – Get Common Records From Two Tables Without Using Join

October 17, 2008
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts

Sachin wanted common records from two tables without writing a join condition. Imran Mohammed shows how INTERSECT in SQL Server 2005 does it.

Read More
Previous 1 … 297 298 299 300 301 302 303 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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