(David Fitzjarrell) In a forum I contribute to the following question was asked: “Can adaptive cursor sharing (ACS) depend on execution order?”
Other News
SLGrid – jQuery/Knockout client component
(Slavko.Parezanin) SLGrid is jQuery/Knockout client component. Can be used in any web development platform: ASP.NET/MVC, PHP, Java, … and with any Database system.
DB2 for z/OS: How Low Can Synchronous Read Wait Time Go?
(Robert Catterall) Short answer: lower than I’d previously thought.
What’s the Big Deal About Query Optimization? Part 1
(Suresh Sane) From the early days of SQL, database administrators (DBAs) have specified the what without worrying about the how. The prevailing assumption was that query optimization takes care of the how. A lot has changed since the days of relational databases, and SQL queries have become increasi
SQL Server Enterprise or Standard? A Hands-On Planning Tool to Get it Just Right
(Don Boxley) For my last blog, “Dead Birds in the Storm of a SQL Server Audit: 3 Tips to Keep from Getting Killed on Licensing Costs,” I talked about reducing your overall SQL Server costs by changing your mix of SQL Server Enterprise edition and Software Assurance (SA).
SQL Server FileStream
Recently I received an inquiry regarding the use of SQL Server FileStreams. The database was designed on one machine, and restoring to a new machine made it difficult to get the file streams to work again. If you follow this link to Microsoft they provide an overview of what a filestream data type is and how it is implemented. http://technet.microsoft.com/en-us/library/bb933993%28v=sql.105%29.aspx […]
The Absolutely Awesome jQuery Cookbook Released
(Suprotim Agarwal) This jQuery cookbook covers the latest jQuery v1.11.1 or 2.1 and jQuery UI 1.11.2 versions and contains 120+ practical jQuery recipes (about 70 Recipes and 50+ sub-recipes) you can use in your websites and projects right away.
AJAX-Enabled WCF Service Using JSON
(Sarita Rath) This article explains the use of JSON in WCF and AJAX-enabled WCF services.
MdsMetadataResourceProvider Error in ADF 11.1.1.7
(Andrejus Baranovskis) If you have migrated ADF application to ADF 11.1.1.7 version recently, you may see error in the log related to the internal MetadataResourceXmlImpl class usage.
A discovery – Index Condition Pushdown can cause a slowdown after all
(Sergey Petrunia) MariaDB 5.5 and then MySQL 5.6 got Index Condition Pushdown (ICP) optimization (initially coded by yours truly). The idea of ICP is simple: after reading the index record, check the part of WHERE condition that can be computed using index columns, and only then read the table recor