(Jeff J. Li) The SAP NetWeaver Business Intelligence (SAP BI) is an integral part of the SAP NetWeaver 2004s application server. Designing extract, transform, and load (ETL) jobs to load data into and extract data from SAP BI is often a time-consuming task. This article provides a step-by-step guide
Other News
Fixing a Quirk of VB Lambda Expressions
(Paul Kimmel) A lot of very smart and friendly people from Microsoft help me. For this reason, I try not to be critical and limit criticism to constructive criticism. This doesn’t mean everything that comes out of Redmond is perfect, but much of it is exceptional.
Working with Lambda Expressions
(Brian Mains) Lambda expressions reduce the amount of work needed when iterating through data. All enumerable data is queryable through LINQ through the use of a SQL-like query (what I mean by that is the query looks like SQL, but is a different flavor). LINQ has an in-built mechanism to loop throu
Export/Import of Optimizer Statistics in Oracle
We had talked about DBMS_STATS.SET_TABLE_STATS in one of our previous Oracle blog posts and had also covered the equivalent options in SQL Server 2005 in another post. That post also pointed out to the article by Joe Chang about the export/import of statistics in a SQL Server 2000 environment since
Monitoring Stored Procedure Performance with sys.dm_exec_cached_plans
(Greg Larsen) In my last article (http://www.sql-server-performance.com/articles/per/tsql_statement_performance_p1.aspx) I showed how to use the sys.dm_exec_query_stats dynamic management view (DMV). This article showed how to use the information from this DMV to determine what TSQL statements wher
Dimensional Model Components: Dimensions Part II
(William Pearson) We learned, in Dimensional Model Components: Dimensions Part I, that dimensions form the foundation of the dimensional model. They represent the perspectives of a business or other operation, and reflect the intuitive ways that information consumers need to query and view data. We
Is MySQL getting faster?
(Mark Callaghan) Is MySQL getting faster over time? I think so. It is difficult to keep things fast as features are added, but many operations have gotten faster between 4.0.26 and 5.0.54 and the performance of 5.0.54 is much improved over 5.0.37. I ran a few tests to measure the difference: –du
It’s Less Efficient To Have Low Cardinality Leading Columns In An Index (Right) ?
(Richard Foote) A common myth or mis-perception is that when deciding how to order the columns in a concatenated, multi-column index, one should avoid placing low cardinality columns in front.
Filegroups Part II: Separating objects
(James Luetkehoelter) In my last post on filegroups (it seems like ages ago), I argued that separating tables and their non-clustered indexes between two different filegroups, with each filegroup on a separate I/O path can improve performance. That article was met with skepticism. I think that’s a g
Import, Export, Copy and Delete SSIS Packages in SQL Server 2005
I have seen many of the changes with SQL Server 2005 Integration Services (SSIS) versus SQL Server 2000 Data Transformation Services (DTS). Integration Services certainly has much more functionality out of the box than DTS and I am learning SSIS as my projects move forward. One item that has seeme