SQL

Sometime it is needed to get the start and end date of fortnight. Use below query to get the result: DECLARE @DateInput DATETIME SET @...

Today I was working on a query for a web application, I noticed that the query which executes within a second in Management Studio, was tak...

Use below function to get the First day of week CREATE FUNCTION Week1stDay (@DateInput DateTime) -- Add the parameters for the function...

Query to change the schema / Owner of database objects like  EXEC sys.sp_changeobjectowner <Object Name>, <New Owner Name> ...

There are many reason for not shrinking of Transaction log. Our production database backup was failing for last several weeks, so the backu...