Introduction
At times a user may perform UPDATE operation or DELETE operation in SQL server database without applying the WHERE condition....
2017-09-28 (first published: 2017-09-21)
4,742 reads
Database migration is a vital task in any environment, complex or otherwise. Seamless migrations are the goal but the efforts...
2017-09-19
322 reads
The objective of this article is to look at the possible ways of capturing database usage trends using the most...
2017-09-11
385 reads
In this article, we take the sledgehammer approach in searching for MDFs and then comparing them against files which are...
2017-08-23
487 reads
This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script...
2017-08-15
429 reads
This article details the following
How to get PuTTY and SQL ServerHow to install/uninstall SQL 2017 CTP2.1How to Upgrade to SQL...
2017-08-08
462 reads
One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to...
2017-07-28
698 reads
The performance of a database is the most challenging and critical part of database optimization. The challenge every DBA faces...
2017-07-10
455 reads
Top String FunctionsMachine Learning – Python IntegrationResumable Index Operations
Happy Learning!!
2017-07-06
443 reads
Managing indexes is a critical component of database maintenance but we often don’t think about the indicators behind the index...
2017-06-26
570 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;
GO See possible answers