Archives: September 2009
Back in August at TechEd Africa I did a TechEd Online interview with Frikkie Bosch. Frikkie’s the marketing manager for the Server products down here in South Africa. We discussed some common mistakes that I’ve seen regarding SQL Server performance. I’m not talking specifics of query/table design here, but rather… Read more
If you buy from Manning directly today or tomorrow, there’s a 50% discount . Use the code pop0928 at the checkout. Hurry, hurry, hurry….
For those who want a copy and are going to the PASS Summit in November, why not pick up your copy of the book there?… Read more
Last year a large number of MVPs (mostly SQL Server) got together to write a book with all proceeds going to charity. The book consists of over 50 chapters, each on a different SQL-Server related topic, from database architecture through development administration, database development, performance tuning and even Business Intelligence.… Read more
I saw this one on a forum recently and it’s a fun question to look into.
When running CheckDB on an in-use database, sometimes messages like the following will appear in the SQL error log
1 transactions rolled back in database ‘Testing’ (8). This is an informational message only. No… Read more
It’s often said that a major discrepancy between estimated and actual row counts in a query’s execution plan is a sign of inaccurate statistics or a poor cardinality estimate and that it’s a sign of a problem. This is generally true, however there are places where the estimates and actual… Read more
It’s not uncommon to find stored procedures that have multiple IF statements controlling the flow of execution within the procedure. Now this seems to be a fairly logical thing to do, but there can be a subtle performance problem with this, one that may be hard to identify.
Let’s have… Read more
From all indications, the first 24 hours of PASS was a resounding success. Hundreds of attendees for each session, minimal technical glitches. All in all, it went very well.
The first session I attended (well, part thereof) was Greg’s discussion on Spatial data. I would really have loved to see… Read more