There are quite a few occasions where we require writing logic based on day comparisons from a date value. Some of the common scenarios include Counting days elapsed between two dates excluding weekends Getting the Thursday (or any other day) of…
Retrieve the filtered indexes on a db
Filtered indexes were introduced from SQL Server 2008 . Its a special type of Non Clustered index with a filter applied. This comes particularly handy in cases where we’e interested in only some subsets of data more frequently in a…
Floating point formats in SQL Server
The impetus for this post is a recent discussion we had in one of the forums with my fellow MVP friend.To start off, run the below query in management studio editor and check the output SELECT ‘2d5’ + 2e6 +…