Customer Satisfaction Survey
We decided to create a customer satisfaction survey and send it to all our customers. The goal of this post...
2017-09-01
683 reads
Information Measurement with SQL Server, Part 2.1: The Uses and Abuses of Shannon’s Entropy
By Steve Bolton
…………In the first installment of this wide-ranging series of amateur tutorials, I noted that the Hartley function indeed...
2017-08-31
928 reads
SQL Server: SARGability
SARG is short for Search Argument. This is an important tuning term and something every developer and DBA should know....
2017-08-31
4,528 reads
Bulk Inserting Build Data–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-31
682 reads
Azure Archive Blob Storage
Last week Microsoft released a public preview of a new service called Azure Archive Blob Storage, offering customers a lower-cost...
2017-08-31
1,035 reads
Automatic Seeding & Compression
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-31
1,048 reads
Getting the Hyperlink from Excel
I had a spreadsheet of data that contained hyperlinks. In this case, it was a series of Microsoft Knowledge Base...
2017-08-30
714 reads
Columnstore Indexes – part 111 (“Row Group Elimination – Pain Points”)
Continuation from the previous 110 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
The topic of the Segment Elimination (aka...
2017-08-30
700 reads
What you need to know about memory limits on SQL Server
Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max...
2017-08-30
355 reads
System-Versioned Temporal Tables
Every once in a while, I like to take a moment and learn something new about the latest SQL Server...
2017-08-30
1,197 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