wat is the main diff between sql server 2000and sql server 2005
Answer Posted / monal
ONLINE INDEX CREATION
ONLINE BACKUP (WHICH IS HOT BACKUP IN ORACLE)
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is sql collation?
Does table partitioning improve performance?
How you would rewrite the sql query to return the customerid sorted numerically?
What is change data capture (cdc) in sql server 2008?
What is an index in a database?
Detail about query optimizer?
How to insert and update data into a table with "insert" and "update" statements?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Explain the first normal form(1nf)?
What are group functions in query statements in ms sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
System variable and temporary variables
What is resource db in sql server?
What are the types of stored procedures in an sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?