vignesh.ms (12/23/2013)
Jeff Moden (12/21/2013)
bitbucket-25253 (12/21/2013)
In the left most column of a this page, as you read my response click on the word Stairways and you will be rewarded with a series of links that can/will teach you a great deal about SQL Server.Unfortunately, there's very little advanced stuff on T-SQL itself in those series. I'm actually disappointed in how little the bread'n'butter of SQL Server has been covered there.
I'm a newbie to the sql, so its some thing new to me even it may bread'n'butter to you..
I'm looking for something to study from you guys... the core is expectation is " Examples to train my mind to think in the T-SQL language".
If you have the basics down, then my recommendation would be to check out the following:
The Tally Table and How it Replaces a Loop
Tally OH! An Improved SQL 8K “CSV Splitter” Function
Splitting Strings Based on Patterns
These will change the way you look at data. They'll also change your expectations you have for performance. Enjoy!