Sql Server

Move SQL Server MDF and LDF Files location

by Naveed Ul-Haq

A lot of times we come across issues when our disk space is consumed and we need to move our database MDF & LDF files from their default location. In an earlier version of SQL Server, you have to use Detach and Attach method in… Read More »Move SQL Server MDF and LDF Files location

Compare dates in SQL

by Naveed Ul-Haq

A lot of times we come across issues comparing dates in SQL. There are a few scenarios below Compare dates in the DateTime Column Select * from EMP WHERE datetime_column >= ‘20221220 00:00:00.000’ AND datetime_column < ‘20221221 00:00:00.000’ Compare Day Year Month separately in DateTime… Read More »Compare dates in SQL