Interested to Buy Any Domain ? << Click Here >> for more details...
DIFFERENCE BETWEEN SQL SERVER 2005 and 2008
- 2 Answers
- 5457 Views
- ADP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rohit bhosale
Sql SErver 2008 exist with a highly available concepts that
are helpful to provide data security or protection,to
improve performance while SQL Server 2005 is lack of these
concepts hence We all are preferable to use 2008.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / dinesh rathod
1, XML datatype is introduced. XML datatype is used. 2, Can not encrypt the entire database.
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How many columns can we include on clustered index ?
Explain an incremental backup?
How would you choose between a clustered and a non-clustered index?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
Explain steps of normalization?
Diffrences between sql server 2000 vs 2005
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
Do you know the cursor types?
How many categories of functions based their return modes?
Explain the usage of floor function in sql server.
What is default constraint?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
