Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is a user-defined function in the sql server and what is its advantage?

0 Answers  


How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,


How to stop log file growing too big?

0 Answers  


I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,


Explain query editor regions

0 Answers  






What do you mean by acid?

0 Answers  


What types of integrity are enforced by a foreign-key constraint

1 Answers  


How to create a local temporary stored procedure?

0 Answers  


What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  


Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,


Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,


What is the sql profiler?

0 Answers  


Categories