In an OLTP DB, other than an autogenerated Identity , there should be something else on the table which makes the non-identity data unique, as in, unique if you had to drop the ID column.
2016-02-03 (first published: 2016-01-22)
486 reads
The script can be used to perform any task against all databases hosted on an instance. This is an example script that checks if a user is in a database if it is not then create the user and add it db_datareader role.
2016-02-02 (first published: 2016-01-15)
780 reads
Find missing Foreign Keys by name, only reference single column primary keys which are on top of an identity,also find where column names reference table with column name ='ID'.
2016-02-01 (first published: 2016-01-21)
1,067 reads
Generic SQL backup with Azure support allowing several, handy backup options.
2016-01-29 (first published: 2016-01-21)
367 reads
Script for preventing the volumes of the transaction logs from filling.
2016-01-27 (first published: 2014-05-13)
3,502 reads
The procedure created by this script rolls up the collected query execution statistics and groups them daily by the plan hash value.
2016-01-20 (first published: 2015-05-13)
5,387 reads
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,077 reads
This is a great wrapper for your DMV's to automate a quick performance metric capture.
2016-01-12 (first published: 2016-01-06)
418 reads
Set minimal autogrow values for datafiles and logfiles depending on the file size, thresholds for all databases
2016-01-07 (first published: 2015-06-08)
1,092 reads
Query the mirror instance via agent job to auto kick back to primary. If db is in suspended state will resume mirroring.
2016-01-05 (first published: 2015-12-23)
448 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hello , I'm having an issue with a SQL Server VM that has 30...
Hi everyone My SSIS package does a bulk insert of csv files into a...
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