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 rose branch pressing a red doorbell in the wind with nobody at the door.

UPDATE() in a Trigger Is True Even When Nothing Changed

September 21, 2013
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL NULL, SQL Server, SQL Trigger

Understand why UPDATE() in a trigger fires for unchanged SET values and log only real changes with inserted and deleted row comparisons.

Read More
standup meeting

Developer – Best Practices for Daily Stand-Up or Daily Scrum – Rules and Regulations

September 20, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices

Scrum is an Agile Software Development framework that helps teams complete projects efficiently while maintaining high quality.

Read More
Hands sorting loose screws and nuts into a muffin tin, one cup empty and one bent screw set apart

Turning Key-Value Pairs Into Columns for Reporting

September 19, 2013
Pinal Dave
SQL Tips and Tricks
PIVOT and UNPIVOT, SQL Reports, SQL Scripts, SQL Server

Turn key-value pairs into reporting columns with conditional aggregation and PIVOT, handle missing values and conversions.

Read More
Veneer packets beside one aligned marquetry band and an unused duplicate strip

Set Operator Rules: Column Names, Types and ORDER BY With UNION

September 18, 2013
Pinal Dave
SQL Tips and Tricks
SQL Operator, SQL Server, SQL Union clause

Why did my UNION change its headers, fail on a word, or sort wrong? Small examples show each rule and the error it produces.

Read More
Berry picker gathering several berries beside one berry handled separately

Single-Row Inserts in a Loop: Why Commits Cost So Much

September 17, 2013
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Transactions, SQL Wait Stats

A loop that inserts one row at a time waits for the log on every row. Here is how to see it, and three ways to wait far less.

Read More
SQLCMD Mode.

SQL SERVER – Execute Operating System Commands in sqlcmd

September 16, 2013
Pinal Dave
SQL Tips and Tricks
sqlcmd

Tired of leaving sqlcmd to check something in Windows? Here is a simple trick to execute operating system commands while you are still in the sqlcmd prompt.

Read More
A torch beam lighting fine scratches around a brass keyhole on a front door at night, a key on the mat

Auditing Failed Logins With the Error Log and Extended Events

September 15, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Audit, SQL Extended Events, SQL Login, SQL Server Security

Investigate failed logins with the SQL Server error log and a focused Extended Events session, then group attempts and decide what to do.

Read More
An open cottage door painted green outside, still red on the inside.

Renaming the Windows Server Under SQL Server: Fixing @@SERVERNAME

September 14, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Server Configuration, SQL Server Installation, Windows

After renaming the Windows server, repair SQL Server’s local name with sp_dropserver and sp_addserver, then verify dependent services.

Read More
A hand holding a red striped feather above scattered feathers, the two most similar lying closest

Vector Search in SQL Server 2025 With VECTOR_DISTANCE

September 13, 2013
Pinal Dave
SQL Tips and Tricks
AI, SQL Function, SQL Search, SQL Server

Use VECTOR_DISTANCE in SQL Server 2025 to rank small example vectors, compare cosine and euclidean distance, and plan larger searches.

Read More
Administrator Command Prompt window.

SQL SERVER – Automatically Store Results of Query to File with sqlcmd

September 12, 2013
Pinal Dave
SQL Tips and Tricks
sqlcmd

Want to store results of query to file automatically without SSMS? Here is how to do it with sqlcmd and its -o option, step by step.

Read More
Previous 1 … 327 328 329 330 331 332 333 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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