DBA in the Cloud: Threat or Opportunity?
Five years ago the term “cloud” was still a buzzword, and there was a lot of uncertainty and misconception around...
2014-09-16
621 reads
Superman
Parameterization Part 4: Handling Non-Uniform Data Distribution
This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I...
2014-09-11 (first published: 2014-09-08)
7,098 reads
Parameterization Part 3: Parameter Sniffing
This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a...
2014-09-01
1,389 reads
Parameterization Part 2: Seven Ways to Execute Your Query
This is the second post in my series on parameterization. In the first post I wrote about plan caching and...
2014-08-28 (first published: 2014-08-25)
9,082 reads
Parameterization Part 1: Plan Caching
Many times, when I perform query tuning, the problem that causes the query to perform badly is related, one way...
2014-08-21 (first published: 2014-08-18)
8,523 reads
My Visit to WPC 2014
Last week I attended WPC. This is an annual event organized by Microsoft for its partners around the world. WPC...
2014-07-24
455 reads
My Visit to Redmond
Last week, I had the pleasure of attending the EBC in Redmond. If you don’t know what EBC is, that’s...
2014-07-23
545 reads
Track Incomplete Statements
What about when statements are sitting in your server, uncompleted and not moving, just hogging resources? Use this script for...
2014-07-16
594 reads
Space Used by Database Files
Retrieve data about size and space used for all the files in the current database with this script.
Some tips on...
2014-06-24
757 reads
What I Love About SQL Server
Well, there are many things I love about SQL Server. Otherwise, I wouldn’t spend my whole career around it, would...
2014-06-16
541 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
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...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
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