Spatial Indexes in SP1, almost no hints required
On experimenting with the CTP of SQL Server 2008 SP1, I found that there were some changes made to the costing algorithm, vis-a-vis spatial indexes.
Menu
On experimenting with the CTP of SQL Server 2008 SP1, I found that there were some changes made to the costing algorithm, vis-a-vis spatial indexes.
I was browsing through MSDN magazine (the paper version) today and noticed an ad for the upcoming SQLConnections conference in Orlando. I'm doing three sessions
I've been back working with SQL Server Query Notifications again lately. This blog post stems from a problem where the query notification "appears to register
I've become a columnist for MSDN magazine and my first column is available in the online edition, Feb 2009 issue today. I'm doing a column
If you seem to be getting tons of my old blog entries, it's because I've gone back through all of them and added categories. All
For those folks who wrote comments on the blog posts and wondered why they do not appear…. they should appear now. When our new blogging
Today I came across the new SQL Server 2008 Compliance Portal. This portal has information and links to the new Compliance whitepaper and compliance scripts
When SQL Server's spatial data types were introduced, people asked "Why does every standard method begin with ST" (e.g. STIsEmpty). SQL Server docs always cite
Yesterday a friend asked me if it was better to always use a value of GEOMETRYCOLLECTION EMPTY as an alternative to making a geometry/geography column nullable. OGC
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
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
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 spatial index diagnostic procs' most enlightening pieces of information have to do with the filter counts and efficiencies reported at the end of the
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.
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'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
End of the conference season 2008. At least for me, my friends in Belgium are looking forward to their SQL Server Day, coming up soon.
I've been doing talks and demos on SQL Server 2008 Extended Events for a while now, it's one of my favorite parts of the product.
I remember hearing during the SQL Server 2008 beta that there would be diagnostic stored procedures that would produce information about spatial indexes and help
I'm not usually one to post product announcements, but I had to point out that the Service Broker External Activator shipped with the latest (Oct
It's almost November and I'm in the final phase of getting ready for a road trip. In the next three weeks I'll be speaking on
In the past year or so, a few installations had begun to experience problems with the SQL Server 2005 security cache (aka TokenAndPermUserStore) growing too
A friend of mine was asking about the affect of multi-targeting in Visual Studio 2008 on SQLCLR. For an explanation of how multi-targeting works, reference
Although being able to use a GUI tool like SQL Server Management Studio is a nice feature by itself, it's unusual that fixing something in
Extended Events is one of my favorite SQL Server 2008 features and I’ll be speaking about how to use them for problem diagnosis, at the Portland
After reading Isaac's recent blog posting about spatial queries and index hinting, I thought I might add some information based on a query I was working
When SQL Server 2008 shipped, Visual Studio 2008 SP1 and .NET 3.5 SP1 shipped a few days later. Visual Studio SP1 contains some neat enhancements
One of my favorite new features of SQL Server 2008 is extended events. I've written a bunch of blog entries on 'em (use the search,
Folks have always had trouble with the fact that ring orientation is required with spatial instances if you're using SQL Server 2008's geography data type, but not
I came across the following interesting behavior while testing a SQLCLR table-valued function that did work in SQL Server 2005 SP2 but doesn't work at
For attendees of last Thursday’s talk on SQL Server Spatial for the masses, the demo code is located here. Thanks for coming and for your
When SQL Server creates a CLR appdomain to run code in (a runtime appdomain as noted in the previous blog entry), the appdomain normally stays in
.NET (and therefore SQLCLR) divides up running its code (even within the same process like the sqlserver.exe process) into appdomains. The appdomain is like a
I’ve been able to coordinate being home and the Portland (Oregon) SQL Server user group’s meeting schedule, so next week I’ll be speaking “at home”
I've noticed that some folks have written PowerShell scripts that execute against a list of servers. In the scripts, they read the names of the
I received a question today about whether I'd converted my Policy-Based Management examples using SMO (see the multi-part "Programming Policy-Based Management with SMO" series, starting here)
Last week at TechEd Developers, I gave a talk on PowerShell and SQL Server. I mentioned some upcoming changes in RC0, and have just had
SQL Server 2008 RC0 comes with a Readme file and a Release Notes file. It’s always good to read both. In this RC, the readme
There's a newer version of SQL Server 2008 (Release Candidate 0) available on MSDN and Technet. Another performance-related feature (actually its additional information) allows you
There's a newer version of SQL Server 2008 (Release Candidate 0) available on MSDN and Technet. There's a couple of features that show up in
In a blog posting about a few weeks ago, I'd written about noticing a DataSet being created in an Entity Framework program by using the
I’m getting ready to head out to TechEd in Orlando. I’ll be doing a full day of SQL Server 2008 for Developers on Monday, a
It's a good idea when talking to a database to save on network roundtrips. The table-valued parameter in SQL Server 2008 is an example of
This item was mentioned in other blogs too, but just to mention it again (so my SQLCE and Sync Services friends won't think I overlooked
Last fall I'd asked the folks on the data access team about the possibility of including the new SQL Server 2008 data types in the
After posting the last blog entry, I realized that I hadn’t blogged in about a month. Hmmmm… Well, since last month I posted the demos
Every once in a while I’ll get inquires on a paper I wrote in 2004 about the ETW trace providers for ADO.NET (named “Tracing Data
I’m heading off to SQLConnections in Orlando early tomorrow morning. I’ll see starting with a preconference “Day of SQL Server 2008 for Developers” and covering,
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.