|
Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and gain practical approaches and advanced techniques to optimize your code’s performance.
Discover how to:
- Move from procedural programming to the language of sets and logic
- Optimize query tuning with a top-down methodology
- Assess algorithmic complexity to predict performance
- Compare data-aggregation techniques, including new grouping sets
- Manage data modification—insert, delete, update, merge—for performance
- Write more efficient queries against partitioned tables
- Work with graphs, trees, hierarchies, and recursive queries
- Plus—Use pure-logic puzzles to sharpen your problem-solving skills
|
|
|
Pro Asynchronous Programming with .NET
Pro Asynchronous Programming with .NET teaches the essential skill of asynchronous programming in .NET. It answers critical questions in .NET application development, such as: how do I keep my program responding at all times to keep my users happy? how do I make the most of the available hardware? how can I improve performance? ... | | Smart Polymers and their Applications (Woodhead Publishing in Materials)
Smart polymers are polymers that respond to different stimuli or changes in the environment. Smart Polymers and their Applications reviews the types, synthesis, properties, and applications of smart polymers.
Chapters in part one focus on types of polymers, including temperature-, pH-, photo-, and enzyme-responsive polymers.... | | Collaborative Computer Security and Trust Management (Premier Reference Source)
Collaborative Computer Security and Trust Management combines perspectives of leading researchers in collaborative security to discuss recent advances in this burgeoning new field. Practitioners, researchers, and academicians are presented with lessons learned by international experts to meet the new challenges of security in the... |
|