Expert T-SQL Window Functions in SQL Server - Kathi Kellenberger, Clayton Groom
- Dodał: administrator
- Data: 14:32 12-11-2018
- Kategoria: Informatyka i matematyka
Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. First introduced in SQL Server 2005, window functions came into full blossom with SQL Server 2012. They truly are one of the most notable developments in SQL in a decade, and every developer and DBA can benefit from their expressive power in solving day-to-day business problems. Begin using windowing functions like ROW_NUMBER and LAG, and you will discover more ways to use them every day. You will approach SQL Server queries in a different way, thinking about sets of data instead of individual rows. Your queries will run faster, they will be easier to write, and they will be easier to deconstruct and maintain and enhance in the future. Just knowing and using these functions is not enough. You also need to understand how to tune the queries. Expert T-SQL Window Functions in SQL Server explains clearly how to get the best performance. The book also covers the rare cases when older techniques are the best bet. Stop using cursors and self-joins to solve complicated queries. Become a T-SQL expert by mastering windowing functions. źródło opisu: http://www.apress.com/9781484211045?gtmf=s źródło okładki: http://www.apress.com/9781484211045?gtmf=s
| słowa kluczowe | t-sql | ||
| język | angielski | ||
| ISBN | 9781484211045 | ||
| data wydania | 27 marca 2015 | ||
| tytuł oryginału | Expert T-SQL Window Functions in SQL Server | ||
| liczba stron | 152 | ||
| kategoria | informatyka i matematyka |
Rejestracja jest za darmo i jest bardzo szybka! Kliknij tutaj aby założyć konto. Trwa to tylko 15 sekund!.
Podobne wpisy do Expert T-SQL Window Functions in SQL Server - Kathi Kellenberger, Clayton Groom
The Story of Awkward - R.K Ryals
If you are looking for a happy book about beautiful people, this is the wrong story. If you are looking for a narrative without emotion, without regrets, and without mistakes, this is definitely the wrong story. This is by no means an uncomplicated t...
Georgia Peaches and Other Forbidden Fruit - Jaye Robin Brown
Joanna Gordon has been out and proud for years, but when her popular radio evangelist father remarries and decides to move all three of them from Atlanta to the more conservative Rome, Georgia, he asks Jo to do the impossible: to lie low for the rest...
Again, But Better - Christine Riccio
Shane has been doing college all wrong. Pre-med, stellar grades, and happy parents…sounds ideal -- but Shane's made zero friends, goes home every weekend, and romance…what’s that? Her life has been dorm, dining hall, class, repeat. Time's a ticking,...
South Beach Diet The Delicious Doctor-Designed - Arthur Agatston
For years, cardiologist Arthur Agatston, M.D., urged his patients to lose weight for the sake of their hearts, but every diet was too hard to follow or its restrictions were too harsh. Some were downright dangerous. Nobody seemed to be able to stick...
Cell 7
Should she live or die? You decide An adored celebrity has been killed. Sixteen-year-old Martha Honeydew was found holding a gun, standing over the body. Now Justice must prevail. The general public will decide whether Martha is innocent or guilty by...
Real Live Boyfriends: Yes. Boyfriends, Plural. If My Life Weren't Complicated, I Wouldn't Be Ruby Oliver - E. Lockhart
From E. Lockhart, author of the highly acclaimed, New York Times bestseller We Were Liars, which John Green called "utterly unforgettable," comes Real Live Boyfriends, the fourth book in the uproarious and heartwarming Ruby Oliver novels that finds R...