Get Rid of those unused indexes!
Indexes in relational databases are very helpful and increase the speed to access data. However maintaining indexes is just as...
2018-12-11
216 reads
Blog Posts
How many Cores per Socket do I need?
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-12-11
9,447 reads
PayPal for Non Profits
Part of having 501c(3) status is figuring out where and how it might make a difference. Applying for non profit...
2018-12-11
240 reads
SQL Census–From the Redgate Foundry
The Foundry at Redgate Software is our version of Microsoft Research. Kind of. We tackle some projects that are interesting...
2018-12-11
280 reads
SQL Server I/O
Sometimes I like to see and know what SQL server is doing under certain operations and recently I wrote an...
2018-12-11
228 reads
To Influence or Be Influenced?
Getting feedback from others is that little check that is needed to help progress and move in the right direction. When allowing time and opportunity for feedback from others,...
2018-12-11
13 reads
To Influence or Be Influenced?
How have you impacted somebody in the community?
Well, have I come up with a doozy of a topic for this...
2018-12-11
189 reads
T-SQL Tuesday #109 – Mentors and Mentees
G’day again,
So, it’s time for T-SQL Tuesday again, the blog party
started by Adam Machanic (
This time we're talking about people...
2018-12-11
175 reads
Visualizing Nested Loops Joins And Understanding Their Implications
This post is the first in a series about physical join operators (be sure to check out part 2 - merge joins, and part 3 - hash match joins).
Watch...
2018-12-11
16 reads
Visualizing Nested Loops Joins And Understanding Their Implications
This post is the first in a series about physical join operators (be sure to check out part 2 – merge...
2018-12-11
976 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers