Daily Archives: 10/23/2014

Sql Interview question #8 : What is collation?

This entry was posted in Sql Server 2005 Sql Server 2008 Sql Server DBA Sql Server DEV Sql Server Development Sql Server Interview Questions Sql Server tutorials and tagged collation server sql on by .

Sql Server Interview question #8 What is collation? Solution Collation refers to a set of rules that determines how data is sorted and compared. Character data is sorted using rules that define the correct character sequence with options for specifying case sensitivity, accent marks, Kana character types, and character width.   Thanks for reading this […]

How can I clear the SQL Server query cache?

This entry was posted in Sql Server DEV Sql Server tutorials and tagged cache clear example join performance testing server sql sql server on by .

Scenario When conducting performance testing and tuning on a new system, most of the time a number of options are outlined to potentially correct the performance problem.  To determine the best overall solution, each option is tested and the results are recorded.  As lessons are learned options may be combine for a better end result […]