SQL in the City Comes to Seattle in 3 Days
Last week I spoke at SQL in the City 2015 in London, and it was a great event. We had...
2015-10-23
621 reads
Blog Posts
SQL in the City Comes to Seattle in 3 Days
Last week I spoke at SQL in the City 2015 in London, and it was a great event. We had...
2015-10-23
411 reads
SQL Server – Columnstore Index creation error: A columnstore index cannot be created on a SPARSE column
Hi friends, as we know that in SQL Server 2012 a new feature Columnstore index was introduced which made a...
2015-10-23
640 reads
Talk to Me at PASS Summit
If you’re going to PASS and you want to have a chat, I want to talk to you. If it’s...
2015-10-23
508 reads
Webinar – What’s New for Business Intelligence in SQL Server 2016
I’ll be giving a webinar for MSSQLTips.com on Thursday 29th October 2015.
The title is What’s New for Business Intelligence in SQL Server...
2015-10-23
833 reads
Git Push in SQL Source Control
I’m excited. Git support is growing in SQL Source Control and the release recently contains Git push/pull support. If you...
2015-10-22
1,940 reads
Histograms and Events
In this article I show how to use and configure the histogram target. In addition, I explain how to get to the data trapped into this target. Lastly, I...
2015-10-22
4 reads
Performance and using of VARCHAR boxes as filters in SSRS reports
Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...
2015-10-22
13 reads
Performance and using of VARCHAR boxes as filters in SSRS reports
Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...
2015-10-22
13 reads
Step by Step SSIS–Derived Column Transformation TIP # 120
Dear Friends,
In the series of Step by Step SSIS , Zero to Hero in SSIS this is another post in which...
2015-10-22 (first published: 2015-10-18)
2,494 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