000726315 000__ 03213cam\a2200445Ii\4500
000726315 001__ 726315
000726315 005__ 20230306140724.0
000726315 006__ m\\\\\o\\d\\\\\\\\
000726315 007__ cr\cn\nnnunnun
000726315 008__ 150331s2015\\\\caua\\\\o\\\\\001\0\eng\d
000726315 020__ $$a9781484211038$$qelectronic book
000726315 020__ $$a1484211030$$qelectronic book
000726315 020__ $$z9781484211045
000726315 0247_ $$a10.1007/978-1-4842-1103-8$$2doi
000726315 035__ $$aSP(OCoLC)ocn905902707
000726315 035__ $$aSP(OCoLC)905902707
000726315 040__ $$aN$T$$beng$$erda$$epn$$cN$T$$dN$T$$dGW5XE$$dE7B$$dUPM$$dCOO$$dYDXCP$$dIDEBK$$dEBLCP$$dOCLCF$$dDEBSZ$$dB24X7$$dBTCTA$$dVLB
000726315 049__ $$aISEA
000726315 050_4 $$aQA76.73.S67$$bK45 2015eb
000726315 08204 $$a005.75/6$$222
000726315 1001_ $$aKellenberger, Kathi,$$eauthor.
000726315 24510 $$aExpert T-SQL window functions in SQL server$$h[electronic resource] /$$cKathi Kellenberger with Clayton Groom.
000726315 264_1 $$a[Berkeley, CA] :$$bApress,$$c[2015]
000726315 300__ $$a1 online resource :$$billustrations.
000726315 336__ $$atext$$btxt$$2rdacontent
000726315 337__ $$acomputer$$bc$$2rdamedia
000726315 338__ $$aonline resource$$bcr$$2rdacarrier
000726315 4901_ $$aExpert's voice in SQL server
000726315 500__ $$aIncludes index.
000726315 506__ $$aAccess limited to authorized users.
000726315 520__ $$aExpert 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.
000726315 63000 $$aSQL server.
000726315 650_0 $$aSQL (Computer program language)
000726315 7001_ $$aGroom, Clayton,$$eauthor.
000726315 77608 $$iPrint version:$$z9781484211045
000726315 830_0 $$aExpert's voice in SQL server.
000726315 852__ $$bebk
000726315 85640 $$3SpringerLink$$uhttps://univsouthin.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-1-4842-1103-8$$zOnline Access$$91397441.1
000726315 909CO $$ooai:library.usi.edu:726315$$pGLOBAL_SET
000726315 980__ $$aEBOOK
000726315 980__ $$aBIB
000726315 982__ $$aEbook
000726315 983__ $$aOnline
000726315 994__ $$a92$$bISE