The basics: collation is a set of rules governing the use for characters in a language or in an alhabet.
In SQL Server we have Collation on several different levels:
SQL Server level – every time an instance is installed, a collation setting must be specified; the default one is selected from the Windows OS collation setting, but
Continue reading […] Collation concept: SQL Server, database, column […]
As a further reading after the performance tuning in shared secure environment, I am posting a list of SQL Server perfmon counters which take ‘database name’ as a delimiting parameter.
Number of active update transactions for the database.
Read/write throughput for backup/restore of a database.
Continue reading […] ‘Database name’ as a delimiting factor for SQL Server perfmon counters […]