The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is the same – https://msdn.microsoft.com/en-us/library/dd207003.aspx. When you install a SQL...
2016-03-02
8 reads
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an experience of working with constraints and when I got to...
2016-03-01
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an experience of working with constraints and when I got to...
2016-03-01
2 reads
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an...
2016-03-01
111 reads
I have found many columns in many tables of many databases that are defined to allow NULLs but have non NULL...
2016-03-01
110 reads
After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the...
2016-02-26
679 reads
After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the top 3 settings that have become a best practice...
2016-02-26
8 reads
After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the top 3 settings that have become a best practice...
2016-02-26
6 reads
After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the...
2016-02-26
555 reads
SQL Server has plenty of built-in functions but sometimes we just have to combine some of them to create functions for...
2016-01-15
88 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