What Improv is and Why it Matters — Introduction

Lifehacker recently featured a post titled “How To Use Improv to Change your Life”; the post made me think how improv (improvisational theatre) had changed my life. Way back in high school I took a summer theatre class from a teacher who’d worked on Broadway. We did lots of fun activities that summer, but my […]
Read More ›

SQL Server: Some Quirks in the Cache, Part II

Some Surprising Traits of SQL Server Query Caching In the previous section<link SQL Server: Some Quirks In the Cache Part 1>, we saw that it is easy to observe query execution plans being entered into the procedure cache by SQL Server. Now that the tools are in place, we will observe some unexpected behavior of […]
Read More ›

SQL Server: Some Quirks in the Cache, Part I

Monitoring the Procedure Cache Getting the best performance from SQL Server is a complex task involving virtually every aspect of the system. Memory management is one of the most important aspects, of course. The primary concern is memory for data itself, but that doesn’t mean we can ignore the procedure cache. Procedure cache is the […]
Read More ›

Take All Your Music To Linux

“I own many CDs”, the Sphinx said. “I listen to music all the time. But I never play my CDs. What is happening?” That’s easy, a minor-league Sphinx question at best. She ripped her CDs. She used software to read the audio data, convert it to a compressed format, and store the songs as files […]
Read More ›

LINQ: The Good, The Bad, and The Poorly Optimized (Part 2)

Part 2: Controlling Parameter Optimization with Plan Guides For Part 1 of this series, see LINQ: The Good, The Bad, and The Poorly Optimized. T-SQL supports a variety of “hints”. They are hints in the same sense that your mother used to hint that it’s time to wash up and come to dinner. In other […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.