Tags » SQL Query

Difference between ISNULL and COALESCE (SQL Server)

Though ISNULL and COALESCE can be interchangeably used in common scenarios basic functionality of ISNULL and COALESCE are different.

ISNULL:
ISNULL Accepts 2 parameters, if the first parameter is NULL, second parameter value will be returned. 252 more words

SQL

SQL SERVER - Live Plans for Long Running Queries

If you are a SQL Server DBA or developer who is majorly dealing with queries which are running for a long time, you may have one request every time you see a long running query. 330 more words

SQL Authority

SQL Authority News - 3000th Blog Posts and Thank You

3000th Blog Posts! 

When I realized that I am writing my 3000th blog post (list of all of my blog posts), I just got blank with happiness. 411 more words

SQL Authority

SQL SERVER - CTRL + R Shortcut Does Not Work in SSMS

I just formatted my computer and installed fresh SQL Server 2014. The very first thing which I did was to open SQL Server Management Studio and execute a sample query. 196 more words

SQL Authority

TSQL to Rollup multiple rows into single row and column

In my team, we mange multiple Applications and Servers. As part of Application migrations, Server consolidations, failovers application Server mapping will always be changing. I always depend on Application Server mapping during analysis but my major challenge was with multiple rows for each app in traditional way. 419 more words

SQL