Knowledge Share 2014-08

Number of Cores/ Processors on Windows Server:

Command to find the number of Cores on Windows Server

wmic cpu get NumberOfCores

Command to find number of Logical Processors

wmic cpu get NumberOfLogicalProcessors

* Free e-Books related to Microsoft Technologies

You can find huge collection @

SQL Server 2014 Adventure works Sample Database
You may find the sample database @

* Find all supported Collations of SQL Servers

select name, COLLATIONPROPERTY(name, 'CodePage') as Code_Page, description from sys.fn_HelpCollations()

* How to find the collation of a database or all columns of a given table

-- DB Collation
SELECT DATABASEPROPERTYEX('AdventureWorks2014', 'Collation')
select collation_name, * from sys.databases where name = 'AdventureWorks2014'
-- Table Collation
USE AdventureWorks2014 
SELECT name as ColumnName, collation_name
FROM sys.columns
FROM sys.objects
WHERE type = 'U'
AND name = 'DatabaseLog') -- Table Name
This entry was posted in Windows Server and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s