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
SQL Server Spatial object invalid due to overlapping edges.

SQL SERVER – Validating Spatial Object as NULL using IsNULL

June 30, 2012
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function

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.

Read More
SQL SERVER - Validating Spatial Object with IsValidDetailed Function

SQL SERVER – Validating Spatial Object with IsValidDetailed Function

June 29, 2012
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Scripts

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.

Read More
SQL SERVER - Fix : Error 3623 - An invalid floating point operation occurred

SQL SERVER – Fix : Error 3623 – An invalid floating point operation occurred

June 28, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

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).

Read More
SQL SERVER - Powershell - Importing CSV File Into Database - Video

SQL SERVER – Powershell – Importing CSV File Into Database – Video

June 27, 2012
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Scripts, SQL Server, SQL Utility

PowerShell expert Laerte Junior shows importing CSV file into database tables with PowerShell, with a video, building on my SQL in Sixty Seconds post.

Read More
A red high-jump bar hanging at a slant, one end still on its peg and the other on the landing mat

XACT_ABORT: Why a Half-Done Transaction Can Survive an Error

June 26, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Stored Procedure, SQL Transactions

Use XACT_ABORT to prevent partial writes, inspect transaction state after an error, and build a TRY CATCH pattern with reliable rollback.

Read More
Sample database creation.

SQL SERVER – Template Browser – A Very Important and Useful Feature of SSMS

June 25, 2012
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

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.

Read More
An open plain reference book has several colored fabric bookmarks beside a magnifying glass.

Finding the Right Answer in SQL Server Documentation

June 24, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Use SQL Server documentation with the right version and platform selected, read syntax carefully, and keep useful reference material offline.

Read More
SQL SERVER - Introduction to Function SIGN

SQL SERVER – Introduction to Function SIGN

June 23, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function

The SIGN function returns 1, -1 or 0 depending on whether a value is positive, negative or zero. A simple example with INT and DECIMAL values.

Read More
IDENTITY CL.

SQL SERVER – Follow up – Usage of $rowguid and $IDENTITY

June 22, 2012
Pinal Dave
SQL Tips and Tricks

A follow up with great comments from David Hall and Kumar Harsh on the usage of $rowguid and $IDENTITY, and the limits of my earlier solution.

Read More
SQL SERVER - ColumnStore Index - Batch Mode vs Row Mode

SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode

June 21, 2012
Pinal Dave
SQL Tips and Tricks
SQL Index

Someone said columnstore indexes run only in batch mode. I stopped to disagree. Here is what I showed about columnstore batch mode vs row mode.

Read More
Previous 1 … 373 374 375 376 377 378 379 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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