Is 18TB of Storage Enough?
Come to find out, nope, probably not. My good friend Jim Donahoe (blog|twitter)was very nice to tell me that he’s running 100TB of storage in his house across multiple Synology...
2021-07-16
6 reads
John Morehouse | Sqlrus.com
Is 18TB of Storage Enough?
Come to find out, nope, probably not. My good friend Jim Donahoe (blog|twitter)was very nice to tell me that he’s running 100TB of storage in his house across multiple Synology...
2021-07-16
5 reads
Is 18TB of Storage Enough?
Come to find out, nope, probably not. My good friend Jim Donahoe (blog|twitter)was very nice to tell me that he’s running 100TB of storage in his house across multiple Synology...
2021-07-16
7 reads
Quickly Determining Azure SQL Database Size
Recently I needed to determine how much storage space each database on a logical server was consuming. I was doing some DR testing and I need to give the...
2021-07-02
89 reads
Understanding NUMA in SQL Server VMs
Last Updated on January 8, 2022 by John Morehouse What really is NUMA and why do we as database administrators care? NUMA stands for “Non-uniform Memory Access” and allows...
2021-05-07
315 reads
Issues When Using Temporary Tables in Nested Stored Procedures
SQL Server offers a lot of flexibility when working with objects like stored procedures and temporary tables. One of the capabilities is to allow for stored procedures to call...
2021-04-06 (first published: 2021-03-26)
945 reads
Issues When Using Temporary Tables in Nested Stored Procedures
SQL Server offers a lot of flexibility when working with objects like stored procedures and temporary tables. One of the capabilities is to allow for stored procedures to call...
2021-03-26
11 reads
Happy New Year!
Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...
2021-01-01
7 reads
Happy New Year!
Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...
2021-01-01
7 reads
Happy New Year!
Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that...
2021-01-01
9 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers