(Uwe Hesse) In 10g, we introduced the automatic retention of old Optimizer Statistics. We might want to compare the Optimizer Statistics, presently in use with the old stats. This posting gives an example that shows how to do that.
Other News
Generating ASP.NET MVC View Controls According to Xml Configurations
(Gil Fink) Last week I was consulting about ASP.NET MVC at a customer. One of the customer project requirements is to generate forms according to Xml configuration files. In this post I’ll offer an end-to-end solution to this requirement.
Parameter Wednesday – DB CFG – HADR_TIMEOUT
(Ember Crooks) Specifies the time (in seconds) that the HADR process waits before considering a communication attempt to have failed.
ColdFusion 10 – Looping Over Function Arguments
(Ben Nadel) Since ColdFusion 9.0.1, CFScript has supported using a FOR-IN loop construct for both arrays and structures. In arrays, it loops over the indices; in structures, it loops over the keys. Typically, this is a clear-cut piece of functionality.
How important a primary key can be for MySQL performance?
(Maciej Dobrzanski) How important a primary key design can be for MySQL performance? The answer is: Extremely! If tables use InnoDB storage engine, that is.
SSAS – Best Practices and Performance Optimization – Part 1 of 4
(Arshad Ali) There are several aspects that can take a toll on performance for your Analysis Services cubes. Some problems could be related to the source systems, some could be because of poor design of your cube and MDX queries and some could be related to network issues. In this tip series, I am g
C# Constructor Newbie Question
$$SWYNK$$ Featured Article(s) How to Backup (Part 1) Since data is the lifeline of your company, you, as a Data Professional, need to ensure that your data is protected, recoverable, usable, secure, and so on. One of the first tasks that you should perform as a Data Professional is to ensure that the data is properly backed up. This seems […]
Semantics Will Bridge the Gaps for Future Technologies
(L.Scagliarini) As a kid growing up in Milan I was obsessed with two things: sports and the future. If I wasn’t in the local park playing soccer, I was lost inside an issue of the futuristic sci-fi comic El Eternauta (upon reflection, perhaps a bit dark for a kid!). In those days, Italian televisio
Creationism: Custom Data-Bound Control for ASP.Net
(metaomniliquant) This post was a result from a question on Code Project asking what the GetData method is. This post will be a basic tutorial on how to create custom data-bound controls for ASP.Net. General knowledge of ASP.Net development with C# will be assumed.
When to Use Custom XPath Functions in the SOA Suite
(Jan Kettenis) If you want to know how to create custom XPath functions, then have a look for example at Anthony Reynold’s Blog entry on the topic. I have little to add to that excellent posting except for how to add parameters, which is done using the tag as in the following example: