Holdings: Expert T-SQL Window Functions in SQL Server

Expert T-SQL Window Functions in SQL Server:

Saved in:

Bibliographic Details
Main Authors:	Kellenberger, Kathi (Author), Groom, Clayton (Author)
Format:	Electronic eBook
Language:	English
Published:	Berkeley, CA Apress 2015
Subjects:	Datenanalyse Fenster Bildschirmfenster Datenbankverwaltung Informatik SQL Server Transact SQL
Online Access:	FHM01 FHN01 FHR01 FNU01 FWS01 FWS02 Volltext Abstract
Physical Description:	1 Online-Ressource (XVII, 152 p.) Ill.
ISBN:	9781484211038
DOI:	10.1007/978-1-4842-1103-8

Staff View

MARC


LEADER	00000nmm a2200000zc 4500
001	BV042481668
003	DE-604
005	20160721
007	cr\|uuu---uuuuu
008	150402s2015 \|\|\|\| o\|\|u\| \|\|\|\|\|\|eng d
020			\|a 9781484211038 \|c Online \|9 978-1-4842-1103-8
024	7		\|a 10.1007/978-1-4842-1103-8 \|2 doi
035			\|a (OCoLC)906211264
035			\|a (DE-599)BVBBV042481668
040			\|a DE-604 \|b ger \|e aacr
041	0		\|a eng
049			\|a DE-898 \|a DE-M347 \|a DE-1049 \|a DE-863 \|a DE-92 \|a DE-862
082	0		\|a 650
084			\|a ST 250 \|0 (DE-625)143626: \|2 rvk
084			\|a ST 261 \|0 (DE-625)143633: \|2 rvk
084			\|a ST 271 \|0 (DE-625)143639: \|2 rvk
100	1		\|a Kellenberger, Kathi \|e Verfasser \|4 aut
245	1	0	\|a Expert T-SQL Window Functions in SQL Server \|c by Kathi Kellenberger, Clayton Groom
264		1	\|a Berkeley, CA \|b Apress \|c 2015
300			\|a 1 Online-Ressource (XVII, 152 p.) \|b Ill.
336			\|b txt \|2 rdacontent
337			\|b c \|2 rdamedia
338			\|b cr \|2 rdacarrier
650	0	7	\|a Datenanalyse \|0 (DE-588)4123037-1 \|2 gnd \|9 rswk-swf
650	0	7	\|a Fenster \|0 (DE-588)4016740-9 \|2 gnd \|9 rswk-swf
650	0	7	\|a Bildschirmfenster \|0 (DE-588)4128756-3 \|2 gnd \|9 rswk-swf
650	0	7	\|a Datenbankverwaltung \|0 (DE-588)4389357-0 \|2 gnd \|9 rswk-swf
650	0	7	\|a Informatik \|0 (DE-588)4026894-9 \|2 gnd \|9 rswk-swf
650	0	7	\|a SQL Server \|0 (DE-588)4343204-9 \|2 gnd \|9 rswk-swf
650	0	7	\|a Transact SQL \|0 (DE-588)4298853-6 \|2 gnd \|9 rswk-swf
689	0	0	\|a Informatik \|0 (DE-588)4026894-9 \|D s
689	0	1	\|a Bildschirmfenster \|0 (DE-588)4128756-3 \|D s
689	0	2	\|a Datenbankverwaltung \|0 (DE-588)4389357-0 \|D s
689	0	3	\|a Transact SQL \|0 (DE-588)4298853-6 \|D s
689	0		\|5 DE-604
689	1	0	\|a Informatik \|0 (DE-588)4026894-9 \|D s
689	1	1	\|a Fenster \|0 (DE-588)4016740-9 \|D s
689	1	2	\|a Datenbankverwaltung \|0 (DE-588)4389357-0 \|D s
689	1	3	\|a Transact SQL \|0 (DE-588)4298853-6 \|D s
689	1		\|8 1\p \|5 DE-604
689	2	0	\|a SQL Server \|0 (DE-588)4343204-9 \|D s
689	2	1	\|a Datenbankverwaltung \|0 (DE-588)4389357-0 \|D s
689	2	2	\|a Datenanalyse \|0 (DE-588)4123037-1 \|D s
689	2		\|8 2\p \|5 DE-604
700	1		\|a Groom, Clayton \|e Verfasser \|4 aut
776	0	8	\|i Erscheint auch als \|n Druckausgabe \|z 978-1-4842-1104-5
856	4	0	\|u https://doi.org/10.1007/978-1-4842-1103-8 \|x Verlag \|3 Volltext
856	4	2	\|m Springer Fremddatenuebernahme \|q application/pdf \|u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027916627&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA \|3 Abstract
912			\|a ZDB-2-CWD
940	1		\|q ZDB-2-CWD_2015
999			\|a oai:aleph.bib-bvb.de:BVB01-027916627
883	1		\|8 1\p \|a cgwrk \|d 20201028 \|q DE-101 \|u https://d-nb.info/provenance/plan#cgwrk
883	1		\|8 2\p \|a cgwrk \|d 20201028 \|q DE-101 \|u https://d-nb.info/provenance/plan#cgwrk
966	e		\|u https://doi.org/10.1007/978-1-4842-1103-8 \|l FHM01 \|p ZDB-2-CWD \|x Verlag \|3 Volltext
966	e		\|u https://doi.org/10.1007/978-1-4842-1103-8 \|l FHN01 \|p ZDB-2-CWD \|x Verlag \|3 Volltext
966	e		\|u https://doi.org/10.1007/978-1-4842-1103-8 \|l FHR01 \|p ZDB-2-CWD \|x Verlag \|3 Volltext
966	e		\|u https://doi.org/10.1007/978-1-4842-1103-8 \|l FNU01 \|p ZDB-2-CWD \|x Verlag \|3 Volltext
966	e		\|u https://doi.org/10.1007/978-1-4842-1103-8 \|l FWS01 \|p ZDB-2-CWD \|x Verlag \|3 Volltext
966	e		\|u https://doi.org/10.1007/978-1-4842-1103-8 \|l FWS02 \|p ZDB-2-CWD \|x Verlag \|3 Volltext

Record in the Search Index

DE-BY-FWS_katkey	554309
_version_	1824554416013836288
adam_text	EXPERT T-SQL WINDOW FUNCTIONS IN SQL SERVER / KELLENBERGER, KATHI : 2015 ABSTRACT / INHALTSTEXT 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 DIESES SCHRIFTSTUECK WURDE MASCHINELL ERZEUGT.
any_adam_object	1
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	BV042481668
classification_rvk	ST 250 ST 261 ST 271
collection	ZDB-2-CWD
ctrlnum	(OCoLC)906211264 (DE-599)BVBBV042481668
dewey-full	650
dewey-hundreds	600 - Technology (Applied sciences)
dewey-ones	650 - Management and auxiliary services
dewey-raw	650
dewey-search	650
dewey-sort	3650
dewey-tens	650 - Management and auxiliary services
discipline	Informatik Wirtschaftswissenschaften
doi_str_mv	10.1007/978-1-4842-1103-8
format	Electronic eBook
fullrecord	<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03349nmm a2200733zc 4500</leader><controlfield tag="001">BV042481668</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20160721 </controlfield><controlfield tag="007">cr\|uuu---uuuuu</controlfield><controlfield tag="008">150402s2015 \|\|\|\| o\|\|u\| \|\|\|\|\|\|eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484211038</subfield><subfield code="c">Online</subfield><subfield code="9">978-1-4842-1103-8</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1007/978-1-4842-1103-8</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)906211264</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV042481668</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-898</subfield><subfield code="a">DE-M347</subfield><subfield code="a">DE-1049</subfield><subfield code="a">DE-863</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-862</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">650</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 250</subfield><subfield code="0">(DE-625)143626:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 261</subfield><subfield code="0">(DE-625)143633:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kellenberger, Kathi</subfield><subfield code="e">Verfasser</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">by Kathi Kellenberger, 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 (XVII, 152 p.)</subfield><subfield code="b">Ill.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenanalyse</subfield><subfield code="0">(DE-588)4123037-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Fenster</subfield><subfield code="0">(DE-588)4016740-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Bildschirmfenster</subfield><subfield code="0">(DE-588)4128756-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Informatik</subfield><subfield code="0">(DE-588)4026894-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL Server</subfield><subfield code="0">(DE-588)4343204-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Transact SQL</subfield><subfield code="0">(DE-588)4298853-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Informatik</subfield><subfield code="0">(DE-588)4026894-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Bildschirmfenster</subfield><subfield code="0">(DE-588)4128756-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="3"><subfield code="a">Transact SQL</subfield><subfield code="0">(DE-588)4298853-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">Informatik</subfield><subfield code="0">(DE-588)4026894-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">Fenster</subfield><subfield code="0">(DE-588)4016740-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="2"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="3"><subfield code="a">Transact SQL</subfield><subfield code="0">(DE-588)4298853-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">SQL Server</subfield><subfield code="0">(DE-588)4343204-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2="1"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2="2"><subfield code="a">Datenanalyse</subfield><subfield code="0">(DE-588)4123037-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2=" "><subfield code="8">2\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Groom, Clayton</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druckausgabe</subfield><subfield code="z">978-1-4842-1104-5</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://doi.org/10.1007/978-1-4842-1103-8</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Springer Fremddatenuebernahme</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027916627&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Abstract</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-2-CWD</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">ZDB-2-CWD_2015</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-027916627</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">2\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1103-8</subfield><subfield code="l">FHM01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1103-8</subfield><subfield code="l">FHN01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1103-8</subfield><subfield code="l">FHR01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1103-8</subfield><subfield code="l">FNU01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1103-8</subfield><subfield code="l">FWS01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1103-8</subfield><subfield code="l">FWS02</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection>
id	DE-604.BV042481668
illustrated	Illustrated
indexdate	2025-02-20T06:51:25Z
institution	BVB
isbn	9781484211038
language	English
oai_aleph_id	oai:aleph.bib-bvb.de:BVB01-027916627
oclc_num	906211264
open_access_boolean
owner	DE-898 DE-BY-UBR DE-M347 DE-1049 DE-863 DE-BY-FWS DE-92 DE-862 DE-BY-FWS
owner_facet	DE-898 DE-BY-UBR DE-M347 DE-1049 DE-863 DE-BY-FWS DE-92 DE-862 DE-BY-FWS
physical	1 Online-Ressource (XVII, 152 p.) Ill.
psigel	ZDB-2-CWD ZDB-2-CWD_2015
publishDate	2015
publishDateSearch	2015
publishDateSort	2015
publisher	Apress
record_format	marc
spellingShingle	Kellenberger, Kathi Groom, Clayton Expert T-SQL Window Functions in SQL Server Datenanalyse (DE-588)4123037-1 gnd Fenster (DE-588)4016740-9 gnd Bildschirmfenster (DE-588)4128756-3 gnd Datenbankverwaltung (DE-588)4389357-0 gnd Informatik (DE-588)4026894-9 gnd SQL Server (DE-588)4343204-9 gnd Transact SQL (DE-588)4298853-6 gnd
subject_GND	(DE-588)4123037-1 (DE-588)4016740-9 (DE-588)4128756-3 (DE-588)4389357-0 (DE-588)4026894-9 (DE-588)4343204-9 (DE-588)4298853-6
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 by Kathi Kellenberger, Clayton Groom
title_fullStr	Expert T-SQL Window Functions in SQL Server by Kathi Kellenberger, Clayton Groom
title_full_unstemmed	Expert T-SQL Window Functions in SQL Server by Kathi Kellenberger, Clayton Groom
title_short	Expert T-SQL Window Functions in SQL Server
title_sort	expert t sql window functions in sql server
topic	Datenanalyse (DE-588)4123037-1 gnd Fenster (DE-588)4016740-9 gnd Bildschirmfenster (DE-588)4128756-3 gnd Datenbankverwaltung (DE-588)4389357-0 gnd Informatik (DE-588)4026894-9 gnd SQL Server (DE-588)4343204-9 gnd Transact SQL (DE-588)4298853-6 gnd
topic_facet	Datenanalyse Fenster Bildschirmfenster Datenbankverwaltung Informatik SQL Server Transact SQL
url	https://doi.org/10.1007/978-1-4842-1103-8 http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027916627&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
work_keys_str_mv	AT kellenbergerkathi experttsqlwindowfunctionsinsqlserver AT groomclayton experttsqlwindowfunctionsinsqlserver

Holdings

Get full text

MARC

Record in the Search Index

Similar Items