|
Related Questions |
View Answer |
|
What is job?
|
View Answer
|
|
How do we upgrade SQL Server 7.0 to 2000?
|
View Answer
|
|
Explain features of SQL Server like Scalability , Availability, Integration with Internet.
|
View Answer
|
|
What is de-normalization? When do you do it and how?
|
View Answer
|
|
Explain differences between Server.Transfer and server.execute method?
|
View Answer
|
|
What is indexing?
|
View Answer
|
|
What is referential integrity and how can we achieve it?
|
View Answer
|
|
How do you use DBCC statements to monitor various ASPects of a SQL Server installation?
|
View Answer
|
|
What is the purpose of UPDATE STATISTICS?
|
View Answer
|
|
What are cursors? Name four type of cursors and when each one would be applied?
|
View Answer
|
|
What is the difference between a Local temporary table and a Global temporary table? How is each one used?
|
View Answer
|
|
What does it mean to have quoted_identifier on? What are the implications of having it off?
|
View Answer
|
|
What is the STUFF function and how does it differ from the REPLACE function?
|
View Answer
|
|
What is an execution plan? When would you use it? How would you view the execution plan?
|
View Answer
|
|
What is an execution plan? When would you use it? How would you view the execution plan?
|
View Answer
|
|
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that “a query that ran yesterday took 30 seconds, but today it takes 6 minutes”?
|
View Answer
|
|
What is the purpose of using COLLATE in a query?
|
View Answer
|
|
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table.
|
View Answer
|
|
What are the types of cookies are there?
|
View Answer
|
|
How many types of cookies are there?
|
View Answer
|