Columnstore Indexes – part 62 (“Row Groups Trimming”)
Continuation from the previous 61 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have spoken a lot of times...
2015-08-12
572 reads
Blog Posts
Farewell Scott McKenzie
Scott McKenzie was the DJ of Mix 105 here in Orlando for an astounding 24 years and that’s been the...
2015-08-12
636 reads
Hadoop and Microsoft
In my Introduction to Hadoop I talked about the basics of Hadoop. In this post, I wanted to cover some of...
2015-08-12
3,192 reads
Here’s the New #Excel 2016 Chart Types!
The Office 2016 Public Preview is now available for download! Included in the preview of Excel 2016 are a handful...
2015-08-12
1,160 reads
How easy or difficult to write dynamic SQL ? TIP#110
This is one of the challenge for most of the developer to write dynamic SQL. Generally we follow the approach...
2015-08-12
1,281 reads
oPASS & MagicPASS Meeting Tonight
David Pless is presenting:
Query Store is a new feature in SQL Server 2016, and is also available in Azure SQL...
2015-08-12
565 reads
Open SQL Server Virtualization Q&A Webinar – 8/19
Next Wednesday, August 19th, at noon Eastern the PASSVirtualization Virtual Chapter will be holding an open questions and answers session...
2015-08-12
528 reads
Please Welcome Our New Certified SQL Server DBA’s!
Today we celebrated the last session of one of our Become a SQL Server DBA classes. This course takes people...
2015-08-12
627 reads
Red Gate SQL Source Control v4 offers schema locks
Red Gate Documentation Update
Looks like the rapid release channel now has a great feature for locking database objects that you...
2015-08-12
284 reads
Step by Step Guide to SQL Server AlwaysOn
AlwaysOn technology in MS SQL Server is designed to increase the availability of your database, it is another step toward...
2015-08-12 (first published: 2015-08-06)
16,889 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers