September 4, 2018 at 7:30 pm
1. there's the Stairway series on here.
2. Itzik's T-SQL Fundamentals and T-SQL Querying
Anything else I should read? I'm thinking a good bit on how data gets retrieved (so indexing).
I used Jonathan Kehayis's (I think) code to "explode" AdventureWorks, so if I write a really bad query, it takes forever to execute. (I know, it's a case of baselining, which I should definitely practice).
I'm tempted to read some of the Querying book on certification only to be sure that I cover everything. (Yeah, I have some old certs, and I think they're not worth the paper they're printed on)..
November 14, 2018 at 9:50 am
That's where I'd start. The stairway gets you moving. Itzik's book is great. From there you could look at the Hi Performance SQL Server book and the T-SQL Recipes books, but if you get through Itzik's book, you'll have a better idea of how things work and where you might want to focus your efforts at that time.
We have some T-SQL Challenges here that let you practice as well.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply