Welcome to Sign in | Join | Help

decembrie 2008 - Posts

I've devoted the last few blog entries to describing what's in that spatial index analysis proc output and how to use it and interpret the results. Just wanted to describe the rest of the information and how the information relates to what you'd Read More...
A little more about the query sample that gets fed into the spatial index procs. Query sample is a singleton geometry or geography. It's not a query. So it's not as straightforward as "here's a spatial query that could use an index, run Read More...
Last post discussed the filters. The procs report some raw numbers and some derived numbers. Here's a cheat sheet, although the info is all in the BOL. N = Number of rows in the table O = Number of rows output P = Number of rows selected by primary Read More...
The spatial index diagnostic procs' most enlightening pieces of information have to do with the filter counts and efficiencies reported at the end of the set of columns or XML document output. But what are these filters exactly and what do the results Read More...
I've been looking at the spatial index stored procedures (sp_help_spatial_geography_index_xml and friends) a little harder recently, in an attempt to help answer two questions. 1. If I have a spatial query, why does/doesn't it use my spatial index? Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/12/16/bogus-error-833-issue-is-fixed-in-sp3/  The problem around incorrectly measured IO times due to CPU time drift was fixed by the SQL Server 2005 SP3 release. Read More...
Sorry to appear after a blog drought with theory meta-type blog entries. Too much time at conferences pondering technologies, I guess. The "relational database bigots" I hang out with don't like LINQ at all. They hope it would shrivel up Read More...
I've been following the ADO.NET Entity Framework since its inception. Never did buy the idea about it being "more than an ORM", thought it was just marketing hype. After all, if it looks like an ORM and smells like an ORM, then... But, the Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/12/04/the-broker-wordle/  wordle.net has come up with an applet that creates beautiful word clouds from a blog feed. Eager to try it I used my own blog as a source Read More...