T-SQL Tuesday #005: Monitoring Reports with SSRS
This post is a T-SQL Tuesday Entry, hosted this week by Aaron Nelson on the topic of “Reporting”. (It got...
2010-04-13
1,052 reads
This post is a T-SQL Tuesday Entry, hosted this week by Aaron Nelson on the topic of “Reporting”. (It got...
2010-04-13
1,052 reads
[Edit] Since writing this, I've realized that the true reason behind this was that my account was not a member...
2010-04-12
1,122 reads
The April meeting went well. I had hoped that the prospect of a couple of Technet subscriptions would increase attendance...
2010-04-12
394 reads
Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.
Community...
2010-04-07
474 reads
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
2010-04-07
36,810 reads
A reminder to anyone in the Brevard County Florida area:
The SCSUG monthly meeting is at 6:30 on Thursday, April...
2010-04-06
288 reads
Totally pointless, but fun. Run it to decode the message.
DECLARE @Message varchar(20)
SET @Message = '????????????'
DECLARE @Decode Table(
DSeq tinyint,
DKey smallint
)
INSERT INTO...
2010-04-03
714 reads
When you ask a question on the forums, you'll often get responses that certain ways of doing things are inefficient...
2010-04-02
441 reads
I started blogging a few months ago and since I started writing my own blog, I've been a much bigger...
2010-04-01
482 reads
Someone asked a question in the forums the other day and I realized it would make a pretty decent blog...
2010-03-28
8,767 reads
I recently had to copy an Azure SQL database (SQL db) from one subscription...
Ivan Jelić, Group CEO at Joyful Craftsmen, reflects on what separates AI success from...
By Chris Yates
AI is no longer a niche capability – it is a leadership catalyst. As...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item SQL Server Columnstore Index Fragmentation
Hi i was surprised to see the approach my coworkers used to sunset talend...
The columnstore index is absolutely different than the traditional rowstore b-tree index. Because of this, it doesn't suffer from the same kind of fragmentation across pages as the b-tree index. Yet, it does suffer from a type of fragmentation brought about by an excess of deleted rows in a rowgroup and a lack of compression of storage because more things are in the delta store. While b-tree indexes use dm_db_index_physical_stats to show fragmentation, which system tables or DMVs can be used in SQL Server (prior to SQL Server 2025) to determine columnstore fragmentation?
See possible answers