What r the new Functions and Tips & tricks in Sql Server 2008

Question

What r the new Functions and Tips & tricks in Sql Server 2008

shashi kant

SSCommitted

Points: 1659
More actions
June 29, 2007 at 9:58 am

#175125

Hi folks ,
is there any one who work and test the sql server 2008 .
if yes then please give some tips and tricks of sql server 2008 and what new features have been introduced in sql server 2008.
GUI of 2005 and 2008 is almost same ,

if any one find new things in 2008 . please feel free for posting and contribute some thing in this

Regards
shashi kant chauhan

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

I don't think the GUI will tell you anything because most people don't know the index subsystem in SQL Server 2005 was all new, I have not installed it but a quick look at the docs posted at MSDN shows the SQL Server Nvarchar and the .NET Char are the same. That makes a big difference if your alphabet is not the Latin alphabet like Chinese, Japanese and Korean with more than two thousand characters. I also saw a new function GROUPING_ID that will be very useful if you are doing very complicated GROUPING that cannot be handled by the current supper aggregates. Swing by MSDN and run a search for SQL 100, that is the number of the 2008 tabular data stream protocol. Hope this helps.

http://msdn2.microsoft.com/en-us/library/bb510624(SQL.100).aspx

Kind regards,
Gift Peddie

Joel Ewald SSCertifiable Points: 6120 More actions · Answer 2

So far I have only looked at a few new things.

The ability to pass a table valued parameter to a stored procedure by declaring a type. I am not sure how to call one of these procedures from .net yet however.

the MERGE feature to analyze two datasets and perform update, insert, delete functions on one of them.

I briefly looked at the policy functionality.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

http://www.sqlservercentral.com/columnists/sjones/3044.asp

Got a second part coming as well.

olivierb_@hotmail.com Grasshopper Points: 11 More actions · Answer 4

Microsoft is giving a free online training about the new features of Katmai, you can find it there : https://www.microsoftelearning.com/eLearning/courseDetail.aspx?courseId=78337

JP-317675 SSC Eights! Points: 985 More actions · Answer 5

Is there changes to the INSERT statement in SS2K8? I would like to be able to specify the value to be inserted into a column next to its definition in the INSERT statement.

Eg. The way it is now...

INSERT INTO Table_One

(column_A,

column_B)

SELECT

t2.column_1

t2.column_2

FROM Table_Two as t2

I'd like to be able to do it like this...

INSERT INTO Table_One

(column_A = t2.column_1,

column_B = t2.column_2)

FROM Table_Two AS t2

I would find something like this much easier to read in code as it will be easy to see which values are being inserted into which columns side by side. It will also prevent having a long list of columns followed by a comparatively long select statement. Not sure what others think of such a feature but I would use it a lot if it was available.

-- JP

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 6

I'd hope such changes would come to the SQL Standard first . Including the above syntactic sugar in TSQL would probably confuse more than help. But it is an interesting idea.

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

JeremyE SSCoach Points: 16199 More actions · Answer 7

Sign up for the CTP and you can check out 2008 for yourself.

https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395