SQL Server Archives - Page 143 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Discard Results After Query Execution – SSMS

July 1, 2012

The first thing I do any day is to turn on the computer. Today I woke up and as soon as I turned on the computer I saw a chat message from a friend. He was a bit confused and wanted me to help him. Just as usual I am keeping…

SQL SERVER – Validating Spatial Object as NULL using IsNULL

June 30, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Spatial Database, SQL Function, SQL Spatial

Follow up questions are the most fun part of writing a blog post. Earlier I wrote about SQL SERVER – Validating Spatial Object with IsValidDetailed Function and today I received a follow up question on the same subject. The question was mainly about how NULL is handled by spatial functions. Well, NULL is…

SQL SERVER – Validating Spatial Object with IsValidDetailed Function

June 29, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Spatial Database, SQL Scripts, SQL Spatial

What do you prefer – error or warning indicating error may happen with the reason for the error. While writing the previous statement I remember the movie “Minory Report”. This blog post is not about minority report but I will still cover the concept in a single statement “Let us…

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

June 28, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Going back in time, I always had a problem with mathematics. It was a great subject and I loved it a lot but I only mastered it after practices a lot. I learned that mathematics problems should be addressed systematically and being verbose is not a trick, I learned to solve…

SQL SERVER – Weekend Project – Experimenting with ACID Transactions, SQL Compliant, Elastically Scalable Database

June 26, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB, SQL Documentation, SQL Download

Database technology is huge and big world. I like to explore always beyond what I know and share the learning. Weekend is the best time when I sit around download random software on my machine which I like to call as a lab machine (it is a pretty old laptop,…

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

June 25, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Let me start today’s blog post with a direction question. How many of you have ever used Template Browser? Template Browser is a very important and useful feature of SQL Server Management Studio (SSMS). Every time when I am talking about SQL Server there is always someone comes up with the…

SQL SERVER – Download SQL Server Product Documentation

June 24, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Today I just returned from Bangalore User Group Meeting. Attending User Group meeting is indeed fun and really great experience. The best part of the User Group is meeting like minded people and have a great conversation with them. During the meeting I was asked why one has to go…