SQL Server 2008 SP1 Cumulative Update 13
Microsoft has released SQL Server 2008 SP1 Cumulative Update 13, which is Build 10.00.2816.00. I count twelve fixes listed in...
2011-03-22
553 reads
Blog Posts
SQL Server 2008 SP2 Cumulative Update 3
Microsoft has released SQL Server 2008 SP2 Cumulative Update 3, which is Build 10.00.4279.00. I count 25 fixes listed in...
2011-03-22
1,237 reads
SSAS - Measures or Attributes in Multiple Display Folders
I had a client recently show me a neat little tip that I thought I would share.In the cube he...
2011-03-22
1,285 reads
SSAS errors: Errors in the metadata manager. The dimension with ID of ‘xxx’ referenced by the ‘yyy’ cube, does not exist.
When deploying or processing a cube or dimension you may encounter an error similar to this:
Errors in the metadata manager. The...
2011-03-22
1,264 reads
Statistics, row estimations and the ascending date column
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-22
2,077 reads
What Are Your Indexing Strategies?
A couple weeks ago, I got some pretty great new. The book proposal that I had submitted to Apress was...
2011-03-22
637 reads
21st March - Today is International Day for the Elimination of Racial Discrimination
How to Counter Intolerance, Adapted from UNESCO’s Recommendations
1. The Battle Against Intolerance Requires Law
Every Political Entity needs to reinforce Human...
2011-03-21
1,114 reads
Blog Syndication
I got sent an email recently asking how I went about syndicating my blog on some of the popular SQL...
2011-03-21
1,741 reads
Communication
It sure seems like there’s a lot of miscommunication between developers and database specialists. In fact, the communication can become...
2011-03-21
2,615 reads
Database Mail – Collection of SQL Server Scripts
As part of my blogging I’ll be periodically providing readers with a collection of my scripts which I use on...
2011-03-21
943 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers