Reddit mentions of T-SQL Querying (Developer Reference)

Assuming MSSQL, two quick book tips:

https://www.amazon.de/T-SQL-Querying-Developer-Reference-Paperback/dp/0735685045

https://www.microsoftpressstore.com/store/t-sql-window-functions-for-data-analysis-and-beyond-9780135861448

Your code doesn't sound that bad. I once updated a series of reports (ie, vendor report, services report, etc.) that the previous guy made internally consistent by re-running the entire original base report (including select) in every other report because they were timing out. I honestly still wasn't too mad at him because he'd turned it from a 20+ step access db job into reports through SSRS.

I would focus on what you've identified.

For grouping, go through hackerrank's aggregation - https://www.hackerrank.com/domains/sql?filters%5Bsubdomains%5D%5B%5D=aggregation and/or Itzik Ben-Gan's TSQL Querying books chapter on grouping.

Having is a filter (where clause) that's applied after the data is grouped. You might group together orders by customer and filter out customers whose max order-date is more than a year ago. Most of my aggregate or grouped queries don't have a 'having' clause.

For performance, I you might look at some of your longest running reports and re-factor them using the execution plan, etc. Itzik's https://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ has a chapter on query tuning. I'm not personally great at it because I don't use it a lot.

This is great, but a little dense as a beginner

T-SQL Querying (Developer Reference (Paperback)) https://www.amazon.co.uk/dp/0735685045/

My blog is advertised on my stack overflow account and github, all three are circular and refer to each other. I've kept my reddit account separate on purpose for identifiable reasons.

I'm still toying with the idea of posting occasional blog posts or creating a reddit account to link to my other social medias to help build a base. At the moment, the blog is really intended for employers and myself and it is not based on trying to accumulate or direct web traffic.

So while I'm happy to share my information, I don't want to link it from this account.

> It's incredibly generous and secure of you to actually share your notes and progress.

The notes are usually pretty barebones. Here's an example of the kind of information in my google sheet:

5/22/18

• Read SQL Server Pro Internals
  
  • PG 200-240
    
• Worked on Stairway to XML Series on SQL Central
  
  • Stairways 3 and 4
    
    5/23/18
    
• Read Exam Ref 70-762 Developing SQL Databases
  
  • PG 300-324 (Need to find additional articles on temporal tables.)
    
• Temporal Database practice
  
  • 40 minutes in World Wide Importers
    
    Then if I have done any work / notations, I add them to a folder and upload them to my github.
    
    If you are interested in other examples of how I did things, let me know specifically and I can get you a scrubbed / masked version. Here's my list of recommended resources that appears in my 762 study guide though:
    
    Exam 70-762
    
    Exam policies and FAQ
    
    Course 20762B: Developing SQL Databases
    
    https://www.mssqltips.com/sqlservertip/4690/study-materials-for-developing-sql-databases-exam-70762/
    
    https://www.amazon.com/T-SQL-Fundamentals-3rd-Itzik-Ben-Gan/dp/150930200X
    
    https://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ref=pd_lpo_sbs_14_t_0/138-3143892-2208566?_encoding=UTF8&psc=1&refRID=E5CA9HQ5WEXP7RPBE1B1
    
    https://www.amazon.com/Pro-Server-Internals-Dmitri-Korotkevitch/dp/1484219635/ref=sr_1_1?s=books&ie=UTF8&qid=1520887778&sr=1-1&keywords=sql+server+internal+pro