May 14, 2013 at 1:17 am
Hi steve,
this is just suggestion for consideration.
I have used this blog a lot and i read lot of good answers from various experts. When new person starts in our team i advise them to visit this blog and see how people reply to query with various answers.
How about if we create sharing the code or good practice section on this website?
I saw some video on youtube from Pinal dave around performance tuning which was very useful so i could share the link and give positive feedback about the video.
I recently wrote the script to dynamically pivot the table which i can share by creating sample table. We can create section in sharing good practice like T-SQL Code, Tuning, Index etc.
When user share the t-sql code they can write the subject in a way that any one can search in google like Converting row to column dynamically or performance tuning tips or index.
This kind of section will be very useful for some one new to get started with sql by reading all of this material and going to the link via the answers.
thanks.
May 14, 2013 at 8:24 am
This sounds a lot like the scripts section that already exists. It is over there on the left right under the Forums link.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 14, 2013 at 8:41 am
Are you asking if there could be a place where people submit links to content on other sites that could be helpful?
May 14, 2013 at 9:05 am
yes steve, that could be part of this section. As per example there are many videos on youtube about performance tuning and one by pinal dave was excellent. it was very easy to understand and many sql developers would learn something from that video.
May 14, 2013 at 9:33 am
We'll talk about it.
The hard part is categorizing and finding this info. We do include a number of these items in Database Weekly each week, with links to content that we think is of interest to database professionals.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply