To be able to drill into multidimensional cube data at several levels, you must implement all of the hierarchies on the database dimensions. Then you'll create the attribute relationships necessary to optimize performance. Analysis Services hierarchies offer plenty of possibilities for displaying the data that your business requires. Rob Sheldon continues his series on SQL Server Analysis Services 2008.
Find out what makes Mnesia, the Erlang-based database management system, perfect for distribution across a network of computers.
For the past several weeks, I have been running a poll on www.bradmcgehee.com, asking visitors if they thought that DBAs...
Does it make sense to set up another instance of SQL Server just for a power user? Is it a good use of resources? Steve Jones comments today on this DBA tool for enhancing performance.
How to efficiently calculate moving averages with SQL Server using Stock Market data.
The Microsoft SQL Server Connectivity team has a survey on the need for ODBC support for other platforms. If you use SQL Server from other platforms, let them know.
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
The Data Mining Query Task can be used to run prediction queries based on data mining models built in analysis service.
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers