RTRIM() function in SQL Server

RTRIM():-This function is used to get the string after the removal of all trailing blanks.

Syntax:-

RTRIM ( character_expression )

For example:-

Select RTRIM('Vivek Johari ...

Say Thank You

I was approached by a man at SQL Bits who only wanted to thank me for blogging. He said, “I...

SQL Server for VM Admins vBrownBag Webinar

Next Wednesday, August 20th, at 7:30pm Central I will be presenting a webinar for the Professional VMware #vBrownBag entitled “SQL...

Tableau Conference Is Bigger Than PASS Summit

I was reading http://paultebraak.wordpress.com/2014/08/11/the-wisdom-of-the-tableau-crowd/ and, no disrespect intended at all to the Tableau universe,  I was astounded to see that...

The Murder Train chugs into Denver!

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...

T-SQL Tuesday #57: SQL Family and Community

Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. T-SQL Tuesday… that...

Writing Parametrized MDX for Reporting Services

Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long.  If all...

Deny vs Revoke

Quick quiz. Which of these two commands is the opposite of GRANT?
DENYREVOKE 

Well lets start with some definitions
GRANT – Grants permissions on...

Except command in SQL Server

This function returns the distinct values from the left query that are not also found on the right query. For...

Experts Perspective Webcast: Wait Watchers – Gain Performance Increases Fast

Following in the footsteps of such greats community leaders as Brent Ozar and Kevin Kline I have the opportunity, nay...