what is Difference betwwen sql server 2005 and sql server 2008

Question

1.00/5 (2 votes)

See more:

SQL

server

what is Difference betwwen sql server 2005 and sql server 2008

any one help me

Posted 26-Aug-10 23:35pm

Ganesh_verma

Add a Solution

Comments

Dholakiya Ankit 3-Oct-13 3:32am

Ganesh you still not found answer?

Ankur^\m/ 27-Aug-10 5:58am

Wow, 4 questions on your name on the very first page and all of them can be easily Googled. Moreover, you have never accepted or up-voted any answers. :|

Christian Graus 27-Aug-10 6:00am

Try 5. Some people are unbelievable.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2010-08-26T23:36:00

Solution 1

Google broken where you live ? Why are you flooding this site with easily googled questions ?

Posted 26-Aug-10 23:36pm

Christian Graus

#realJSOP · Answer 2 · 2010-08-26T23:48:00

Solution 2

You can get a much more complete answer by using google to find the answer. If you google this phrase:

"difference between sql server 2005 and sql server 2008"

The first two results returned will probably give you all the answers you require.

Posted 26-Aug-10 23:48pm

#realJSOP

senguptaamlan · Answer 3 · 2010-08-27T20:40:00

Solution 3

Making the things a bit easier....

http://lmgtfy.com/?q=difference+between+sql+server+2005+and+sql+server+2008[^]

simple isn't :cool:

If it makes the required answer...please mark this post as answer

Posted 27-Aug-10 20:40pm

senguptaamlan

Updated 27-Aug-10 20:41pm

v2

Achuki Bhalotia · Answer 4 · 2011-07-11T23:52:00

Tools Enhancements:

SQL Server Management Studio has the following improvements:

· In the Query Editor window, you can query multiple servers at the same time by opening query windows from registered server groups. The query results can be combined into a single results pane, or can be returned in separate results panes.

· You can access SQL Server Profiler from the Query Editor window, from the Query menu, the Query Editor toolbar, or by pressing CTRL+ALT+P.

· You can now open tables by using a Return Top n rows option.

· On the Tools/Option menu, you can specify the action that results by double-clicking tables in Object Explorer.

Transact-SQL Enhancements:

· Lock Escalation Option - A new LOCK_ESCALATION option of ALTER TABLE allows you to disable lock escalation on a table.

· Query Hints - Table hints can now be specified as query hints to provide advanced query performance tuning options.

· Hierarchyid Data Type - SQL Server 2008 introduces a new system-provided data type to encapsulate hierarchical relationships.

· User-Defined Table Type - The Database Engine introduces a new user-defined table type that supports representing table structures for use as parameters in stored procedures and functions, or in a batch or the body of a stored procedure or function.

· Compatibility Level - ALTER DATABASE SET COMPATIBILITY_LEVEL replaces sp_dbcmptlevel for setting the database compatibility level.

· GROUPING SETS - The GROUPING SETS, ROLLUP, and CUBE operators are added to the GROUP BY clause.

· Table Hints - The FORCESEEK table hint is added to provide advanced query performance tuning options.

· Transact-SQL Row Constructors - Transact-SQL is enhanced to allow multiple value inserts within a single INSERT statement.