sql server dba interview questions pdf

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA).
It can be changed from the Network Utility TCP/IP properties.
Instead, the leaf nodes contain index rows.Use SQL Profiler to monitor only the events in which you are interested.View and annual report of sbi mutual fund 2012 save SQL server DBA questions answers asked in interview.Answer: select * from table1 select count from table1 select rows from sysindexes where id object_ID(table1) AND indid 2 Question.18 What does it mean to have"d_identifier ON?Answer: They specify a search condition for a group or zawgyi one font for windows 7 32 bit an aggregate.A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk.Delete: delete removes rows one at a time and records an entry in the transaction log for each deleted row.For example, you can monitor a production environment to see which stored procedures are hampering performances by executing too slowly.Because Transact-SQL supports recursion, you can write stored procedures that call themselves.Answer: Both primary key and unique key enforces bluetooth 4.0 specification pdf uniqueness of the column on which they are defined.The leaf node of a non clustered index does not consist of the data pages.SQL server DBA: A largest network place for mock interviews, faq's, overviews, web-references, questions and answers for SQL server DBA.Truncate removes all rows from a table, but the table structure, its columns, constraints, indexes and so on, remains.If traces are becoming too large, you can filter them based on the information you want, so that only a subset of the event data is collected.Question.8 When is the use of update_statistics command?