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

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

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

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

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

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

Best practices for Database Programming

1. All the tables in the database have properly defined relationship using primary keys and foreign keys . 

2. Indexes should...

Between function in SQL Server

This function is used to select the values within a specified range. These values can be of Int type or...