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 @ http://blogs.msdn.com/b/mssmallbiz/archive/2014/07/07/largest-collection-of-free-microsoft-ebooks-ever-including-windows-8-1-windows-8-windows-7-office-2013-office-365-office-2010-sharepoint-2013-dynamics-crm-powershell-exchange-server-lync-2013-system-center-azure-cloud-sql.aspx

SQL Server 2014 Adventure works Sample Database
You may find the sample database @ http://msftdbprodsamples.codeplex.com/releases/view/125550

* 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')
GO
 
select collation_name, * from sys.databases where name = 'AdventureWorks2014'
 
 
-- Table Collation
USE AdventureWorks2014 
 
SELECT name as ColumnName, collation_name
FROM sys.columns
WHERE OBJECT_ID IN (SELECT OBJECT_ID
FROM sys.objects
WHERE type = 'U'
AND name = 'DatabaseLog') -- Table Name
Advertisements
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:

WordPress.com Logo

You are commenting using your WordPress.com 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