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 should we do to copy the tables, schema and views from one SQL Server to another?
What is the difference between UNIQUE and DISTINCT keywords in DBMS?
How to create a local temporary stored procedure?
What are out-of-range errors with date and time literals?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
When you first load SQL SERVER you will startup with what all databases?
How to enable tcp/ip protocol on a sql server?
what is the use of database index(apart from the last searching of records) and what is the use of composite key?
What is the query optimization statistics?
What do you think of this implementation? Can this be implemented better?
What is an sql server agent?
What are truncate options available in sql server? : sql server database administration