-- 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
Tags » SQL Server
History has its own way to define now civilizations thrived. Most of the cities flourished in the river side and transporting lumber was one of the key activity. 698 more words
As part of their Incremental Service Modelling, Microsoft have released SQL Server 2012 Service Pack 2 Cumulative Update 1!
Whew, how’s that for a title?
Earlier today, I had the privilege of being invited to present my Every Byte Counts presentation, for the SQL PASS Perf. 279 more words
I’ve done two SQL Server webcasts for my friends at MSSQLTips.com. One is regarding security best practices for deploying SQL Server databases in the cloud. As more and more customers are thinking of deploying databases in the cloud, security is one of their main concerns. 105 more words
Collation refers to a set of rules that determines how your data is sorted and compared. It’s very often important with regards to internazionalization, e.g. how do you sort japanese kanji? 523 more words