What is DBCC CLONEDATABASE ?
DBCC CLONEDATABASE is new feature comes up with SQL Server 2014 Service Pack 2 and above. DBCC CLONEDATABASE is used...
2017-10-13 (first published: 2017-10-09)
2,452 reads
DBCC CLONEDATABASE is new feature comes up with SQL Server 2014 Service Pack 2 and above. DBCC CLONEDATABASE is used...
2017-10-13 (first published: 2017-10-09)
2,452 reads
Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health...
2017-10-12 (first published: 2017-10-07)
13,798 reads
I used to share an office with my wife. We both needed Internet connections, with both desktops needing Ethernet cables....
2017-10-06
454 reads
One useful sentence when you need to add data to an existing table from an external source or database, and...
2017-10-06
430 reads
I just uploaded a new presentation called “What’s new in SQL Server 2017”. It covers all the new features in...
2017-10-06
748 reads
Today I'll write with one of the features I like the most and is Always On. There will be two post of this subject, this first one is an...
2017-10-06
35 reads
SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs,...
2017-10-06
24 reads
Today I'll write with one of the features I like the most and is Always On. There will be two...
2017-10-06
1,361 reads
Hello!
I was helping a team debug a failed build today. Despite the fact that the build compiled on the devs...
2017-10-06
329 reads
Hello!
Back when SQL Server 2012 was known as Denali, one of the new and exciting features released was that all...
2017-10-11 (first published: 2017-10-06)
2,449 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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