Introduction to SQL Server query optimization : understanding query optimization and built-in optimization tools / Edward Pollack.

"Begin your journey into query optimization by learning the basics of how SQL Server processes a query from start to finish. Once this foundation is established, you will focus on execution plans: What are they? How do we read them? And what are their more common operations? A variety of statis...

Full description

Saved in:
Bibliographic Details
Other Authors: Pollack, Edward, (Database administrator) (Speaker)
Format: Video
Language:English
Published: [Place of publication not identified] : Apress, [2019]
Subjects:
Online Access:Click for online access

MARC

LEADER 00000cgm a2200000 i 4500
001 on1119557724
003 OCoLC
005 20241006213017.0
006 m o c
007 cr cna||||||||
007 vz czazuu
008 190913s2019 xx 049 o vleng d
040 |a UMI  |b eng  |e rda  |e pn  |c UMI  |d OCLCF  |d ALSTP  |d OCLCO  |d OCL  |d DST  |d OCLCQ  |d OCLCO  |d OCL  |d OCLCO  |d OCLCL 
019 |a 1300705869  |a 1303382638  |a 1395640185 
035 |a (OCoLC)1119557724  |z (OCoLC)1300705869  |z (OCoLC)1303382638  |z (OCoLC)1395640185 
037 |a CL0501000070  |b Safari Books Online 
050 4 |a QA76.9.D3 
049 |a HCDD 
100 1 |a Pollack, Edward,  |c (Database administrator),  |e speaker. 
245 1 0 |a Introduction to SQL Server query optimization :  |b understanding query optimization and built-in optimization tools /  |c Edward Pollack. 
264 1 |a [Place of publication not identified] :  |b Apress,  |c [2019] 
300 |a 1 online resource (1 streaming video file (48 min., 30 sec.)) 
336 |a two-dimensional moving image  |b tdi  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
337 |a video  |b v  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a video file 
511 0 |a Presenter, Edward Pollack. 
500 |a Title from title screen (viewed September 11, 2019). 
500 |a Date of publication from resource description page. 
520 |a "Begin your journey into query optimization by learning the basics of how SQL Server processes a query from start to finish. Once this foundation is established, you will focus on execution plans: What are they? How do we read them? And what are their more common operations? A variety of statistics options will be introduced that provide insight into query duration and the load that a given query presents on memory and storage resources. With a set of tools defined, you will tackle a variety of common optimization challenges. You'll review some common problems in which performance is inadequate and then solutions to mitigate those problems and improve performance. These basic patterns will provide a format for viewing and analyzing queries with the goal of being able to identify the source of the problem when a query is running too slow."--Resource description page 
630 0 0 |a SQL server. 
630 0 7 |a SQL server  |2 fast 
650 0 |a Querying (Computer science) 
650 0 |a Relational databases. 
650 0 |a Client/server computing. 
650 0 |a Database management. 
650 0 |a Database searching. 
650 7 |a online searching.  |2 aat 
650 7 |a Database searching  |2 fast 
650 7 |a Client/server computing  |2 fast 
650 7 |a Database management  |2 fast 
650 7 |a Querying (Computer science)  |2 fast 
650 7 |a Relational databases  |2 fast 
655 7 |a Instructional films  |2 fast 
655 7 |a Instructional films.  |2 lcgft 
655 7 |a Films de formation.  |2 rvmgf 
758 |i has work:  |a Introduction to SQL Server query optimization (MovingImage)  |1 https://id.oclc.org/worldcat/entity/E39PCFYhmybmGBqwrph8kGBRqP  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 |z 148425144X 
856 4 0 |u https://holycross.idm.oclc.org/login?auth=cas&url=http://www.aspresolver.com/aspresolver.asp?MARC;4691282  |y Click for online access 
903 |a ASP-AV 
994 |a 92  |b HCD