IgnoreUnrelatedDimensions in Analysis Services 2008
Once of the more common issues with working with data in a cube is that it does not always line...
2010-02-22
465 reads
Basic SQL Querying From PowerShell
I promise to make this worth your time. (Oops, I better make this quick.)
Alright so with PowerShell if you open...
2010-02-22
1,282 reads
Christmas Holiday
We booked a vacation over the weekend, so I’m marking off the week before Christmas as vacation this year. Hoping...
2010-02-22
933 reads
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
609 reads
I Feel Like a Heel
It’s now 3 events that I’ve canceled in the last 6 months, and a 4 or 5 more that I’ve...
2010-02-22
881 reads
What Does It Look Like When Everything Is Okay?
I'm a big believer in looking at systems when everything is okay. I'm not the only one, as Joe Richards, a...
2010-02-22
876 reads
What’s up with the reads?
So the other day I read Andrew Kelly’s article, Do You Have Hidden Cache Problems, in the latest electronic edition...
2010-02-22
371 reads
When Should You Start Speaking?
I know it’s daunting and a little intimidating, but there are so many people with knowledge to share. I see...
2010-02-22
937 reads
City of Orlando Switches to Google Email
This happened earlier in the year, finally getting around to writing some notes on it – you can read more here....
2010-02-22
734 reads
Experiments with Data Compression in SQL Server 2008
Data compression is an Enterprise Edition only feature that was added in SQL Server 2008. It allows you to use...
2010-02-22
2,114 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...