Good Seeing
I just finished reading The Perfect Machine about the construction of the Hale Telescope at Mount Palomar (here is a pretty...
2018-05-08
287 reads
I just finished reading The Perfect Machine about the construction of the Hale Telescope at Mount Palomar (here is a pretty...
2018-05-08
287 reads
This month’s T-SQL Tuesday is brought to us by Riley Major (b | t) and he encourage us to talk about how we are helping by giving back to...
2018-05-08
19 reads
The Transaction log growing is completely normal however there are situations where a transaction log can get to a state...
2018-05-07
89 reads
On day 6 we discussed about Programs. today is very important day, we will discussing about Configuration options or parameters. All...
2018-05-07
251 reads
I’m desperately working to finish up a new version of my book on Execution Plans. We’re close, so close. However,...
2018-05-16 (first published: 2018-05-07)
2,599 reads
Introduction
The ACID acronym standing for Atomicity, Consistency, Isolation, and Durability are the properties of SQL transactions. Transactions are used when the database has to be modified by using one...
2018-05-07
34 reads
Introduction
The ACID acronym standing for Atomicity, Consistency, Isolation, and Durability are the properties of SQL transactions. Transactions are used when...
2018-05-07
2,685 reads
Data Masker for SQL Server is pretty cool. It can reduce your attack surface area and exposure under the GDPR...
2018-05-18 (first published: 2018-05-07)
3,224 reads
Notes:
Great attendance, easily 400+Lunch was smooth this year due to changing to boxed lunchesRooms were in 2 different buildings. Sometimes...
2018-05-07
295 reads
The April 2018 update for Windows brought a few cool things but the best one (imho) is that now we...
2018-05-16 (first published: 2018-05-07)
1,750 reads
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...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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