Easy way to generate a restore script.
Easy way to generate a restore script.
I was asked today if I had a canned restore script handy. I don’t....
2013-06-05
993 reads
Easy way to generate a restore script.
I was asked today if I had a canned restore script handy. I don’t....
2013-06-05
993 reads
I was asked today to take a table with a social security column and put all 0s if the column...
2013-06-03
902 reads
A couple of months ago I talked about moving a login from one server to another without the password. The...
2013-06-05 (first published: 2013-05-30)
2,332 reads
I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last...
2013-05-28
1,451 reads
Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working...
2013-05-22
867 reads
Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY.
In the first...
2013-05-23 (first published: 2013-05-20)
21,490 reads
So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...
2013-05-21 (first published: 2013-05-15)
4,110 reads
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that...
2013-05-16 (first published: 2013-05-13)
3,843 reads
2013-05-08
1,314 reads
Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in...
2013-05-06
900 reads
By Brian Kelley
I will be back in Seattle this year attending the 2025 PASS Data Community...
By Steve Jones
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...
By Steve Jones
Today is my last day of work for six weeks. I start my sabbatical...
Comments posted to this topic are about the item Three Times a Day
Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...
Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers