Expert T-SQL window functions in SQL server:
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 per...
Gespeichert in:
| Beteiligte Personen: | , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
[Berkeley, CA]
Apress
[2015]
|
| Schriftenreihe: | Expert's voice in SQL server
|
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/9781484211038/?ar |
| Zusammenfassung: | 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. Teaches you how to use all the window functions introduced in 2005 and 2012. Provides real-world examples that you can experiment with in your own database. Explains how to get the best performance when using windowing functions. |
| Beschreibung: | Includes index. - Vendor-supplied metadata |
| Umfang: | 1 Online-Ressource illustrations |
| ISBN: | 9781484211038 1484211030 |
Internformat
MARC
| LEADER | 00000cam a22000002 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-077129105 | ||
| 003 | DE-627-1 | ||
| 005 | 20240228115821.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 220322s2015 xx |||||o 00| ||eng c | ||
| 020 | |a 9781484211038 |c electronic bk. |9 978-1-4842-1103-8 | ||
| 020 | |a 1484211030 |c electronic bk. |9 1-4842-1103-0 | ||
| 035 | |a (DE-627-1)077129105 | ||
| 035 | |a (DE-599)KEP077129105 | ||
| 035 | |a (ORHE)9781484211038 | ||
| 035 | |a (DE-627-1)077129105 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 072 | 7 | |a COM |2 bisacsh | |
| 072 | 7 | |a UN |2 bicssc | |
| 072 | 7 | |a UMT |2 bicssc | |
| 082 | 0 | |a 005.75/6 |2 22 | |
| 100 | 1 | |a Kellenberger, Kathi |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a Expert T-SQL window functions in SQL server |c Kathi Kellenberger with Clayton Groom |
| 264 | 1 | |a [Berkeley, CA] |b Apress |c [2015] | |
| 300 | |a 1 Online-Ressource |b illustrations | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 490 | 0 | |a Expert's voice in SQL server | |
| 500 | |a Includes index. - Vendor-supplied metadata | ||
| 520 | |a 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. Teaches you how to use all the window functions introduced in 2005 and 2012. Provides real-world examples that you can experiment with in your own database. Explains how to get the best performance when using windowing functions. | ||
| 630 | 2 | 0 | |a SQL server |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a computerwetenschappen | |
| 650 | 0 | |a computer sciences | |
| 650 | 0 | |a programmeertalen | |
| 650 | 0 | |a programming languages | |
| 650 | 0 | |a databasebeheer | |
| 650 | 0 | |a database management | |
| 650 | 0 | |a Information and Communication Technology (General) | |
| 650 | 0 | |a Informatie- en communicatietechnologie (algemeen) | |
| 650 | 4 | |a SQL server | |
| 650 | 4 | |a SQL (Langage de programmation) | |
| 650 | 4 | |a Programming & scripting languages: general | |
| 650 | 4 | |a Databases | |
| 650 | 4 | |a COMPUTERS ; Programming Languages ; SQL | |
| 650 | 4 | |a SQL (Computer program language) | |
| 700 | 1 | |a Groom, Clayton |e VerfasserIn |4 aut | |
| 776 | 1 | |z 9781484211045 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9781484211045 |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781484211038/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 912 | |a ZDB-30-ORH | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Datensatz im Suchindex
| DE-BY-TUM_katkey | ZDB-30-ORH-077129105 |
|---|---|
| _version_ | 1821494823331299328 |
| adam_text | |
| any_adam_object | |
| author | Kellenberger, Kathi Groom, Clayton |
| author_facet | Kellenberger, Kathi Groom, Clayton |
| author_role | aut aut |
| author_sort | Kellenberger, Kathi |
| author_variant | k k kk c g cg |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)077129105 (DE-599)KEP077129105 (ORHE)9781484211038 |
| dewey-full | 005.75/6 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/6 |
| dewey-search | 005.75/6 |
| dewey-sort | 15.75 16 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03757cam a22006252 4500</leader><controlfield tag="001">ZDB-30-ORH-077129105</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228115821.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">220322s2015 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484211038</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-4842-1103-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1484211030</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-4842-1103-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)077129105</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP077129105</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781484211038</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)077129105</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">UN</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">UMT</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/6</subfield><subfield code="2">22</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kellenberger, Kathi</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Expert T-SQL window functions in SQL server</subfield><subfield code="c">Kathi Kellenberger with Clayton Groom</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[Berkeley, CA]</subfield><subfield code="b">Apress</subfield><subfield code="c">[2015]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Expert's voice in SQL server</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index. - Vendor-supplied metadata</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">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. Teaches you how to use all the window functions introduced in 2005 and 2012. Provides real-world examples that you can experiment with in your own database. Explains how to get the best performance when using windowing functions.</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">SQL server</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">computerwetenschappen</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">computer sciences</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">programmeertalen</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">programming languages</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">databasebeheer</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">database management</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Information and Communication Technology (General)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Informatie- en communicatietechnologie (algemeen)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL server</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Programming & scripting languages: general</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Databases</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">COMPUTERS ; Programming Languages ; SQL</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Groom, Clayton</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">9781484211045</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">9781484211045</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/9781484211038/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-077129105 |
| illustrated | Illustrated |
| indexdate | 2025-01-17T11:20:30Z |
| institution | BVB |
| isbn | 9781484211038 1484211030 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource illustrations |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2015 |
| publishDateSearch | 2015 |
| publishDateSort | 2015 |
| publisher | Apress |
| record_format | marc |
| series2 | Expert's voice in SQL server |
| spelling | Kellenberger, Kathi VerfasserIn aut Expert T-SQL window functions in SQL server Kathi Kellenberger with Clayton Groom [Berkeley, CA] Apress [2015] 1 Online-Ressource illustrations Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Expert's voice in SQL server Includes index. - Vendor-supplied metadata 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. Teaches you how to use all the window functions introduced in 2005 and 2012. Provides real-world examples that you can experiment with in your own database. Explains how to get the best performance when using windowing functions. SQL server SQL (Computer program language) computerwetenschappen computer sciences programmeertalen programming languages databasebeheer database management Information and Communication Technology (General) Informatie- en communicatietechnologie (algemeen) SQL (Langage de programmation) Programming & scripting languages: general Databases COMPUTERS ; Programming Languages ; SQL Groom, Clayton VerfasserIn aut 9781484211045 Erscheint auch als Druck-Ausgabe 9781484211045 |
| spellingShingle | Kellenberger, Kathi Groom, Clayton Expert T-SQL window functions in SQL server SQL server SQL (Computer program language) computerwetenschappen computer sciences programmeertalen programming languages databasebeheer database management Information and Communication Technology (General) Informatie- en communicatietechnologie (algemeen) SQL (Langage de programmation) Programming & scripting languages: general Databases COMPUTERS ; Programming Languages ; SQL |
| title | Expert T-SQL window functions in SQL server |
| title_auth | Expert T-SQL window functions in SQL server |
| title_exact_search | Expert T-SQL window functions in SQL server |
| title_full | Expert T-SQL window functions in SQL server Kathi Kellenberger with Clayton Groom |
| title_fullStr | Expert T-SQL window functions in SQL server Kathi Kellenberger with Clayton Groom |
| title_full_unstemmed | Expert T-SQL window functions in SQL server Kathi Kellenberger with Clayton Groom |
| title_short | Expert T-SQL window functions in SQL server |
| title_sort | expert t sql window functions in sql server |
| topic | SQL server SQL (Computer program language) computerwetenschappen computer sciences programmeertalen programming languages databasebeheer database management Information and Communication Technology (General) Informatie- en communicatietechnologie (algemeen) SQL (Langage de programmation) Programming & scripting languages: general Databases COMPUTERS ; Programming Languages ; SQL |
| topic_facet | SQL server SQL (Computer program language) computerwetenschappen computer sciences programmeertalen programming languages databasebeheer database management Information and Communication Technology (General) Informatie- en communicatietechnologie (algemeen) SQL (Langage de programmation) Programming & scripting languages: general Databases COMPUTERS ; Programming Languages ; SQL |
| work_keys_str_mv | AT kellenbergerkathi experttsqlwindowfunctionsinsqlserver AT groomclayton experttsqlwindowfunctionsinsqlserver |