24 Hours of PASS – April 25th–26th
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours session go on once an hour for 24 hours....
2018-04-18
35 reads
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours session go on once an hour for 24 hours....
2018-04-18
35 reads
I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have...
2018-04-18
1,396 reads
In my sessions, I always talk about how to build your skill set when you don’t have a budget for...
2018-04-18
561 reads
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours...
2018-04-24 (first published: 2018-04-18)
2,321 reads
The ANDs, ORs, and NOTs in a T-SQL query's WHERE clause can get confusing, especially if you're thinking of it...
2018-04-17
2,054 reads
If you’re starting to use cloud services, the number of options available can be confusing. Particularly when they may seem...
2018-04-26 (first published: 2018-04-17)
6,210 reads
On April 24, I’ll be hosting a webinar that talks about the GDPR and how you can help ensure compliance...
2018-04-23 (first published: 2018-04-17)
3,035 reads
Problem
As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system...
2018-04-17
2,053 reads
Problem
As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system...
2018-04-17
2,482 reads
Watch this week’s episode on YouTube.
When In-Memory OLTP was first released in SQL Server 2014, I was excited to start...
2018-04-25 (first published: 2018-04-17)
2,966 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