Scenario Proposal One of my many day to day duties includes administering a database (actually many databases) for a Human Resources application. This application uses SQL logins for data access. This is a database I inherited so I had no input on how things were setup or administered. In the past the application administrator used […]
Sql Server Interview Question: What are the authentication modes in SQL Server? How can we change them?
Sql Server Interview Question: What are the different types of Collation Sensitivity?
Sql Interview question #11 Which TCP/IP port does SQL Server run on? How can it be changed?
Sql Interview Question #10 What is a DEFAULT definition?
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 […]
Sql Inteview Question #10 What are catalog views? Solution
Solution The delete command removes the rows from a table on the basis of the condition that we provide a WHERE clause. Truncate will actually remove all of the rows from a table, and there will be no data in the table after we run the truncate command.
Sql Server Interview Question #9 What is new in lock escalation in SQL Server 2008?
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 […]