Answer Posted / visala
sp_help <tablename>
sp_helpindex <tablename>
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
Is INSTEAD OF trigger directly applicable to Table ?
How to write a query with a left outer join in ms sql server?
How does using a separate hard drive for several database objects improves performance right away?
What are pessimistic lock and optimistic lock?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What are the components of sql server service broker?
What is the syntax to execute the sys.dm_db_missing_index_details?
How to handle error or exception in sql?
How to override dml statements with triggers?
Explain something about security and SQL Azure?
What is the optimization being performed in oracle and SQL Server?
What is the difference between delete and truncate statements?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is faster join or union?
Define left outer join?