Database Scoped Configurations
In SQL Server 2016, one of the key management improvement is a new feature that is called Database Scoped Configurations.
This...
2016-06-10
2,131 reads
In SQL Server 2016, one of the key management improvement is a new feature that is called Database Scoped Configurations.
This...
2016-06-10
2,131 reads
This is about analytics.
This is about day to day life.
This is also about how the things should not being done.
Incomp…...
2016-06-07
597 reads
Continuation from the previous 82 parts, the whole series can be found at http://www.nikoport.com/columnstore/
A lot of things were changed in...
2016-05-29
1,008 reads
As announced a couple of hours ago, a new edition of the famous online webinars 24 Hours of PASS will...
2016-04-21
365 reads
Continuation from the previous 81 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Previously, I have blogged about about the...
2016-04-16
631 reads
With SQLPort approaching it’s 6th birthday (21st of April), I have to admit that the works on the user group...
2016-03-27
486 reads
Continuation from the previous 80 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Microsoft is doing an amazing job with...
2016-03-21
519 reads
Continuation from the previous 79 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given the number under-the-hood performance & manageability improvements...
2016-03-21
555 reads
The registrations for Tuga IT 2016 are finally open: http://tugait2016.eventbrite.com, hurry up cause we are starting to promote it very...
2016-03-09
608 reads
Continuation from the previous 78 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Update: In SQL Server 2016 the Nonclustered...
2016-03-07
579 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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...
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