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 wide new road ending at an old one-lane stone bridge, cars queued at the bridge and the road behind empty.

Choosing Hardware for SQL Server Now

April 12, 2013
Pinal Dave
SQL Tips and Tricks
Disk, Hardware, SQL CPU, SQL Server

Choosing hardware for SQL Server Now means matching core cost, memory, and storage latency to measured workload needs and future growth.

Read More
A solid slate-colored rectangular tile beside a sage triangular tile, a loose cream cord and a red pebble.

geometry STArea: Measure the Polygon Interior

April 11, 2013
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

geometry STArea measures polygon interior rather than its outline. These local planar shapes show equal areas with different perimeters, a hole subtraction and zero-area instances.

Read More
Gouache painting of an old wall panel with one large toggle switch, its vermilion lever flipped up, on a cream plate.

Enable SQLCMD Mode in SSMS: SQL in Sixty Seconds #048

April 10, 2013
Pinal Dave
SQL Video
Command Line, SQL Connection, SQL in Sixty Seconds, SQL Server Management Studio, sqlcmd

To enable SQLCMD mode in SSMS, use the Query menu or set it as the default for new windows. This post tests :connect, :setvar, :r, !! and :on error exit with sqlcmd.exe on SQL Server 2025 and shows the Msg 102 error you get when the mode is off.

Read More
SQL SERVER - Fix : Error: 217 Implicit conversion from data type datetime to int is not allowed.

SQL SERVER – Fix : Error: 257 Implicit conversion from data type datetime to int is not allowed.

April 9, 2013
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

Implicit conversion from data type datetime to int is not allowed. I hit this error with ISNULL and a date, and the fix is right in the message: use CONVERT.

Read More
SQL SERVER - The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

SQL SERVER – The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

April 8, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure

Why does SQL Server say a procedure attempted to return a status of NULL and returns 0 instead? A reader asked on Facebook, and I explain what it means.

Read More
Gouache painting of a wooden chute carrying a red apple from one crate of green apples into another

How to Pass Stored Procedure Result to Another Procedure in SQL Server

April 7, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure, SQL Variable

To pass stored procedure result values from one procedure to another, use an OUTPUT parameter. This post tests RETURN codes, INSERT … EXEC and table-valued parameters on a small order demo. It also shows the errors each method raises and when a function is the better tool.

Read More
Dandelion seeds drifting over a garden wall toward neighboring lawns already dotted with dandelions.

Auditing WITH GRANT OPTION: Who Can Hand Out Permissions

April 6, 2013
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Login, SQL Server, SQL Server Security

Audit WITH GRANT OPTION at database and server scope, trace delegated permissions, and remove delegation with a reviewed CASCADE plan.

Read More
SQL SERVER - Group by Rows and Columns using XML PATH - Efficient Concating Trick

SQL SERVER – Group by Rows and Columns using XML PATH – Efficient Concating Trick

April 5, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL String, SQL XML

A reader wanted students and courses grouped by course and instructor in a single row. Here is a simple concatenation trick with XML PATH that does it.

Read More
Two delivery trolleys stopped nose to nose in a narrow corridor, neither able to pass

What Is a Deadlock in SQL Server?

April 4, 2013
Pinal Dave
SQL Performance
Best Practices, Database, SQL Performance, SQL Server

A deadlock in SQL Server is two sessions each holding what the other needs. I caused one on purpose and read error 1205. Why it is not the same as blocking, who gets killed, and the boring fix that works.

Read More
Gouache painting of two different travel power plugs facing one wall socket, with a small vermilion adapter resting between them.

Cannot Resolve the Collation Conflict (Msg 468): SQL in Sixty Seconds #047

April 3, 2013
Pinal Dave
SQL Video
SQL Collation, SQL Column, SQL Error Messages, SQL in Sixty Seconds

Cannot resolve the collation conflict is Msg 468, and it appears when two text columns use different collations. I reproduced it on SQL Server 2025 with a temp table, found the mismatched columns with a query and tested three fixes, from a COLLATE clause in the query to changing the column itself.

Read More
Previous 1 … 344 345 346 347 348 349 350 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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