What's new in SQL 2017
SQL Server 2017 became General Availability (GA) on 10/2, I've been sharing through the different social media channels the different...
2017-10-11
197 reads
SQL Server 2017 became General Availability (GA) on 10/2, I've been sharing through the different social media channels the different...
2017-10-11
197 reads
I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog...
2017-10-20 (first published: 2017-10-11)
1,734 reads
I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into...
2017-10-11
436 reads
This year will be my 6thPASS Summit that I will have attended. Some people have asked me why I still...
2017-10-11
334 reads
Hello friends, Please find the full article at this link – https://social.technet.microsoft.com/wiki/contents/articles/40666.sql-server-identity-cache-feature-in-sql-server-2017.aspx
2017-10-11
505 reads
Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level...
2017-10-19 (first published: 2017-10-11)
2,113 reads
Unlike some other languages, T-SQL doesn’t have the concept of a constant.
As good coders, we’ve all at some point tried...
2017-10-19 (first published: 2017-10-10)
3,690 reads
Photo by James Sutton on UnsplashNote: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK...
2017-10-10
420 reads
Photo by James Sutton on Unsplash
Note: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK hints. The fact that it applies to NOLOCK queries...
2017-10-10
34 reads
One of the useful features of the SSAS Activity Monitor is the ability to cancel sessions and queries. Though there is...
2017-10-10
3,257 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