Triggers vs. Default Constraints: Choose Wisely
Triggers can be really useful in your database but you have to be careful with them. We often use them to record history to a separate table (at least,...
2018-05-29
54 reads
Triggers can be really useful in your database but you have to be careful with them. We often use them to record history to a separate table (at least,...
2018-05-29
54 reads
We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do...
2018-06-08 (first published: 2018-05-28)
4,105 reads
It always seems that when I give a talk on performance there are 100+ people packed in the room but...
2018-05-28
277 reads
in my last post I showed how you can save the results of dbachecks to a database and created a...
2018-06-07 (first published: 2018-05-28)
1,877 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-06-06 (first published: 2018-05-28)
2,221 reads
(2018-May-27) With recent Hawaiian volcano activity, it would be interesting to see how other similar events have shaped our Earth planet....
2018-06-06 (first published: 2018-05-27)
2,511 reads
Color is a powerful attribute in data visualization. In a good visualization, it can focus attention and enhance meaning and...
2018-06-05 (first published: 2018-05-27)
2,678 reads
Unless you have been living under a rock lately, you have not heard about GDPR. This has been hot topic...
2018-05-25
154 reads
Maybe some of you don't know this, but to view Report Definition Language reports (RDL) , you aren't forced to use...
2018-05-25
634 reads
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-06-01 (first published: 2018-05-25)
2,447 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers