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
Execution plan for SQL server query.

SQL SERVER – Does Use of CTE Change the Order of Join in Inner Join

March 24, 2014
Pinal Dave
SQL Tips and Tricks
CTE, Execution Plan, SQL Joins

A reader said he uses a CTE to control join order. Does a CTE change the order of join in an inner join? Here is what I found.

Read More
A folded paper opens into an unlabeled branching route map beside a small red wooden toggle.

SQL SERVER – Turning On Graphical Execution Plan After Enabling ShowPlan Text

March 23, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

Turning on graphical execution plan output requires resetting SHOWPLAN and checking the SSMS actual-plan option. These examples explain batch separators, estimated plans, and actual XML output.

Read More
A cork puller beside two evenly sealed bottles and one raised tilted cork

Assertion Queries: Data Checks That Should Return Zero Rows

March 22, 2014
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Sub Query, Testing

Let a short query find the order with no lines before a customer does. A small demo shows the failing keys, constraint error 547 and a clean repair.

Read More
One distinct red bead appears among separated members on a cotton cord.

MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET

March 21, 2014
Pinal Dave
SQL Tips and Tricks
MySQL

FIND_IN_SET searches a comma-separated string for a complete member and returns its position. I keep whitespace in that string deliberate.

Read More
A bookshelf where the books lean at uneven angles with gaps of different widths between them.

SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020

March 20, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Index, SQL Server

Indexes get fragmented as data grows. I asked my friend Tim Radney what he does then, and here are his index fragmentation next steps from the field.

Read More
SQL SERVER - Retrieve Last Inserted Rows from Table - Question with No Answer

SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer

March 19, 2014
Pinal Dave
SQL Tips and Tricks
MySQL

Can you retrieve the last inserted rows from a table with no identity or date column? Here is my chat with Dustin on a question with no good answer.

Read More
A clean-looking mop bucket and wringer beside a mop with a visible dirty stripe

Buffer Cache Hit Ratio: Why a Healthy Number Can Lie

March 18, 2014
Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL Counter, SQL Memory

A 99 percent ratio does not mean your memory is fine. Here is how to read the counter correctly and what to check beside it.

Read More
MySQL - Pattern Matching Comparison Using Regular Expressions with REGEXP

MySQL – Pattern Matching Comparison Using Regular Expressions with REGEXP

March 17, 2014
Pinal Dave
SQL Tips and Tricks
MySQL

MySQL supports pattern matching using regular expressions with REGEXP. I show how to use ^, $, | and square brackets to match values in a table.

Read More
SQL SERVER - What is the Difference Between Latches and Locks

SQL SERVER – What is the Difference Between Latches and Locks

March 16, 2014
Pinal Dave
SQL Interview Questions and Answers

What is the difference between latches and locks? Latches guard a page only during the physical operation, while locks last for the whole transaction.

Read More
TCP/IP Dynamic Ports dialog box.

SQL SERVER – Find Port SQL Server is Listening – Port SQL Server is Running

March 15, 2014
Pinal Dave
SQL Interview Questions and Answers
SQL Server Management Studio, SQL Stored Procedure

The default instance uses port 1433, but what about a second instance on the same box? Here is how to find the port SQL Server is listening on.

Read More
Previous 1 … 308 309 310 311 312 313 314 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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