Random Blog Post Challenge
OK, for no particular reason at all or maybe because I had too much food at lunch or just because...
2017-03-02
394 reads
The Scary DBA
Determining the Cost Threshold for Parallelism
In the previous post, I showed how you can get full listings of your execution plan costs. Knowing what the...
2017-03-09 (first published: 2017-02-28)
1,940 reads
SQL Clone
Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server...
2017-03-06 (first published: 2017-02-27)
2,139 reads
I Don’t Understand
I suspect this may make a few people angry, but I felt the need to share.
I was recently asked to...
2017-03-03 (first published: 2017-02-24)
3,359 reads
Confusion of An Old Technologist
As someone who still actively pursues a career in technology, I’m a little on the older side. I got started...
2017-02-23
406 reads
Estimated Costs of All Queries
One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty...
2017-02-22 (first published: 2017-02-20)
2,479 reads
Export All Plans From Cache to a .SQLPLAN File
I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file....
2017-02-13
857 reads
Does Query Store Pre-Allocate Space
I love the questions I get while I’m presenting because they force me to think and learn. The question in...
2017-02-14 (first published: 2017-02-07)
1,491 reads
Still Grateful to Rodney Landrum
So, my blog got hacked. They edited the page where I thanked Rodney for all that he did. I had...
2017-02-06
436 reads
I have been hacked
I’m working on securing the blog. Please stand by. Apologies for any inconvenience or confusion.
The post I have been hacked...
2017-02-05
593 reads
Blogs
Advice I Like: Experience and Aptitude
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
Plan Time for Self-Development
By Brian Kelley
As you begin the new year, if you don't already have time set aside...
BK’s Bookshelf: Never Split the Difference
By Brian Kelley
I picked up Never Split the Difference: Negotiating As If Your Life Depended On...
Forums
Insiders Selling Data
Comments posted to this topic are about the item Insiders Selling Data
Join 2 tables
Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M ServerA N...
Impact of Not Including Foreign Keys in an SQL Archive Database
Hello everyone, I am about to start a data archiving project that will affect...