Contents tagged with cores

• SQL Server Get Product Version and CPU Cores

  Tags: sql server, product, version, cpu, cores

  Sunday, June 30, 2019 1:46:06 AM

  No Comments

  SELECT @@SERVERNAME AS SQLServerName, CASE SUBSTRING(CONVERT(NVARCHAR(20),SERVERPROPERTY('ProductVersion')),1,4) WHEN '15.0' THEN 'SQL Server 2019' WHEN '14.0' THEN 'SQL Server 2017' WHEN '13.0' … more