Why nested views are bad
Nested views are bad. Let’s get that out of the way. What is a nested view anyway? Imagine that you...
2018-02-14
2,372 reads
Performance Basics: Key lookup operator and query optimization
One of the most basic things to improve performance in our queries is using indexes, but this doesn't mean that...
2018-02-14
561 reads
Bloggers Should Have Reach
One of my goals for 2018 is to expand the reach of my blog.
As a blogger starting out I had...
2018-02-14
324 reads
How I Accidentally Found a Passion for Plants (#TSQL2sDay 99)
For TSQL Tuesday #99, @AaronBertrand gave us an invitation to write about something we’re passionate about outside of SQL Server. As a community we spend a lot of time digging into nerdy...
2018-02-13
24 reads
T-SQL Tuesday #99 : Dealer’s Choice – Being a Voice for a Foster Child in Court
This month Aaron Bertrand (b | t) has given us a Dealer’s Choice on the T-SQL Tuesday topic. I’m of course going...
2018-02-13
140 reads
T-SQL Tuesday #99 – What’s Behind Door #1
It’s hard to believe that we have reached T-SQL Tuesday #99 already. This month’s host is Aaron Bertrand (blog|@AaronBertrand), and...
2018-02-13
733 reads
Power BI Custom Visuals Class (Module 90 – Brick Chart MAQ Software)
In this module you will learn how to use the Brick Chart by MAQ Software. The Brick Chart provides a...
2018-02-27 (first published: 2018-02-13)
2,524 reads
Database Maintenance Without Breaking The Bank
Database maintenance does not have to be expensive. There are free tools out there that will make your life easier. Of...
2018-02-22 (first published: 2018-02-13)
3,178 reads
Obsessing over query operator costs
A common problem when looking at execution plans is attributing too much meaning and value of the costs of operators. The percentages shown for operators in query plans are...
2018-02-13
17 reads
Obsessing over query operator costs
A common problem when looking at execution plans is attributing too much meaning and value of the costs of operators.
The...
2018-02-22 (first published: 2018-02-13)
2,220 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
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers