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 hand picking a red lure from an open, neatly sorted tackle box

A T-SQL Cheat Sheet for Everyday Work

July 9, 2013
Pinal Dave
SQL Tips and Tricks
Cheatsheet, SQL Joins, SQL Server, SQL Transactions, Starting SQL

This T-SQL cheat sheet gathers daily SELECT, JOIN, GROUP BY, window, TRY_CONVERT, and transaction patterns with short examples.

Read More
Illustrated cover: != or

SQL – Difference between != and <> Operator used for NOT EQUAL TO Operation

July 8, 2013
Pinal Dave
SQL Tips and Tricks

Is there any difference between != and the ANSI operator for not equal to in SQL Server? A Facebook fan asked, and technically they work the same way.

Read More
SQL SERVER - Check Database Level (IsNullConcat) and Session Level Settings (CONCAT_NULL_YIELDS_NULL) using T-SQL

SQL SERVER – Check Database Level (IsNullConcat) and Session Level Settings (CONCAT_NULL_YIELDS_NULL) using T-SQL

July 7, 2013
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

A follow up on CONCAT_NULL_YIELDS_NULL: how to check the database level IsNullConcat setting and the session level setting using T-SQL.

Read More
A bowl of cracked walnuts with one sealed walnut and a red nutcracker beside it.

Finding Encrypted Stored Procedures Before a Migration

July 6, 2013
Pinal Dave
SQL Tips and Tricks
SQL Migration, SQL Server, SQL Server Encryption, SQL Stored Procedure

Inventory encrypted stored procedures and other modules before migration, then recover their approved source and dependencies.

Read More
Tool window with three different strings concatenated.

SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL

July 5, 2013
Pinal Dave
SQL Tips and Tricks
SQL Function

A friend ran SET CONCAT_NULL_YIELDS_NULL OFF above every script to deal with NULL columns. Here is a quick note on what it does and what I think of it.

Read More
Create Clustered Index.

SQL SERVER – How to Refresh SSMS Intellisense Cache to Update Schema Changes

July 4, 2013
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

Dropped an index but SSMS still underlines it in red? Press CTRL + SHIFT + R to refresh the SSMS Intellisense cache and pick up your schema changes.

Read More
Cyclists riding in single file behind a leader in a vermilion jersey who breaks the wind for them.

OPTIMIZED_SP_EXECUTESQL in SQL Server 2025: Fewer Compile Storms

July 3, 2013
Pinal Dave
SQL Performance
Dynamic SQL, Recompile, SQL Cache, SQL Server

Test OPTIMIZED_SP_EXECUTESQL in SQL Server 2025, inspect compilation counters and cached plans, and compare a concurrent workload.

Read More
Matching-handled stitching awls with straight and curved working points

Compare Showplan: Finding What Changed Between Two Plans

July 2, 2013
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Server, SQL Server Management Studio

Compare Showplan shows where two plans differ, but not why. Here is a small before and after example you can run yourself.

Read More
SQL SERVER - Check If Column Exists in SQL Server Table

SQL SERVER – Check If Column Exists in SQL Server Table

July 1, 2013
Pinal Dave
SQL Tips and Tricks

A very common task is to check if column exists in a SQL Server table before you act on it. Here are two simple methods, using sys.columns and COL_LENGTH.

Read More
A hand drops red pigment into a small test jar of cream paint beside a large closed paint can.

Trying New SQL Server Features Without Risk

June 30, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Server, SQL Upgrade, Testing, Virtualization

Trying New SQL Server Features safely takes a separate instance, a controlled data copy, and before and after measurements.

Read More
Previous 1 … 335 336 337 338 339 340 341 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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