Extended Events Permissions
Some view the permissions for Extended Events as a limitation. I see the required permissions as an appropriate set and recommend all to work with XE and permissions to...
2017-12-26
145 reads
Some view the permissions for Extended Events as a limitation. I see the required permissions as an appropriate set and recommend all to work with XE and permissions to...
2017-12-26
145 reads
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
162 reads
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
17,433 reads
SQL Server 2017 brings a new interesting feature, that might be a game changer in some environments. I’m talking about...
2017-12-25
653 reads
Dear All, Earlier this year in August, I had the privilege of speaking at Data Platform Summit 2017 at Bangalore. As always a terrific experience to hangout, interact and...
2017-12-23
21 reads
Dear All, Earlier this year in August, I had the privilege of speaking at Data Platform Summit 2017 at Bangalore. As always a terrific experience to hangout, interact and...
2017-12-23
19 reads
Continuing on the series on Adaptive Query Processing covered over here, this post would cover what happens to adaptive joins when plans are reused.
To give a...
2017-12-23
28 reads
Continuing on the series on Adaptive Query Processing covered over here, this post would cover what happens to adaptive joins when plans are reused.
To give a...
2017-12-23
35 reads
I had the honor to visit Nepal and participate in SQL Saturday Nepal 2017. You can visit the event website...
2017-12-23
509 reads
Dear All,
Earlier this year in August, I had the privilege of speaking at Data Platform Summit 2017 at Bangalore. As...
2017-12-23
412 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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...
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