A Script A Day - Day 15 - Untrusted Check Constraints
Today’s script comes about because of a recent discussion about check constraints. The discussion was about the use of WITH...
2012-02-22
1,019 reads
Today’s script comes about because of a recent discussion about check constraints. The discussion was about the use of WITH...
2012-02-22
1,019 reads
Today’s script is one I have used more times that I care to remember. As a DBA database backups and...
2012-02-22
671 reads
Today’s post is pretty cool. So you have been reading up about something on the World Wide Web or you...
2012-02-21
462 reads
Today’s script is one I have used to test one possible upgrade method from SQL Server 2008 to SQL Server...
2012-02-21
969 reads
Today's script will return you permissions granted to a user for every online database. The script uses EXECUTE AS so...
2012-02-20
1,089 reads
Today's script will grant membership in the db_owner fixed database role in all online read/writable user databases to all principals not...
2012-02-20
893 reads
I've been offline for a week to take some annual leave and recharge my batteries. To make up for the...
2012-02-20
461 reads
If you use VMWare for your virtualisation environment all virtual machines are managed by one or more vCentre management servers. ...
2012-02-10
702 reads
Today's script provides amongst other information Index compression estimates based on existing index information. All you need to do is...
2012-02-09
1,307 reads
Today's script comes to you from London where I am at my head office for my appraisal! Lets hope it...
2012-02-08
443 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...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
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