SQL

Use below query to find the weekend count between two dates: DECLARE @DateFrom DateTime, @DateTo DateTime, @Total int, @Number int, @Coun...

Sometime you want to identify the tables which could not reindex online. For this you had to scan all tables in SQL Server database and li...

I was trying to modify a table of approx 5 million records setting a field on the table to not allow null values. However, while saving cha...

You may receive below error while running third party application with backend SQL Server. Record Retrieval Error Error: (Connection Read...

Sometime you may get below error while attaching a database: Attach database failed for Server 'SERVERNAME\SQLEXPRESS'. (Microsof...