Sql Interview Question #6: What are pessimistic and optimistic locks?
Sql Interview Question What are pessimistic and optimistic locks?
Monthly Archives: October 2014
Automatic database restore using DateTime functions in SQL Server
Scenario I have to restore a production database to a development database on a weekly basis in order to refresh the environment. Currently, I’m doing this process manually. Is there any way to script this out so it can be automated? Check out this tip to learn more. Solution If you take full backups […]
Sql Interview Question #5: What is OLTP (Online Transaction Processing)?
Sql Interview Question What is OLTP (Online Transaction Processing)?
Complex search queries in SQL Server
Scenario Just like every other company, we need to have our queries run as fast as possible for our users to have the best experience possible with our application. One of the core components of our application is to search across a number of columns in a table. We have been trying to accomplish this […]
Sql Interview Question #4: What is the difference between an update lock and exclusive lock?
Sql Interview Question What is the difference between an update lock and exclusive lock?
SQL Server FREETEXT command of expanded search
Scenario I have been reading about the Full Text Search capabilities in SQL Server 2005 and your tips have been a big help to improve how we query our data. Thus far converting our core queries to leverage Full Text Search has been a big help. I have been seeing information about the FREETEXT command […]
Sql Interview Question #3: What are different types of collation sensitivity?
Sql Interview Question What are different types of collation sensitivity? Solution
Synonyms in SQL Server 2005 (benefits and limitations)
Scenario I faced a situation where archived tables were created in the production database and now there was a requirement to move them as the database was growing. These archival tables were being used by several jobs and also in the application code. Moving them was demanding and also a very complicated process. I wanted […]
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 […]
Testing options in SQL Server 2005 and 2000
Scenario Testing database applications for many organizations is a challenging task that is difficult to setup, automate and validate. Luckily, more time is getting allocated into development projects to conduct more rigorous testing. In this tip we will outline some of the realities to perform SQL Server 2000 and 2005 testing and opportunities to streamline […]