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 specify the collation for a character data type in ms sql server?
Tell me what is difference between clustered and non clustered index?
Difference between DELETE and TRUNCATE?
Explain the dirty pages?
What will you do If the low Performance occurs?
How do you use a subquery to find records that exist in one table and do not exist in another?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is the Difference beween sql server 2005 and sql server 2008
What Are Three Rules to UseĀ UNION IN SQL SERVER
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What are the differences between UNION and JOINS?
3 Answers CarrizalSoft Technologies,
Do you know what are various aggregate functions that are available?
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)