Next Month: Tuesday, September 20th, 2016
Jay Robinson, SalesforceAbstract:
Being able to write functional SQL queries is a useful skill, of course, but functional is only the first step. An understanding of how SQL Server processes your queries is necessary to ensure that what you are writing is handled quickly and efficiently.
In this session, we will cover the basics of SQL Server storage, clustered and non-clustered indexes, the three main join algorithms, scans versus seeks, and other fundamental concepts behind the processing of Transact-SQL queries.About Jay:
Jay Robinson earned his MCSD and MCSE way back in 1999, getting certified on SQL Server 6.5 and 2000 along the way. A nice and quiet career as a developer followed. And then he came to ExactTarget (now the Salesforce Marketing Cloud) in 2008 and found out what real databases were like. Obsessed with speed, he spends his time writing code that makes big data go fast.