Designing Reports with Custom MDX Queries – part 1
This article is the first in a three-part series
On the Microsoft Developer Network (MSDN) forum for Reporting Services and other...
2011-03-27
1,372 reads
Blog Posts
SQL Server Crossword #3 – Solution
Here’s the solution to SQL Server Crossword #3.
I hope you enjoyed it. Let me know if you would like me...
2011-03-27
1,013 reads
Index Black Ops Series
Previously, in a TSQL2sDay index summary post, I started a series on the DMV sys.dm_db_index_operational_stats. The series investigates how the...
2011-03-26
845 reads
An Analogy is like a Tree….
For years, I’ve been trying to express how everything ties into everything else. A big part of understanding any given...
2011-03-25
490 reads
DevWeek 2011 – Day 1
Unfortunately, I couldn’t be in two places at one time, there were two tracks dedicated to the SQL Server DBA...
2011-03-25
717 reads
How Many Bytes Are In My Column? – T-SQL Functions
One of the things you want to be aware of when writing T-SQL is using the proper function for a...
2011-03-25
4,055 reads
NOLOCK for Developers
What is NOLOCK?
NOLOCK is a table hint for SQL Server that tells the engine to not take locks and ignore...
2011-03-25
1,747 reads
OUG Back to Basics Event – London Mar 2011
First Things First
At UKOUGs’ Back to Basics Special Event held in London today (Mar 24th), Niall Litchfield presented a very worthwhile...
2011-03-25
624 reads
The Mystery Of The Slow Last Row
Things Go South
Recently I was troubleshooting a piece of software that archives data out of a very active import table....
2011-03-25
1,696 reads
Why I don’t like NULLs and Nullable Columns
As I imagine (or hope), the majority of us adhere to some form of standards in the environment that they...
2011-03-25
751 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers