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

Round() function in SQL Server

Round():-This function is used to round a numeric field to the number of decimals specified.

Syntax:-

    ROUND ( numeric_expression , length [ ,function ]

numeric_expression...

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

SQL Server – Aborted Online Index Operation & Observed Elevated Values for PWAIT_MD_RELATION_CACHE and MD_LAZYCACHE_RWLOCK Wait Types

Last week on one of our production servers (version 2011.110.3373.0), we’ve encountered a strange issue which is relatively new (only...