Answer Posted / srinivas
Index is a database object which improves the efficiency of
the query
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How to verify the port number of the sql server?
How do you troubleshoot errors in a SQL Server Agent Job?
What the different components of Replication and what is their use?
Explain how to integrate the ssrs reports in application?
What is user defined stored procedures?
What is updatable resultset?
What is the difference between lock, block and deadlock? : sql server database administration
What are the different types of triggers in SQL SERVER?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is the boxing and unboxing concept in .net?
Where actually sql azure database is hosted?
What is similarity and difference between truncate and delete in sql?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?