2018-05-21
318 reads
2018-05-21
318 reads
Hello California! I’m headed your way and will be speaking at SQL Saturday #773. The full schedule is live and...
2018-05-14
269 reads
Here’s the first issue of a new Monday morning comic series. Hopefully some of you all get a giggle.
2018-05-14
354 reads
I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took...
2018-04-26
1,206 reads
Missing indexes are an important part of the indexing strategy. I usually start with sys.dm_db_index_usage_stats to find both inefficient and...
2018-04-20
622 reads
It’s Friday and I’m ready for the weekend as I’m sure everyone else is. This weekend I’m looking forward to...
2018-04-16 (first published: 2018-04-06)
3,432 reads
Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look...
2018-03-29
443 reads
Many of the widely advertised and talked about features of SQL Server or other software products focus exclusively on the...
2018-03-07
386 reads
Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio...
2018-03-06
442 reads
The right to be forgotten. It’s a concept that sounds great for people who are concerned about their personal information...
2018-03-05
512 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...
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