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 are the types of indexes available with SQL Server?
What is an execution plan? When would you use it?
Write the SQL query to drop, truncate and delete table.
0 Answers HPCL, Hughes Systique Corporation, Ittiam Systems,
What are the different types of collation sensitivity?
What are orphan records?
Diffrence between DTS vs SSIS
Should you normalize audio?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are the results of running this script?
What is the difference between composite index and covering index?
What are the properties of sub-query?
What is stored in the mssqlsystemresource database? : sql server database administration