Solved

MS SQL2008 T-SQL

Posted on 2013-12-02
5
211 Views
Last Modified: 2013-12-04
Hi,

can someone point me to a web link/resource for quickly brushing up on T-SQL for MS 2008?

Points to  be awarded for the quickest and best explanatory link.
thx
0
Comment
Question by:LuckyLucks
  • 3
5 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 39690547
Curiosity overwhelms me ... why 'quickly' brush up on T-SQL?   T-SQL covers a large area, so there's nothing quick about it.

Inside SQL Server 2008 T-SQL Querying by Itzik Ben-Gan is one of the best books out there,
0
 

Author Comment

by:LuckyLucks
ID: 39690556
Done T-SQL in Ms 2003 and now need to review it for 2008 after 7-8 years...
0
 
LVL 9

Expert Comment

by:BlueYonder
ID: 39690565
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 39690580
T-SQL is based on a version of SQL Server, and there was never a SQL Server 2003, so what do you mean by the above statement?

If all you're looking for is a 'what changed between <older version> and 2008, then the MS Press study guide for 2008 isn't a bad place to start, if you're going to be doing a lot of development.

If you're not going to be doing a lot of development, no idea, maybe there's a dummies book out there..
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 39690585
BlueYonder - Did you do any research before posting the above blind link?  The current home page shows 'SQL SERVER – Location of Statistics Before and After Database is Marked as a Read-Only', which has nothing to do with the question.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server R2 Stored procedure performance 8 42
backups - Strategies 1 21
CROSS APPLY 4 43
Upgrading an old legacy SQL server 20082 to 2014 - TSQL compatibility 3 35
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now