What is full form of XP ?
Answer Posted / atul patil
Fllform of 'XP' is extended procedure
......................Atul
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the purpose of indexing?
Is the log file is a part of file group?
Define inner join in sql server joins?
What is the latest version of microsoft sql server?
User wants only to display only pdf as export option in report manager. How to achieve this?
What is 3nf normalization?
Explain “@@rowcount” and “@@error” in sql server?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Does the order of columns in update statements matter?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is a data collection table?
What are sql server functions?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How can you start sql server in different modes?
What is the use of tempdb? What values does it hold?