(Nicholas Goodman) I’m visiting a Pentaho customer right now whose current “transaction” volume is 200 million rows per day. Relatively speaking, this puts their planned warehouse in the top quintile of size. They will face significant issues with load times, data storage, processing reliability,
Author: SSWUG Research
SQL Server Interview Questions and Answers – Part 4
(Pinalkumar Dave) What is SQL Profiler?
.NET and Active Directory
(sathya) When we had the requirement to read the active directory from .Net, for a project, we were left with many questions and grey areas on mind; sadly there was not much info available on googling. After a thorough study by creating many proof of concepts we got a bit comfortable with the same,
Help speeding up complicated backup process
(Brian Peasland) Currently we have a table in an Oracle database. The size of this table is huge (around 30 to 35 GB). Also, there are a few indexes on this table. This table grows every month by around 2-3GB of data. (R)
Validate Your Refactored SQL Queries with a New SQL Server 2005 Operator
(Chris Goddard) As a developer, how often have you been asked to refactor a SQL statement to increase performance, accommodate changes to database design, support a new database, or for a whole host of other reasons? Often you need to do the refactoring without affecting the results. When you refact
New ‘Orcas’ Language Feature: Query Syntax
(Scott Guthrie) Last month I started a series of posts covering some of the new VB and C# language features that are coming as part of the Visual Studio and .NET Framework “Orcas” release. Here are pointers to the first three posts in my series: –Automatic Properties, Object Initializer and Co
FIX: A hotfix for Microsoft SQL Server 2000 Service Pack 4 may not update all the necessary files on an x64-based computer
When you install a Microsoft SQL Server 2000 Service Pack 4 (SP4) hotfix on an x64-based computer, the hotfix may not update all the necessary files. This problem occurs only when the hotfix has a build number from 8.0.2040 through 8.0.2244.
OracleAS 10g 10.1.2.2 Certified with Apps 11i
(Steven Chan) The wait is over, at least for Linux platforms: Oracle Application Server 10g 10.1.2.2 has been certified with the E-Business Suite Release 11i.
Practical application: Put XSLT 2.0 to work for you
(Edmond Woychowsky) Several weeks ago I received an e-mail from a friend concerning part of an application than I developed several years ago. The application in question had one of the most convoluted XSL style sheets that I developed up to that point. In fact, I wrote an article on one of the part
Getting Optimal Performance with Integration Services Lookups
(Runying Mao and Len Wyatt) Most users see good performance from SSIS packages using out-of-the-box configurations and with little tuning. Sometimes, though, it is necessary to do tuning to get optimal performance. One of the most commonly used transformations is the Lookup transformation. There are