Most RecentMost ViewedMost LikesHow It Works: FileStream (RsFx) Garbage Collection First published on MSDN on Jun 23, 2011 In a previous blog I outlined how file stream transactions work and retain the before and after images of the file to allow various forms of recovery. Understanding SQL Server’s Spatial Precision FilteringFirst published on MSDN on Apr 02, 2015 A spatial index is not precise on its own.Exploration de la gestion de l'UTF16 avec SQL ServerFirst published on MSDN on May 28, 2014 Bonjour à tous,J'ai récemment eu à me pencher sur le détail de l'implémentation de la gestion de l'encodage Unicode UTF16 dans SQL Server.How It Works: FileStream (RsFx) Garbage Collection–Part (2)First published on MSDN on Apr 04, 2014 In a previous post I outlined the basics of File Stream, garbage collection: http://blogs.Spatial Index is NOT used when SUBQUERY usedFirst published on MSDN on Dec 09, 2013 I have found the following link to be invaluable when working with and tuning SQL Server Spatial indexes: http://technet.Spatial Indexing: From 4 Days to 4 HoursFirst published on MSDN on Nov 19, 2013 Over the past month I have been involved in the optimization of a Spatial Index creation/rebuild.Secondary Access to File Stream(s) File, In Open Transaction, May HangFirst published on MSDN on May 04, 2011 This post is directly from an issue I have been working on.SQL 2008 FileStream Fails to Enable After Setup on Cluster that uses Veritas MountpointsFirst published on MSDN on Jul 29, 2010 Recently a customer ran into an issue where they had successfully installed SQL Server 2008 SP1 on a 2 node Windows 2008 cluster.Write method of OpenSQLFileStream is generating Event 2000 Errors on SQL ServerFirst published on MSDN on May 13, 2010 One of my customers was experiencing a lot of event 2000 errors on the SQL Server Machine.Les « Tables Valued Parameters »First published on MSDN on Nov 19, 2009 Technorati Tags: Katmai,SQL Server,sql2k8,sql2008,MSSQLAvant la version SQL Server 2008 il n’était pas possible de passer une table comme paramètre d’une procédure stockée.
