CHECKDB’s Hidden Snapshot
I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the...
2016-11-10
470 reads
I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the...
2016-11-10
470 reads
One of the coolest things to release with SQL Server 2016 was “Number of Rows Read” information in execution plan....
2016-11-10
850 reads
Has anyone in my network or readers my blog have any experience of a database called Firebird?
If you have and...
2016-11-09
392 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-11-09
426 reads
Abstract
This article details the use of “Execute AT LinkedServer” clause. It’s best in some ways when you are trying to run...
2016-11-09
1,919 reads
I know that more and more of you are moving more and more resources into the Azure Data Platform. In...
2016-11-09
625 reads
Following up on my notes about the 2016 SQLSaturday Roundtable I wanted to write more about the ROI of SQLSaturday....
2016-11-09
483 reads
I was working with a developer the other day and he was typing out each table name and all the...
2016-11-09
1,097 reads
This weeks Learning Tree deals are in. If you want to learn about big data, Network security and with the...
2016-11-09
418 reads
The MOSL – Memory Optimised Scripts Library has finally received a first public preview release – the version 0.2.0!
This version introduces the...
2016-11-08
474 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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