|
|
|
|
Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.
Browse by Tags
All Tags » Performance (RSS)
-
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 [<do_not_mail> @ do_not_mail.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...
|
-
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...
|
-
"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...
|
-
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...
|
-
Eight months ago I announced the release of the first beta version of SQLQueryStress . I had big plans: Collect a bunch of feedback, quickly fix any bugs that came in, and release a final version. Time frame of two weeks, tops. As is often the case, life Read More...
|
-
A couple of days ago, Aaron Bertrand posted about a method for calculating medians in SQL Server 2005 using the ROW_NUMBER function in conjunction with the COUNT aggregate. This method (credited to Itzik Ben-Gan) is interesting, but I discovered an even Read More...
|
-
On October 20, 2004 -- two years ago -- I announced that I was considering writing my own query load testing tool . Clearly, my follow through on this promise has been incredibly delayed. But all is not lost, and I'm happy to report that I am true to Read More...
|
-
When working with SQL Server 2000, I used to have this little trick I'd pull out after exhausting all other ideas for tuning a query. And I thought that my little trick was dead in SQL Server 2005, but thanks to fellow SQL Server MVP Rob Farley , I am Read More...
|
-
Scalar. Function. Wow. Could any other combination of words evoke the same feeling of encapsulation, information hiding, and simplification of client code? After years spent developing software in the procedural and OO worlds, it can be difficult--perhaps, Read More...
|
-
In the last installment, I showed a potentially fastest method using Array.Reverse. After finding and fixing a bug in method #3 posted in my last installment (it is, in fact, quite a bit faster than method #1 when you don't have a big huge bug in the Read More...
|
-
Over in the Simple-Talk forums, there is a good thread going about how best to reverse a string in .NET, since no string reverse method is included in the BCL . A few suggestions were made, and someone implied that they were too complex and that simplicity Read More...
|
-
Back again! Fourth post for the month of February, making this my best posting month in, well, months. Expect this trend to continue. After yesterday's post on running sums and the evils of cursors , Jamie Thompson came up with a faster solution than Read More...
|
-
Siddhartha Gautama, the Buddha, taught us to understand that the key to enlightenment is following the Middle Path. And today I learned a valuable lesson in extremes. You can file this one in the "Doh! Wrong again!" category... A fairly common question Read More...
|
-
I just posted a few SqlDataReader performance tips in response to a newsgroup post; I think they're some pretty good tips, so I'll repeat them here. These tips were gleaned from using both Lutz Roeder's Reflector and Compuware's DevPartner Profiler Community Read More...
|
|
|
|
|
|