No results in SSMS, yet the same query works in the app? My friend Ajit hit this, and the cause was the option to discard results after query execution.
SQL SERVER – Validating Spatial Object as NULL using IsNULL
How do spatial functions handle NULL? I show two ways of validating a spatial object as NULL: the IsNULL method, which returns 0 or NULL, and IsValidDetailed.
SQL SERVER – Validating Spatial Object with IsValidDetailed Function
Invalid spatial objects used to give only a simple error. The IsValidDetailed function tells you whether a shape is valid and, when it is not, the reason why.
SQL SERVER – Fix : Error 3623 – An invalid floating point operation occurred
Error 3623, an invalid floating point operation, shows up when a math function gets a bad value. I explain it with simple examples like SQRT(-5) and LOG(-9).
SQL SERVER – Powershell – Importing CSV File Into Database – Video
PowerShell expert Laerte Junior shows importing CSV file into database tables with PowerShell, with a video, building on my SQL in Sixty Seconds post.
XACT_ABORT: Why a Half-Done Transaction Can Survive an Error
Use XACT_ABORT to prevent partial writes, inspect transaction state after an error, and build a TRY CATCH pattern with reliable rollback.
SQL SERVER – Template Browser – A Very Important and Useful Feature of SSMS
Many people have never used Template Browser in SSMS. I give a quick introduction to this useful feature and the ready templates it offers for common tasks.