Category Archives : Sql Server DBA

Sql Server DBA

Location of full text temporary folder in SQL Server

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?

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?

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

Downgrading a SQL Server database to a lower version

Scenario proposal After recently upgrading a SQL Server instance to SQL Server 2012 a few days ago, you noticed that your application is not functioning properly. You decided to roll back the upgrade by downgrading the SQL Server database engine to SQL Server 2008 R2.  After the downgrade of the database engine, you are unable […]

How to disable indexes in SQL Server 2005 and 2008?

Scenario proposal While looking through the new features in SQL Server 2005 and SQL Server 2008 we found a potentially interesting one called Disabling Indexes, which can be used to disable indexes on a table or a view. Can you give us a detailed explanation of how we go about using this new feature along […]

How to change the Sql Server backup folder?

Scenario proposal When you install SQL Server the path for the installation is generally something such as the following: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQL.  In this directory there are also folders for your DATA files and also your BACKUP files.  Within SQL Server Management Studio you have the ability to change the default location for your […]