Confusion of An Old Technologist
As someone who still actively pursues a career in technology, I’m a little on the older side. I got started...
2017-02-23
406 reads
The Scary DBA
Estimated Costs of All Queries
One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty...
2017-02-22 (first published: 2017-02-20)
2,485 reads
Export All Plans From Cache to a .SQLPLAN File
I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file....
2017-02-13
858 reads
Does Query Store Pre-Allocate Space
I love the questions I get while I’m presenting because they force me to think and learn. The question in...
2017-02-14 (first published: 2017-02-07)
1,492 reads
Still Grateful to Rodney Landrum
So, my blog got hacked. They edited the page where I thanked Rodney for all that he did. I had...
2017-02-06
436 reads
I have been hacked
I’m working on securing the blog. Please stand by. Apologies for any inconvenience or confusion.
The post I have been hacked...
2017-02-05
594 reads
Data About Execution Plans
If you look at the Properties for the first operator of a graphical execution plan, you get all sorts of great...
2017-01-23
528 reads
Scheduling Statistics Maintenance in Azure SQL Data Warehouse
The power and capabilities of Azure SQL Data Warehouse are pretty amazing. However, it’s still basically SQL Server under the...
2017-01-25 (first published: 2017-01-18)
1,103 reads
Query Optimizer and Data Definition Language Queries
Data Definition Language queries don’t go through the optimizer, right? While normally, my short answer to this question in the past would...
2017-01-10
586 reads
Database Configuration
It’s amazing just how much the landscape changed with the release of SQL Server 2016 SP1. For example, I just...
2016-12-20
453 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
Where can I find reliable fissure treatment in Delhi?
Finding reliable care starts with choosing a clinic that focuses specifically on anorectal conditions...
Is online Partnership Firm Registration Service in Delhi reliable?
Yes, the online Partnership Firm Registration Service in Delhi is reliable when handled by...
Is Adenoz Injection safe for patients with low blood pressure?
Adenoz Injection is used to treat specific heart rhythm disorders, but it must be...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers