Webcast : Build SQL Server Queries and Working with Data
One of the most important parts of SQL Server is being able to use the data as well as using the functionality that SQL Server offers to query data and get your questions answered. It may be the data already exists in the database and you want to know tips and tricks to manipulate the data or you may just want to know how to write better queries to make things run faster. In addition, sometimes you need to import or export data to add additional supporting data or provide the results in Excel or some other format.
In this webinar we will cover the following topics:
* Tips and tricks for writing better queries
* Using subqueries effectively
* Using temporary tables and CTEs
* Understanding when and how indexes are used
* Grouping and rolling up data
* Union, Intersect, Except and Merge queries
* How to check for query improvements using execution plans and IO and Time statistics
* Overview of ways you can import and export data
Building SQL queries and working with data in Microsoft SQL Server can present several challenges. Some of these challenges include:
* High CPU usage: High server CPU usage can be caused by SQL processes being run, poor query execution, system tasks, and excessive compilation and recompilation of queries. The CPU can also be strained if there are bad indexes in place.
* Execution issues: Poor execution can occur for various reasons, such as network bottlenecking or latch waits, but it is often just the result of bad execution planning. Poor planning leads to poor execution, and optimal SQL query and timing results require strategic system planning.
* Query processing: SQL Server Database Engine processes queries on various data storage architectures, such as local tables, partitioned tables, and tables distributed across multiple servers. To understand how SQL Server processes and optimizes query reuse through execution plan caching is essential for building efficient queries
Building SQL queries and working with data in Microsoft SQL Server can present several challenges. Some of these challenges include:
* High CPU usage: High server CPU usage can be caused by SQL processes being run, poor query execution, system tasks, and excessive compilation and recompilation of queries. The CPU can also be strained if there are bad indexes in place.
* Execution issues: Poor execution can occur for various reasons, such as network bottlenecking or latch waits, but it is often just the result of bad execution planning. Poor planning leads to poor execution, and optimal SQL query and timing results require strategic system planning.
* Query processing: SQL Server Database Engine processes queries on various data storage architectures, such as local tables, partitioned tables, and tables distributed across multiple servers. To understand how SQL Server processes and optimizes query reuse through execution plan caching is essential for building efficient queries
About the Presenter
Eric Blinn has been a SQL Server DBA and Architect in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.
Please register to view the webcast replay.