Including one command, SAVE TRANSACTION, that could be useful for multiple iterations of a task with error handling.
Monday, January 31, 2011
Business Intelligence: SSAS 2005: Cube Performance Tuning Lessons
Some good pointers for tuning SSAS 2005 cubes here.
Business Intelligence: SSAS 2005: Cube Performance Tuning Lessons
Friday, January 28, 2011
SQL Server - New Drives Use 4K Sector Size - CSS SQL Server Engineers - Site Home - MSDN Blogs
Bob Dorr talks about drive sectors, new standards, and implications on SQL Server. Somehow this seems to me to be a conspiracy to sell SQL bundled with appliance hardware that is already configured for SQL. I can see why there is a move to a SQL operating system and dedicated appliances rather than dealing with all the intricacies of the o/s and 3rd-party hardware, firmware updates, drive arrays and configuration, memory settings, disk alignment, partitioning, raid configurations, etc.
The implications of incorrect drive sector settings? Risk of losing data, slow performance and not being able to restore databases to upgraded hardware.
In a lengthy discussion this past week I was reminded that Jan 2011 is when the hard drive manufactures agreed to focus on drives with sector sizes of 4K. I have read all the latest materials about this over the past week and you can too. Just search for 512e or Advanced Format Sector sizes and you will find the same articles I read. I concentrated on articles by Seagate, Western Digital and other manufactures.
Why am I talking about this on a SQL Server blog? - The change has impact to your SQL Servers. There are two areas you need to be aware of. PERFORMANCE and DATA INTEGRITY
SQL Server - New Drives Use 4K Sector Size - CSS SQL Server Engineers - Site Home - MSDN Blogs
TwInbox - Use Twitter directly from Outlook.
Twinbox + Access Linked Table to Outlook Folder = Quick and dirty Twitter mining.
If you want to archive your twitter posts, search posts offline, or just hack around with the data, Access allows you to link to Outlook folders, including your Twinbox folders.
If you are using Twitter and Outlook and haven’t tried Twinbox, you’re missing out.
http://msdn.microsoft.com/en-us/library/aa164914(v=office.10).aspx
Wednesday, January 26, 2011
Thursday, January 20, 2011
Programming Solution
Taking the U out of CRUD for performance reasons.
So, to conclude, we can say that if we have to do many updates in a very large table (table with several million rows), we can avoid update statement and use select and insert.
Tuesday, January 18, 2011
Monday, January 10, 2011
Exists + Descendants function
Returns the set of members based on the member attribute in MDX.
EXISTS(DESCENDANTS([Account].[COA],,leaves), [Account].[AccountType].[Revenue])
IBM Information Management Software for z/OS Solutions Information Center
Thursday, January 06, 2011
VBA Functions in MDX | Programming Solution
Left, Right and Contains in MDX.
There are some VBA functions that are implemented in MDX code base and so they are faster than using VBA functions. We can call them “internal VBA” as by Irina Gorbach. Here we will see some example of such “internal VBA” in MDX.
How to Use Excel's CUBESET Function | eHow.com
For Cube function reporting in Excel, one function that doesn’t get translated during a pivot table formula convert is CUBESET.
Here is a way to get the leaves (lowest levels) of a dimension using the cube set formula in Excel 2007/2010.
=CUBESET(connectionstring,filter([Account].[AcctHier].members,isleaf([Account].[AcctHier].currentmember))","Account Leaves")
To retrieve the members, create a list of numbers ending at the CUBESETCOUNT() of above, and use the following formula:
=CUBERANKEDMEMBER(connectionstring,
CUBESET(connectionstring,filter([Account].[AcctHier].members,isleaf([Account].[AcctHier].currentmember))","Account Leaves")
,1))
Retrieves the first member of the set.
Wednesday, January 05, 2011
Download details: Infrastructure Planning and Design
The Infrastructure Planning and Design (IPD) guides are the next version of Windows Server System Reference Architecture. The guides in this series help clarify and streamline design processes for Microsoft infrastructure technologies, with each guide addressing a unique infrastructure technology or scenario.
Subscribe to:
Posts (Atom)
