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 |
What is msdb database? : SQL Server Architecture
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)
Explain what are the authentication modes in sql server?
How do you run a trace?
What are the different sql server versions?
What stored by the tempdb ? : sql server database administration
What is sql server used for?
Explain about thread and memory management process of SQL?
explain what is raid and what are different types of raid configurations? : Sql server database administration
What are the differences between lost updates and uncommitted dependencies?
explain different levels of normalization? : Sql server database administration
What are the High-Availability solutions in SQL Server and differentiate them briefly?
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)