The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
Lately I’ve noticed an increasing number of people recommend increasing...
2010-05-07
6,240 reads
The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
Lately I’ve noticed an increasing number of people recommend increasing...
2010-05-07
6,240 reads
Question: Is Mirroring Supported by MS Access front-end?
The following question was posted on a SQL Server discussion group. My reply...
2010-05-07
2,301 reads
A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
I just want to pass along a few...
2010-05-01
1,157 reads
Undocumented Capabilities of Extended Event Objects
The extended event objects (objects exposed by an event package) are listed in the system...
2010-04-28
2,160 reads
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
One of the features of SQL Server 2008 that...
2010-04-23
3,205 reads
T-SQL Tuesday #005: Smart Card Login Breaks SQL Server Reporting Services 2008
This blog entry is participating in T-SQL Tuesday #005,...
2010-04-13
3,412 reads
2010-04-10
584 reads
5 Random Thoughts on the SQL Server MCM Program
I've had some random thoughts running through my head since I finished...
2010-04-10
3,503 reads
How do I Write a Backup Strategy?
DBA's harp about the need to have backups. The first thing many DBA’s do when they inherit...
2010-04-09
962 reads
Catching Transient CPU Spikes Using SQL Trace If there was one thing I wish everyone who works with SQL Server would...
2010-04-06
4,495 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
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; GOSee possible answers