Pre-Summit PASS Board Update
Busy, busy, busy.
A lot of the work around PASS currently is getting ready for Summit. I’m prepping my part in the...
2016-10-11
437 reads
The Scary DBA
Statistics Are Vital For Query Performance
This is post #10 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
When you send a query to your...
2016-10-19 (first published: 2016-10-10)
2,070 reads
Where Do We Go To Share?
No one reads blogs any more.
Twitter is dying.
Facebook is broken.
LinkedIn? Please.
G+. Is that even on any more?
Where do we go...
2016-10-05
473 reads
Correlated Datetime Columns
SQL Server is a deep and complex product. There’s always more to learn. For example, I had never heard of...
2016-10-13 (first published: 2016-10-03)
1,773 reads
Azure Data Platform Resources
A few months ago I created a GitHub repository for the purpose of building and maintaining a list of resources...
2016-09-30
843 reads
Volunteering With PASS
I was just asked how many times I’ve been to the PASS Summit. This year will be my 12th consecutive...
2016-09-29
755 reads
Networking and the PASS Summit
PASS Summit 2016 is fast approaching. If you’re going, time to start making plans. If you’re not going, sell your...
2016-09-27
401 reads
Query Store and What Happened Earlier On Your Server
Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what...
2016-10-06 (first published: 2016-09-26)
1,855 reads
Query Store and Plan Forcing: What Do You Use It For
If you’re working with Azure SQL Database or you’ve moved into SQL Server 2016, one of the biggest new tools...
2016-09-28 (first published: 2016-09-19)
1,249 reads
The Clustered Index Is Vital To Your Database Design
This is post #9 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
You get one clustered index per table.
That...
2016-09-19 (first published: 2016-09-12)
2,506 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