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

SQL – Download Database Cheat Sheet for MongoDB, NuoDB, MySQL for FREE

July 9, 2013

Database, NuoDB, SQL Documentation, SQL Download

In the new database world there are so many different solutions, vendors and options available that it is super hard to figure out which database is the right solution for us. First of all the world of the big data itself is very confusing. It is so hard to figure…

SQL – Difference between != and <> Operator used for NOT EQUAL TO Operation

July 8, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is interesting question received on my Facebook page. (On a side note, today we have crossed over 50,000 fans on SQLAuthority Facebook Fan Page). What is the difference between != and <>Operator in SQL Server as both of them works same for Not Equal To Operator? Very interesting question indeed.…

SQL SERVER – Check Database Level (IsNullConcat) and Session Level Settings (CONCAT_NULL_YIELDS_NULL) using T-SQL

July 7, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Earlier I wrote a blog post SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL and in follow up to the blog post, I received few questions. Let me try to answer those questions in following blog post. Q: How do we know if setting which returns NULL when concated to another NULL value is…

SQL SERVER – Weekly Series – Memory Lane – #036

July 6, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL

July 5, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Recently one of my friends sent me a SQL script to debug and I noticed that above all of his scripts he was executed following query. SET CONCAT_NULL_YIELDS_NULL OFF; This made me curious and I asked him reason why is he executes above script. He answered that when his application…

SQL SERVER – How to Refresh SSMS Intellisense Cache to Update Schema Changes

July 4, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Have you ever faced situation where you have just created or modified object but SSMS still shows the error. I quite often face this situation where I come across situation where my SSMS Intellisense Cache is not refreshed or updated. This is indeed very frustrating when you are presenting something…

Personal Technology – Excel Tip: Comparing Excel Files

July 2, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Excel, Personal Technology

This guest post is by Vinod Kumar. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Working on various versionsfrom SQL Server 7.0, Oracle 7.3 and other database technologies – he now works with the Microsoft Technology Center (MTC) as a Technology Architect. Let us read…