SQL Server 2014: protection against Database Administrator
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly....
2015-09-10
1,650 reads
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly....
2015-09-10
1,650 reads
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly. The questions like “How can I protect my data...
2015-09-10
22 reads
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly. The questions like “How can I protect my data...
2015-09-10
30 reads
In this article I’d like to tell about monitoring tools available in SQL Server 2014 to evaluate the performance of...
2015-09-03
1,305 reads
Monitoring of the size of database files is one of the important DBA tasks and this process should be automated....
2015-09-02
662 reads
Let`s assume we have following task – make changes to the data in a large table that has consistency checker in...
2015-09-01
764 reads
Let’s take a closer look at how we can speed up the system’s performance using the Buffer Pool Extension. For...
2015-08-31
2,043 reads
I guess many have heard the phrase «640K ought to be enough for anybody», which Bill Gates is mistakenly thought...
2015-08-17
1,767 reads
When I hear the discussion about causes of data corruption in SQL Server, I always mention bugs in the operating...
2015-08-17
2,013 reads
AlwaysOn technology in MS SQL Server is designed to increase the availability of your database, it is another step toward...
2015-08-12 (first published: 2015-08-06)
16,917 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. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
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