Viewing the Statistics Objects Used to Create an Execution Plan
A while ago now I was running some Performance Tuning workshops and was asked how you can find out which Statistics...
2017-09-01
434 reads
Friday Reading 2017-09-01
Going to be a busy few weeks as conference season gets into full swing. Really looking forward to the next...
2017-09-01
336 reads
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
687 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
937 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,724 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
683 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,045 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,113 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
728 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
702 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers