A Script A Day - Day 16 - Database Restore
Today’s script is one I have used more times that I care to remember. As a DBA database backups and...
2012-02-22
672 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
672 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 to test one possible upgrade method from SQL Server 2008 to SQL Server...
2012-02-21
970 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 will grant membership in the db_owner fixed database role in all online read/writable user databases to all principals not...
2012-02-20
895 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,091 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
462 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 today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
Comments posted to this topic are about the item Adding Defaults
Hi, I have a requirement to fetch the year from an imported .csv file...
I will have to test this next week, but will not have a chance...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers