(Arshad Ali) In the first part of this series we looked at processing performance, query performance and hardware resources for your SSAS environment. In this tip, I am going to share best practices and performance optimization techniques for source system design and network settings for your Analy
Other News
Common Table Expressions
Common Table Expressions Common Table Expressions are a feature of the SQL language that has grown on me over time. They are mandatory for some forms of query recursion, at least in SQL Server. However, I don’t have a lot of need for recursive queries. I find I use them most often for simplifying complicated queries. If you ever do […]
JavaScript Wrap Up
SSWUGtv With Stephen Wynkoop In this episode watch this informative interview with Devin Knight – SQL Server 2012 BI Guru. Steve and Devin talk about the concept of Self-Service Business Intelligence – including the Microsoft approach to self help in the form of a new product, PowerView. Watch the Show JavaScript Wrap Up Today we wrap up the topic of […]
.NET 4.5 Improvements for Cloud and Server Applications
(S.Somasegar) I’ve had multiple meetings recently with customers and press where the topic of .NET development has come up, particularly as it relates to the cloud and server.
jQuery Support for HTML5 Data Attributes
(V.N.S Arun) As HTML 5 has become more popular among web developers recently, another popular web client framework jQuery is also proving to be up to date in providing its support for HTML 5. In this article I will be discussing the data attribute features of HTML 5 and the support offered by jQuery
An Introduction To WebSockets
(Shwetank Dixit) Lately, there has been much talk about the WebSockets API, and how it could change the way web applications are developed. In this article, we will take a look at
DBMS_XPLAN.DISPLAY_CURSOR
(Nikolay Savvinov) In this post, I continue on the topic of examining SQL plans. I will talk about one DBMS_XPLAN function, DISPLAY_CURSOR (because it’s probably the most useful one when troubleshooting ongoing performance issues, and also because other functions have a lot of similiarity to it). I
Sqlplus Dashboard For RAC
(Jagjeet Singh) I have been passionate to work with CLI due to flexibility, lightweight and easy access. Long back, I had an idea to write a sqlplus script to provide a dashboard kind of utility but could never figure out the auto refresh functionality until unless Tanel & Adrian provided moats.
View Link Accessor Usage Performance Side Effect
(Andrejus Baranovskis) View Link Accessor is available when there is View Link defined and typically is used in ADF to retrieve detail collection from master row in VO row implementation class. Officially this is recommended approach to retrieve detail collections programmatically.
Creating Type Aliases in C#
(Richard Carr) The using directive of the C# programming language is often used to create namespace aliases, allowing types with matching names that appear in separate namespaces to be easily accessed. A lesser known use of the directive is to create aliases for types.