SQL

Today someone has asked me a question "How to clear the Most Recently Used (MRU) server names from the connect screen in SSMS"?  ...

You can use below query to find out the queries that require a memory grant to execute or have acquired a memory grant.  The queries that ...

Use below query to check who are connected to SQL Server SELECT C.Session_ID AS [Session], C.Most_Recent_Session_ID [Recent Session], C.C...

Use below queries to find the location of of SQLServer Agent log file, the log file is called SQLAGENT.out DECLARE @AGENT_ERRORLOG NVARCH...

Frequent recompilation of execution plans Inaccurate statistics Excessive use or improper configuration of tempdb Excessive blocking a...