Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

New to SQL Server 2008 Expand / Collapse
Author
Message
Posted Friday, August 17, 2012 12:53 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, October 6, 2014 6:14 AM
Points: 564, Visits: 888
Hi All,

I have worked in SQL 2000 and 2005 environment till now.
However my manager told me to take a new assignment in SQL server 2008.
I hope it should not be much challanging to start with.
However please guide me what are the areas I should start to look into.


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1346354
Posted Friday, August 17, 2012 1:01 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, June 27, 2014 4:17 AM
Points: 75, Visits: 443
Hi! Maybe, if you are familiar with 2005, it would be reasonable to start from here.
What's New (SQL Server 2008)



I am really sorry for my poor gramma. And I hope that value of my answers will outweigh the harm for your eyes.
Blog: http://somewheresomehow.ru
Twitter: @SomewereSomehow
Post #1346357
Posted Friday, August 17, 2012 1:44 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 10:53 PM
Points: 3,421, Visits: 5,359
From the T-SQL perspective IMHO, the MERGE statement, table value constructors (TVC) and grouping sets are probably what I'd consider the most interesting. Add to that maybe User-defined table types (for passing tables into SPs and FUNCTIONs) and spatial data if that's what floats your boat.

Using TVC there is a cool new way to UNPIVOT: http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

[/shameless-plug]



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1346375
Posted Friday, August 17, 2012 2:11 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
check out msdn for new additions in the 2008 ;the datatypes , filegroups , new keywords (MERGE,OUTPUT etc..)

for 2005 to 2008 you are good to go , for 2000 to 2008 not sure..


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1346387
Posted Friday, August 17, 2012 2:38 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 10:53 PM
Points: 3,421, Visits: 5,359
demonfox (8/17/2012)
check out msdn for new additions in the 2008 ;the datatypes , filegroups , new keywords (MERGE,OUTPUT etc..)

for 2005 to 2008 you are good to go , for 2000 to 2008 not sure..


The OUTPUT clause is a SQL 2005 feature:
http://msdn.microsoft.com/en-us/library/ms177564(v=sql.90).aspx



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1346394
Posted Friday, August 17, 2012 3:04 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, October 6, 2014 6:14 AM
Points: 564, Visits: 888
Thanks to all for your valuable input

--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1346408
Posted Friday, August 17, 2012 4:31 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:17 AM
Points: 13,867, Visits: 28,265
And don't forget spatial data. That's a huge bit of functionality introduced in 2008.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1346463
Posted Friday, August 17, 2012 8:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
dwain.c (8/17/2012)


The OUTPUT clause is a SQL 2005 feature:
http://msdn.microsoft.com/en-us/library/ms177564(v=sql.90).aspx


thanks dwain for correcting ...


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1346590
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse