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

Speaking In Kansas City At #SQLSatKC

On Saturday, September 13th, I’ll be presenting my 10 Ways To Abuse T-SQL session in Kansas City. If you haven’t...

SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE

Error : Database backup is getting fail with below reason. The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is not online. Check errorlog file for the...