Dates and Times in SQL Server: the problem with DATETIME
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed...
2018-05-30
469 reads
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed...
2018-05-30
469 reads
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...
2018-05-30
613 reads
I was talking about interviews (although not the job kind) with a friend and it reminded me of the time...
2018-06-15 (first published: 2018-05-30)
2,977 reads
So what is the default isolation level for Azure SQL Database? I ran the following code to check it out....
2018-05-30
429 reads
Side note :
I originally started this post to show with examples all the scenarios where you can get minimal logging...
2018-05-29
187 reads
Side note : I originally started this post to show with examples all the scenarios where you can get minimal logging...
2018-05-29
155 reads
This article discusses the concept of SQL Server backup and the various components required to use the Microsoft Azure Blob...
2018-05-29
405 reads
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
9 reads
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
13 reads
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
11 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