Sql Interview question #2 : What is a NOT NULL constraint?
Interview question #2 What is a NOT NULL constraint?
Monthly Archives: October 2014
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 […]
Sql Interview question #1 : What is a dirty read?
Question What is a dirty read?
Storing an IP address in a SQL Server database
Scenario proposal Often databases are used with web-based interfaces and recording the IP address of the end user can assist with debugging, marketing, bandwidth planning and collation selection to name a few. In a scenario where each page access is logged, is there an optimal way to store IP addresses? Solution This tutorial will work […]
SQL Server cursors: iterate through database
Scenario Proposal There are times when you need to loop through all the databases or database objects to perform some tasks. For example you want to run a DBCC command against all the databases or take backups of all the databases on the server or you want to rebuild all the indexes of all the […]
How to execute a TSQL batch several times using GO?
Scenario proposal Sometimes there is a need to execute the same command or set of commands over and over again. This may be to insert or update test data or it may be to put a load on your server for performance testing. Whatever the need the easiest way to do this is to setup […]
How to get exclusive access for restoring the SQL Server databases?
Scenario proposal A task that you may be faced with as a DBA is the need to refresh a test or development database on a periodic basis. This may be a scheduled process or it may be an ad hoc process. One of the things that you need to do when restoring a database is […]
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 […]