Book Review: Marshmallow Test
Different people approach their career in different ways. My working assumption, all the time, is that I don’t know enough...
2016-11-18
427 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
Reinforcing the Importance of Statistics on Row Estimate
I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they...
2016-11-10 (first published: 2016-11-03)
1,216 reads
Azure Data Platform Learning Resources
I know that more and more of you are moving more and more resources into the Azure Data Platform. In...
2016-11-09
608 reads
Stored Procedures Are Not Faster Than Views
A performance tuning tip I saw recently said, “Views don’t perform as well as stored procedures.”
<sigh>
Let’s break this down, just...
2016-11-09 (first published: 2016-11-01)
3,690 reads
PASS Board Update: Post-Summit 2016
Monday
I got in on Sunday and chose to have a small dinner with a couple of friends, quiet, preparing.
Monday was...
2016-11-08
425 reads
sp_executesql Is Not Faster Than an Ad Hoc Query
This requires an immediate caveat. You should absolutely be using sp_executesql over any type of non-parameterized execution of T-SQL. You...
2016-11-07
1,184 reads
Emotions and Decision Making
Today we have a guest editorial from Grant Fritchey that looks at emotions and how they can affect our decision making.
2016-10-28
100 reads
SQL Cruise as a Speaker and Sponsor
SQL Cruise offers a number of unique opportunities for everyone involved, including speakers and sponsors. I’ve written before, severaltimes, about...
2016-10-28 (first published: 2016-10-18)
1,131 reads
SELECT * Does Not Hurt Performance
I read all the time how SELECT * hurts performance. I even see where people have said that you just have...
2016-10-25 (first published: 2016-10-17)
4,403 reads
A Sub-Query Does Not Hurt Performance
The things you read on the internet, for example, “don’t use a sub-query because that hurts performance.”
Truly?
Where do people get...
2016-10-24
1,514 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
Issue with CPU Affinity Configuration on a SQL Server VM with 30 vCPUs
Hello , I'm having an issue with a SQL Server VM that has 30...
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers