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 |
How to create a view with data from multiple tables?
how to count datewise data in sqlserver
4 Answers CarrizalSoft Technologies, IndusInd Bank,
How to provide default values to function parameters?
What are system databases into sql server (2005/2008) : sql server database administration
What is live lock and deadlock? what is Lock escalation?
How to stop a loop early with break statements in ms sql server?
what is difference between Enterprise Manager and Query Analyer
What happens if you are trying to access a schema not owned by you?
What do you understand by replication in sql server?
Do you know what is fill factor and pad index?
What is equi join with example?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?