Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Ad for State of Database Landscape survey
The Voice of the DBA
 

Be Wary of Data

I fly a lot, as you might have guessed if you read my blog regularly. In 2025, I've been on 56 United planes as I write this, with about 10 left to go before the end of the year. One of the things United does is sometimes send out a quick "survey" after a flight, checking to see if everything went smoothly. I don't always fill these out, but recently I decided to give some feedback as I had a great experience.

I really wanted to just complement the onboard crew, but the survey was quite a few pages (10?) and a lot of questions. I started to try and fill it out, but lost focus after a few pages. This felt like a chore, and I started to just randomly click some of the selections asking me to rate things 1-10. I wasn't really rating the items; I was trying to get done. Eventually, I bailed on the survey and didn't complete it, but that got me thinking about the data from these surveys.

I'm somewhat detail-oriented and I try to do a good job, but I couldn't finish the survey. How many others just click through things and don't really give an accurate picture of their feelings?

A similar situation occurs at work, where we have an HR rating system (Thymometrics), which I really like. Over time, it helps me to keep an eye on how I feel about my job, the company, and my general attitude about work. We get quarterly reminders to fill this out, but I know quite a few people who don't fill it out at all, or just click on it and save the ratings without thinking about them. Another place data might be suspect.

At work we get feedback on various product metrics, in addition to uninstall feedback and product feedback, sometimes with a rating that people click. Is that what they really think about their experience or did they just click the first thing they saw? Or did they mis-click the wrong thing, and they can't change their rating (clicking 2 when they meant 9).

There is a lot of data that organizations collect from people that is very subjective. Across a large group of users, this should provide some sort of indication of how people feel, but if the sample sizes are small, can you really use this data? I think it's easy for people in product management, marketing, and sales to view this data as much more accurate than it might be. I know I'm always wary of any outliers when I see feedback, and often I want to know how many people contributed.

Unless it's a decently large number (100s at least) and there is a clear trend from many people (> 5%), I tend to discount the data as an outlier and not representative.

I'm not sure how many of you do this, but critically examine data and be wary of drawing conclusions. Especially when you are getting impressions, feelings, and opinions from others.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

PASS Summit 2025 is fast approaching
 
 Featured Contents
SQLServerCentral Article

Why Indexes are Important Beyond Faster Execution of Queries

Saravanan Venkatesan from SQLServerCentral

Learn how indexes can help you with more than just querying data.

External Article

SQL EXISTS Use Cases and Examples

Additional Articles from MSSQLTips.com

I’ve seen the SQL EXISTS keyword in Microsoft SQL Server T-SQL code and don’t understand it well. What does it do? How do I use it? Are there best practices around SQL IF EXISTS?

From the SQL Server Central Blogs - DBAs should never run SSMS under their everyday Windows account

peter.skoglund from SQL Development Wizard

 DBAs should never run SSMS under their everyday Windows account
If you open SSMS under the same Windows identity you use for email, browsing, and chat, you bring all that...

From the SQL Server Central Blogs - The Feedback Multiplier: How Leaders Can Turn Input into Innovation

Chris Yates from The SQL Professor

In every organization there is a hidden currency more valuable than capital, more enduring than strategy, and more transformative than technology. That currency is feedback. Leaders who learn to...

Learn T-SQL Querying

Learn T-SQL Querying

Additional Articles from SQLServerCentral

Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers

 

 Question of the Day

Today's question (by Uwe Ricken):

 

Locking Hierarchies

You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
        o_orderkey,
        o_custkey,
        o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;

What locking hierarchy will Microsoft SQL Server use?

 

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Azure SQL Database MAXDOP

When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?

Answer: 8

Explanation: The default was changed in Sept 2020 to 8. Ref: Configure the max degree of parallelism (MAXDOP) in Azure SQL Database and SQL database in Fabric - https://learn.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism?view=azuresql

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2019 - Development
Collation errors...what is best way to deal with it? - Hi I have a SP that occasionally get this error: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. The query is close to 1000 lines long so I have no idea where this is without examining each line.  Is there a way to set the collation in the SP […]
Was the index created or not? - Hi everyone I am getting an error when I create the index but I don't get any errors when I save and run the SP.  Does this mean the index was created or not?  Is there a way to verify?  The index is on a temp table. Thank you
Some query values change when query is run but not others. Why? - Hi everyone I have a 1000 line SQL query that is too long to put here so I will explain the basic logic and what the issue is. The query processes stock market data and produces a daily metric for each symbol.  There are close to 4000 symbols that get the metric created daily. I […]
using different credentials when debugging ssis - hi, now and then i want one connection in my ssis pkgs to use different creds from others.   It comes down to my admin vs my regular id.   And that basically i'm somewhat limited when i run vs under my admin acct.   Is there a way to do this?
Integration Services
SSIS Package is reporting successful however is short 80-100k records - Good morning all, I have been running into a very random weird issue that I am hoping someone has experienced and can stop my head from spinning. We have 4 environments we run about 150 flows that connect to Oracle to pull data into 4 different SQL Servers. Let's called them Dev1, Dev2, Test and […]
Editorials
We Should Demand Better - Comments posted to this topic are about the item We Should Demand Better
Article Discussions by Author
Estimated Rows - Comments posted to this topic are about the item Estimated Rows
Identify Unused Tables in SQL Server and Azure SQL - Comments posted to this topic are about the item Identify Unused Tables in SQL Server and Azure SQL
SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques - Comments posted to this topic are about the item SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques
T-SQL Fundamentals - Comments posted to this topic are about the item T-SQL Fundamentals
Murach's SQL Server 2022 for developers - Comments posted to this topic are about the item Murach's SQL Server 2022 for developers
AlwaysON health check alerts - Comments posted to this topic are about the item AlwaysON health check alerts
Bat and SQL script to generate DB user permissions for all Databases in SQL server - Comments posted to this topic are about the item Bat and SQL script to generate DB user permissions for all Databases in SQL server
PWDCompare - Comments posted to this topic are about the item PWDCompare
SQL Server 2022 - Development
Parameter sniffing issue with different minutes as opposed to using midnight - Hej, I'm not facing this issue but as I was working another parameter sniffing issue I came to think about this and if it might cause an issue? So I'm more looking for your experience in the past and more an answer of kind "Nah, you'r good" or "You should definitely go with rounding to […]
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -