PASS Summit: Planting Seeds of Knowledge
On the eve of this year’s PASS Summit, I find myself reflecting on my first Summit in 2012. My employer was generous enough to pay for not only Summit...
2018-11-04
20 reads
On the eve of this year’s PASS Summit, I find myself reflecting on my first Summit in 2012. My employer was generous enough to pay for not only Summit...
2018-11-04
20 reads
Updated 2018-11-04: Expanded test code, renamed the
title of the post so it's clearer.
SMO (SQL Server Management Objects) are the .NET...
2018-11-03
768 reads
It has been a busy year so far. Last March, I did a review, as a Technical Reviewer, for a...
2018-11-02
312 reads
What if you could assess the performance level of your team by asking one simple question? In his recent webinar with Redgate, Gene Kim (@realgenekim) suggests that you can....
2018-11-02
32 reads
I’m excited to have a session accepted to GroupBy, a free online conference targeting the Microsoft data platform community. The conference is sponsored by Brent Ozar Unlimited, and sessions...
2018-11-02
28 reads
There are a limited number of extensions available for Azure Data Studio (ADS), but one that came out early is...
2018-11-16 (first published: 2018-11-02)
1,905 reads
I was disheartened to read the post that shows we have three candidates for three positions this year. Started with...
2018-11-02
342 reads
If you are anything like me, you might have a few different Google accounts that you work with on a...
2018-11-01
64 reads
AdvertisementsPlan Explorer
I recently started using this. Since it was licensed earlier, now it’s free. This is an awesome tool for...
2018-11-01
2,789 reads
One of the features Microsoft wants us to use for Azure SQL Database is Automatic Tuning. Automatic Tuning is a...
2018-11-01
296 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