SQL

I had got below error in my friend's system: A connection was successfully established with the server, but then an error occurred du...

Sometime when you create a new database by using CREATE Database statement in SSMS (SQL Server Management Studio), you may got below error ...

Use below query to get the list of databases modified in last 'X' days: USE <database_Name>;  GO  SELECT Name AS object_N...

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