Answer Posted / visala
sp_help <tablename>
sp_helpindex <tablename>
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is the purpose of sql profiler in sql server? : sql server database administration
What is the fillfactor concept in indexes?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is checkpoint process in the sql server?
Tell me when is the update_statistics command used?
how to take backup bcp out for a column in table in sql server?
How to access the deleted record of an event?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is the maximum rows in sql server table?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What is data source in connection string?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
Explain the stored procedure?
how we use window authentication connection with sql server.?
What are click through reports?
