Spatial index compression in SQL Server Denali
Since SQL Server Denali adds support for index compression of spatial indexes, using the same options as data and index compression in SQL Server 2008 and
Since SQL Server Denali adds support for index compression of spatial indexes, using the same options as data and index compression in SQL Server 2008 and
After the last post on new warnings in SQL Server Denali Showplan, just for the fun of it, I had a look at the XML
Sort and hash warnings can be found using SQL Server profiler, but they don't appear in query plans like "Columns With No Statstics" warnings in
Earlier this month I noticed that SQL Azure, with the latest upgrade has a version of 11…something (actually 11.0.1467.26, to be exact). And I wondered,
With the release of SQL Server Denali approaching, (some Denali features are already available in SQL Azure Database), I've decided its time to sift a
The new Semantic Search feature of SQL Server Denali enhances full-text search by letting you do a search on the meaning of documents. To use
I've been looking at full-text query plans in Denali lately, and looking at the SQL query plan for the full-text part, there isn't much to see
Saw a request on the SQL Server spatial forum this morning for routines that would decompose a geography type to a set of Lat/Longs. A
I've been working lately with SQL Server Denali's Semantic Search feature. There's a more complete description of this feature (as well as how to set
SQL Server Denali's new Filetable feature and full-text search are made for each other. Set up database for non-transactional filestream access with a directory name,
I've been trying this out every day or so since I'd heard about the update (originally named the July 2011 Service Release), but I'd forgotten
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.