SQL Tips and Tricks Archives - Page 264 of 536 - SQL Authority with Pinal Dave

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

June 28, 2012

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…

SQL SERVER – Introduction to Function SIGN

June 23, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Yesterday I received an email from a friend asking how do SIGN function works. Well SIGN Function is very fundamental function. It will return the value 1, -1 or 0. If your value is negative it will return you negative -1 and if it is positive it will return you…

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

June 22, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

The most common question I often receive is why do I blog? The answer is even simpler – I blog because I get an extremely constructive comment and conversation from people like DHall and Kumar Harsh. Earlier this week, I shared a conversation between Madhivanan and myself regarding how to…

SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode

June 21, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

What do you do when you are in a hurry and hear someone say things which you do not agree or is wrong? Well, let me tell you what I do or what I recently did. I was walking by and heard someone mentioning “Columnstore Index are really great as…