(Hugo Kornelis) Greg Linwood, a fellow SQL Server MVP, has started a series of articles in which he attempts to prove that having a clustered index on each table is not a good practice. However, he has failed to include the effects of fragmentation into account, so I decided to run some tests for my
Author: SSWUG Research
Splitting data into training and test data sets using CHECKSUM
A common scenario in creating Mining Model is to predict their accuracy by running them against a test data set which is different from the training data. This prevents the problem of over fitting and gives a better measure of the accuracy of the generated models.
MDX Operators: The IsLeaf() Operator: Conditional Logic within Filter Expressions
(William Pearson) In this article, we will examine IsLeaf(), once again as a conditional logic modifier, but within the context of a filter. Combining IsLeaf() with the MDX Filter() function is another way we commonly see it in action in the business environment, and our exposure to the practical as
Pivot Query
(Chris Eaton) I often see questions on forums asking how to convert rows to columns and columns to rows. In this posting and the next I’ll give you two queries that will do exactly that for you. Thanks again to Serge Rielau for the material from his IDUG presentation.
A Guide to Easing Oracle E-Business Suite Management: ZeroERROR Object Migration
In this guide, we will discuss many of the operational costs and resource drains of implementing and managing the Oracle E-Business Suite and discuss how to reduce effort and eliminate errors using a ZeroERROR object migration solution. (R)
Dynamic XForms submissions
(Kevin Kelly, Jan J. Kratky and Steve K Speicher) XForms is an ideal open standards technology for collecting and submitting data from a wide variety of Web-capable platforms. Creating a single input form for collecting data from many sources is common. However, each location filling out the form ma
Stepping through Sub-Queries in Oracle
(Jagadish Chatarji) This is the first article in a series concentrating on working with sub-queries in Oracle. Sub-queries really have tremendous depth. In this series I will show you several scenarios where they can be efficiently used to retrieve information from Oracle databases.
Financial benchmarking helped by CPM, XBRL
(Hannah Smalltree) Competitive context is critical for financial data. A company’s revenues and costs have new meaning when stacked up against its competitors’ numbers. So for years, organizations have benchmarked performance by manually comparing financial results with those of competitors to g
How to modify sqlnet.ora file to restrict database access?
(Brian Peasland) I am currently trying to restrict access to my database through listing the IP addresses with permission. I read that I should modify my sqlnet.ora file. The problem is I do not have this file. When I create it and specify the parameters, the listener gets whacked out and stops work
Using MSXML3.0 with VB 6.0
(Jayaram Krishnaswamy) If you’re a VB programmer interested in learning how to parse and process XML documents, and use them in your applications, this article can help. You’ll learn about MSXML properties, how to create an XML document using VB 6.0, and more.