On table variable row estimations
At first glance, the question of how many rows are estimated from a table variable is easy. But, is it really that simple? Well, not really. To dig into...
2020-12-23 (first published: 2020-12-15)
351 reads
SQL In The Wild
On table variable row estimations
At first glance, the question of how many rows are estimated from a table variable is easy. But, is it really that simple? Well, not really. To dig into...
2020-12-15
3 reads
Pluralsight Free April
It’s a few days into April, but not too late I hope to mention that Pluralsight is offering their entire library, free to new accounts, for the month of...
2020-04-16 (first published: 2020-04-07)
470 reads
Pluralsight Free April
It’s a few days into April, but not too late I hope to mention that Pluralsight is offering their entire library, free to new accounts, for the month of...
2020-04-07
2 reads
A rant about presentations
My company’s internal conference is in a couple of weeks, so this seems like a good time to have a...
2018-05-04 (first published: 2018-04-24)
2,344 reads
A rant about presentations
My company’s internal conference is in a couple of weeks, so this seems like a good time to have a quick rant about some presentation failings I’ve seen over...
2018-04-24
1 reads
Revisiting catch-all queries
I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code....
2018-03-26 (first published: 2018-03-13)
3,860 reads
Revisiting catch-all queries
I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code. It turned into the 3rd most popular post ever...
2018-03-13
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,138 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
Blogs
Removing a PowerShell Array Element–#SQLNewBlogger
By Steve Jones
I saw an article on this and realized I had no idea how to...
PostgreSQL Backup Failure
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
Dynamic Data Masking – SQL Server
By Tim Radney
Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...
Forums
Small Transactional Table with Frequent Updates
Hi All We have a 12 row on our platform that gets updated for...
Sporadic error during restore job
Hello experts, I see this error in a SQL Agent job. It happens during...
Average price calculation
Hello! I need to make a query that will calculate my average price for...
Ask SSC