Monthly Archives: October 2014

Location of full text temporary folder in SQL Server

This entry was posted in Sql Server DBA Sql Server DEV Sql Server tutorials and tagged folder location server sql temporary on by .

Scenario The process of creating, building, and maintaining full-text search capabilities is quite a daunting task. During the installation of Full-Text Search for SQL Server 2000, one of the folders gets installed in a not-so-conspicuous location that could potentially be troublesome as the server gets busier. To get a good start on building and maintaining […]

How do you check collation and compatibility level for a database?

This entry was posted in Sql Server DBA Sql Server tutorials and tagged collation compatibility database server sql on by .

Scenario There is a common practice in the DBA world to work on a daily basis with back-ups and restoring of databases on different servers with different configurations. In an ideal world you would have the same collation and the same compatibility level on all your machines but for cases when this doesn’t happen here’s […]

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 […]

How to drop and recreate SQL Server foreign keys?

This entry was posted in Sql Server DEV Sql Server tutorials and tagged drop foreign keys recreate server sql on by .

Scenario You may have been in a scenario where you needed to quickly generate a script to drop and then subsequently re-create all of the foreign keys in a database (or in a specific schema, or matching a specific naming scheme). In some situations you can simply disable and re-enable the constraints, which isn’t all […]