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 the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?
How to generate create table script on an existing table in ms sql server?
What does top operator do?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What happens if strings are casted into wrong code pages in ms sql server?
What are the difference between clustered and a non-clustered index?
Do you know what is fill factor and pad index?
What is the purpose of the master database?
How are SQL Server databases physically stored under Windows 2000?
How to concatenate two strings in SQL Server.
Explain the basic concepts of SQL server architecture?
2 Answers College School Exams Tests,
Give an example of why you would want to denormalize a database
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)