I’m givin’ ‘er all she’s got!
Or am I?
As I proceed down the path on a consolidation project, I have taken time to pause and ponder...
2010-02-21
668 reads
SQL Server 2005 CLR execution error after restore
I recently restored a SQL Server 2005 database to a testing environment. The database contained several CLR assemblies, when the...
2010-02-21
1,181 reads
New iSCSI Performance Benchmark from Microsoft and Intel
The Windows Server Division blog has a post up trumpeting a very impressive iSCSI benchmarking result achieved with Intel hardware...
2010-02-21
939 reads
Problem Using the Aggregate Function with Calculated Measures
Recently, I was working with a client we were working on a calculated measure using the aggregate function to rollup...
2010-02-21
677 reads
Measure Properties Explained
When configuring measures in SSAS, you want to make sure you address a few important properties. They are show in...
2010-02-21
1,103 reads
Measure Group Properties Explained
When configuring measure groups in SSAS, you want to make sure you address a few important properties. They are show...
2010-02-21
2,883 reads
MDX Member Functions
There are a large number of Member functions in MDX that do everything from returning ancestry of a member to...
2010-02-21
1,690 reads
Free Data From Across the Pond
Ok so I know a statement like that will whip some of you into a frenzy, but it’s true. No...
2010-02-21
534 reads
I'm Speaking at SQLLunch
I am excited to be speaking at SQLLunch.com on March 1st. SQL Lunch is a great website event where Host...
2010-02-21
348 reads
Microsoft AdCenter and SQL Server Analysis Services 2008
There is a recently published whitepaper that talks about Microsoft AdCenter using SSAS 2008 to accelerate performance over 2005. Most...
2010-02-21
526 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...