Updated Overlapping Statistics Scripts
Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script...
2011-04-05
1,693 reads
Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script...
2011-04-05
1,693 reads
Replication: It's Not Really As Bad As SQLRockStar Says It Is
(Wondering what the heck this is supposed to be about?...
2011-04-04
390 reads
Recently there have been a number of PASS members who have become unhappy with the direction of the organization and...
2011-04-01
390 reads
I'm a big proponent of using Virtual Machines for development on your local machine. It just doesn't make sense to...
2011-03-15
608 reads
If you follow me on Twitter or talk to me in person you'll come to realize I'm a space enthusiast....
2011-03-15
510 reads
If you're in the central Florida area you're invited to the March meeting of MagicPASS, South Orlando's SQL Server User...
2011-03-11
477 reads
You've probably noticed I've been quiet on this blog lately, eeking out a post every other week on average. I've...
2011-02-24
1,521 reads
I bet by now you've heard of SQLRally, be it from the blogosphere, Twitter, the PASS Connector bi-weekly emails, word...
2011-02-23
399 reads
If you're in the central Florida area you're invited to the February 2011 meeting of MagicPASS, South Orlando's SQL Server...
2011-02-15
531 reads
On Wednesday, Feb 16th, 3 PM Eastern I'm presenting a webcast for Idera's Secrets of SQL Server series. Presentation details...
2011-02-15
711 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