Modern Data Warehousing Presentation

I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User...

T-SQL Tuesday #57 – SQL Family and Community

Look at that, it is once again that time of the month that has come to be known as TSQL Tuesday.  TSQL Tuesday is a recurring blog party that...

T-SQL Tuesday #57 – SQL Family and Community

Look at that, it is once again that time of the month that has come to be known as TSQL...

T-SQL Tuesday #57 – SQL Family and Community

Maybe it is just me, but these monthly block parties seem to be coming around quicker and quicker as time...

Snippet Alert: Useful dates (eom, bom, etc)

Common date values you may need to reference that you may not want to write from scratch each time.
Hope...

Generate Random Date With Starting Point

If you want to create sample random samples when dealing with date calculations to test your results, you can easily...

T-SQL Tuesday #57: SQL Family

This month’s T-SQL Tuesday topic is SQL Family and is brought to us by Jeffrey Verheul (b/t). It’s an amazing...

T-SQL Tuesday #57–SQL Family and Community

It’s T-SQL Tuesday time again. After missing two months with my sabbatical, I’m back.
The topic this month is hosted by...

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...

SUM() function in SQL Server

Sum():- This function is used to get the sum of values of the specified numeric column.

 Syntax:-

 Select Sum (column_name) from tablename

Example:-...