Reddit Reddit reviews T-SQL Querying (Developer Reference)

We found 4 Reddit comments about T-SQL Querying (Developer Reference). Here are the top ones, ranked by their Reddit score.

Computers & Technology
Books
SQL
Databases & Big Data
T-SQL Querying (Developer Reference)
Microsoft Press
Check price on Amazon

4 Reddit comments about T-SQL Querying (Developer Reference):

u/vornamemitd · 7 pointsr/SQL

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

u/beer_kimono · 3 pointsr/SQL

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.

u/muchcake · 2 pointsr/SQLServer

This is great, but a little dense as a beginner

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

u/Rehd · 1 pointr/SQLServer

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