Introduction to Using Profiler with SSAS 2008
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
594 reads
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
594 reads
This whitepaper from Greg Lowe talks about the important strategy behind disk partition alignment. This is focused mainly in SQL...
2010-02-21
513 reads
Ok so I know a statement like that will whip some of you into a frenzy, but it’s true. No...
2010-02-21
527 reads
I am excited to be speaking at SQLLunch.com on March 1st. SQL Lunch is a great website event where Host...
2010-02-21
341 reads
There are a large number of Member functions in MDX that do everything from returning ancestry of a member to...
2010-02-21
1,681 reads
When configuring measure groups in SSAS, you want to make sure you address a few important properties. They are show...
2010-02-21
2,874 reads
When configuring measures in SSAS, you want to make sure you address a few important properties. They are show in...
2010-02-21
1,094 reads
There is a recently published whitepaper that talks about Microsoft AdCenter using SSAS 2008 to accelerate performance over 2005. Most...
2010-02-21
521 reads
Recently, I was working with a client we were working on a calculated measure using the aggregate function to rollup...
2010-02-21
665 reads
One of the most aggravating things when work with the SSIS expression language is when you have to combine file...
2010-02-20
2,055 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers