Top 50 PowerShell bloggers of 2018
My work is recognized and my blog is listed under Top 30 elite list. I am pleased, honored and humbled...
2018-12-18
257 reads
My work is recognized and my blog is listed under Top 30 elite list. I am pleased, honored and humbled...
2018-12-18
257 reads
From our webinar today, I mentioned I had a dog named “Azure”. Here she is.
No, this isn’t an homage to...
2018-12-18
363 reads
There are times when we need to compare two tables and figure out if the data matches. I often see...
2018-12-31 (first published: 2018-12-18)
4,304 reads
Small tokens of gratitude and small actions help to build this wonderful SQL Community that gives and gives and gives. Humility leads us to seek out ways to give...
2018-12-18
17 reads
How have you impacted somebody in the community?
This month I am in charge of the topic for TSQLTuesday. The invite...
2018-12-18
235 reads
One of the more common wait types for SQL Server is called WriteLog. In its most basic form it is...
2018-12-27 (first published: 2018-12-18)
3,718 reads
This post is part 2 in a series about physical join operators (be sure to check out part 1 – nested...
2018-12-31 (first published: 2018-12-18)
3,013 reads
This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...
2018-12-18
25 reads
This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...
2018-12-18
34 reads
We use Meetup for SQLOrlando. We have enough members that we have to pay for the service and it works...
2018-12-18
266 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