SQL

Use below query to find all information for all database. SELECT Database_ID, CONVERT(VARCHAR(25), DB.Name) AS DBName,  CONVERT(VARCHAR(...

Sometime we may need to check the space required to execute CheckDB. We can run this query in live database because actually it is not runn...

Sometime you may receive an error in SQL Server's log and Database Mirroring stops: Database Mirroring login attempt by user ...

Ctrl + N key is used to open new query window in SQL Server. It is not working in SQL Server 2008. To enable this we have to c hange the k...

Xinwei Hong (MSFT) wrote a great troubleshooting guide on  how to identify and resolve SQL Server connectivity issues  on the  SQL Protocol...