Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?
31 Days of Disaster Recovery
Welcome to my...
2013-01-04 (first published: 2013-01-01)
2,277 reads
Tempdb Contention That Can’t be Soothed By Adding Files
Tempdb Contention via Idera diagnostic manager
I’ve talked a lot in the past...
2012-12-21
1,454 reads
Cross-database Queries by Contained Users
http://www.necromaticmedia.com/2007/11/containment/
I presented to the Pacific Northwest SQL Server User Group / PASS Chapter (PNWSQL) last night on...
2012-12-14
1,599 reads
Recent Presentation Session Files
Session Files – A Little Behind
I’ve been a little tardy about getting my session files posted, and I’m...
2012-11-15
878 reads
T-SQL Tuesday #36 – SQL Community
T-SQL Tuesday #36 - SQL Community
This blog entry is participating in T-SQL Tuesday #36, hosted this month...
2012-11-13
957 reads
Don’t Be That PASS Summit Guy
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is just around the corner. Every year...
2012-10-22
1,201 reads
Man Vs Machine
Man Vs Machine
Are you a fan of the television show Man Vs Food starring foodie Adam Richman? In...
2012-08-23
1,056 reads
Why Attending a Monday Pre-con Will Be Awesome
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is coming up in a...
2012-07-16
1,126 reads
Performing Fast Searches of Query Plans
XML: Fast as a Turtle
I've made blog posts in the past on using the exist()...
2012-07-12
1,226 reads
Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
Extreme Logging
I was having a discussion with Idera (@idera_software) dev lead Vicky...
2012-06-30
2,195 reads
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
I wanted to figure out how big (or approximately how big) my dump file...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
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