|
|
|
|
Adam Machanic, Boston-based independent database consultant, writer, and speaker, shares his experiences with programming, performance tuning, and optimizing SQL Server 2000, 2005, and 2008, in conjunction with related technologies such as .NET.
Browse by Tags
-
If you attended my session this morning, thank you ! It's always flattering when people are willing to wake up before 8:00 a.m. just so that they can hear a talk about SQL Server. I had a great time doing the talk, and I think it went well. My sincerest Read More...
|
-
Imagine yourself, happily computing (or whatever it is that you do with your computer). It's a fine, sunny day, narry a cloud in the sky, and you're happily typing along when all of a sudden you hear a rather alien sound eminating from your hard drive. Read More...
|
-
Next Thursday, May 8, the New England SQL Server Users Group will have a special meeting, featuring Craig Freedman from the SQL Server development team. Craig is The Man when it comes to query optimizer internals, and wrote an incredibly detailed chapter Read More...
|
-
I was just reviewing my calendar for the next several weeks and noticed that the 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, Read More...
|
-
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 [<my last name> @ pythian.com]. Make sure to include an explanation of why it works, as well as your Read More...
|
-
If you've read many of my blog posts, you know that I consider lack of procedure cache control to be a major SQL Server pain point . Badly written apps that use non-parameterized ad hoc queries can quickly flood SQL Server's memory pools and bring the Read More...
|
-
I generally shy away from writing personal blog posts about my life, but when it comes to major career changes it's kind of fun to share the news. After almost three years as an independent consultant, I have stepped out of that business and into a full-time Read More...
|
-
A lot of people will be interested to know that at the launch event in LA it was announced that the T-SQL debugger is returning to Management Studio in SQL Server 2008 . Personally, this is not a feature I've been lamenting the loss of; I never used it Read More...
|
-
Relative comparison is a simple matter of human nature. From early childhood we compare and contrast what we see in the world around us, building a means by which to rate what we experience. And as it turns out, this desire to discover top and bottom, Read More...
|
-
And I quote... final Release to manufacturing (RTM) of SQL Server 2008 expected in Q3. Thanks to Jason Massie for the pointer (via our Roller , of course!) Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More...
|
-
Just a heads up for those in the Boston area: The New England SQL Server Users Group is doing a special event next Wednesday night (January 23), featuring Itzik Ben-Gan, talking about Grouping Sets in SQL Server 2008: SQL Server 2008 introduces enhanced Read More...
|
-
As with all of the blog posts I keep meaning to write -- I keep a list and given the infrequency with which I've been posting lately, it's getting quite large -- this script has been on the queue for quite some time. So here I find myself with a spare Read More...
|
-
"Lonely but free I'll be found Drifting along with the tumbling tumbleweeds" - Supremes, "Tumbling Tumble Weeds" Welcome to the first installment of what I hope will be a regular feature on this blog, Anti-Patterns and Malpractices. As a consultant, I Read More...
|
-
Lazy developer that I am, I just hate running installers to set up VHDs for the SQL Server 2008 CTPs. So I was overjoyed when Microsoft did the work for me and released a pre-installed VHD image for CTP4. CTP5, alas, did not ship with a VHD, forcing me Read More...
|
-
I found Linchi's recent post on use of cursors in the TPC-E test to be quite interesting. The question is, why are cursors used in the test when the commonly accepted notion within the SQL Server community is that cursors are a bad thing? I've posted Read More...
|
|
|
|
|
|