In order to get or check top running queries and cpu consumption by tables, run below script : SELECT TOP 50 [Average CPU used] =...

Many DBA’s aren’t very familiar with DBCC commands because they don’t always have the hands on chance to work with them. The T-SQL...

The Server Collation acts as the default collation for all the system databases on that instance of SQL Server and also for the newly...