Information Schema Strangeness
An extra column in an information_schema view had Steve digging into standards.
2023-04-05
171 reads
An extra column in an information_schema view had Steve digging into standards.
2023-04-05
171 reads
Although many professions require judgement and skill, they also require the ability to do many repeated standard procedures in a consistent and methodical manner. For DBAs, standardization involves providing and following checklists, notes and instructions so that the results are predictable, correct and easy to maintain.
2014-07-10
8,648 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