Posts Categorized: SQL Server

SQLTeach Toronto: Almost Here

Toronto SQLTeach conference is now only a few weeks away. This conference includes quite a few interesting SQL Server-related sessions, on topics ranging from best practices, to performance, to some of the new SQL Server 2008 features.

SQL Server Procedure Cache: More Relief on the Way

SQL Server 2005 brought some relief in the form of the Forced Parameterization database option, and SP2 took things one step further with better throttling of the cache… but it’s still not enough. We want a knob! The bad news: We’re not getting quite the knob I was hoping for. The good news: SQL Server 2008 will include an sp_configure option called “optimize for ad hoc workloads”

SQL Server Query Processing Puzzle: LIKE vs ?

How creative are you with manipulating your queries to produce more efficient plans? Try the following puzzle and e-mail your solution to me at [ @ pythian.com]. Make sure to include an explanation of why it works, as well as your mailing address. The best two solutions/explanations win a free copy of Expert SQL Server 2005 Development, a wonderful feeling of accomplishment, plus eternal fame and glory when I reveal your solutions here on the blog.

Rajaraman’s First Law: More Data will beat Better Software

After the interesting comment storm on Doug’s blog when he posted some of Tim Gorman’s comments on the value of data in his career experiences as compared to the value of the applications manipulating that data, I hesitate a little to post this. But, I can’t stop myself because it’s such an interesting insight! So here it is!

Page 33 of 36« First...1020...3132333435...Last »