Extended Events and Profiler: XE Profiler
There’s a war on in the SQL Server world. On the one side is Profiler (although, really, everyone uses Trace...
2017-11-07
457 reads
There’s a war on in the SQL Server world. On the one side is Profiler (although, really, everyone uses Trace...
2017-11-07
457 reads
Photo by Jaanus Jagomägi on UnsplashInterested in learning more about SQL injection attacks, including how to prevent them? Attend my online webcast on...
2017-11-07
354 reads
Photo by Jaanus Jagomägi on Unsplash
Interested in learning more about SQL injection attacks, including how to prevent them? Attend my online webcast on Tuesday November 14, 2017 at 1PM Eastern at the...
2017-11-07
16 reads
Hello all!
This past week was PASS Summit 2017, a super crazy/awesome week! So many great things happened this week and...
2017-11-07
107 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-11-06
1,756 reads
In the big-data ecosystem, it is often necessary to move the data from Hadoop file system to external storage containers...
2017-11-06
379 reads
At the SQLSat Organizers and UG Leaders Meetings at PASS Summit meetings last week, we were given an opportunity to share...
2017-11-06
335 reads
In the new Project deployment model for SQL Server Integration Services, a new SQL Server database is used to provide...
2017-11-06
288 reads
I’ve given technical presentations for years. I’ve also taught in churches and youth groups years before that. For me, speaking...
2017-11-17 (first published: 2017-11-06)
1,532 reads
It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing...
2017-11-06
603 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