Tag Archives: how to find SQL Server edition

Executing DBCC FREEPROCCACHE with parameters

DBCC FREEPROCCACHE, is used to clear all plan cache, which forces that every stored procedure will be recompiled  on it’s first execution to build a execution plan. This was known fact, till SQL Server 2005, DBCC FREEPROCCACHE has a server wide scope, means we can not clear a specific plan, this limitation was removed in [...]

How to identify your SQL Server version and edition even if SQL Services are not running

I was being called in a mid of a upgrade project from SQL Server 2005 to SQL Server 2008. The assigned DBA resource has gathered all the information related to SQL Server. SQL Services were stooped so that cold backup of files can be performed at file level. So SQL services were taken down and [...]