DIFFERENCE BETWEEN SQL SERVER 2005 and 2008
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 system functions or built-in functions? What are different types of system functions?
What do you do in data exploration
How to list all stored procedures in the current database using ms sql server?
Define the one-to-one relationship while designing tables.
Security Question- SQL DBA exparts, need your help...
Explain insert into select statement?
What are the types of containers in ssis?
What is a non clustered primary key?
What is difference between inner join and full join?
Explain data warehousing in sql server?
What is the difference between function and stored procedure in sql server?
When do you think a developer should use sql server-based cursors?
Oracle (3253)
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)