The "Go Pack"
I’ve found myself traveling quite a bit this year, with more travel on the horizon. Like many, I travel with a fair bit of technology and of course that...
2019-09-17
11 reads
I’ve found myself traveling quite a bit this year, with more travel on the horizon. Like many, I travel with a fair bit of technology and of course that...
2019-09-17
11 reads
It’s early September, which means it’s time for T-SQL Tuesday! This month’s topic comes from Kevin Chant (blog | twitter). Our mission, should we choose to accept it (click...
2019-09-10
22 reads
It’s early September, which means it’s time for T-SQL Tuesday! This month’s topic comes from Kevin Chant (blog | twitter). Our mission, should we choose to accept it (click...
2019-09-10
22 reads
This is Part 3 in a three-part series. Please see Part 1 and Part 2 for more.
What does your average day look like?
I’m going to punt to my “A...
2019-09-06
28 reads
This is Part 3 in a three-part series. Please see Part 1 and Part 2 for more. There we go! Thank you Jon for sending in your questions. This...
2019-09-06
19 reads
This is Part 2 of a series. Please see Part 1 for the background and more. Stay tuned for the thrilling conclusion in Part 3, coming soon!
The post Q&A:...
2019-09-05
25 reads
This is Part 2 of a series. Please see [Part 1]/2019/09/03/qa-dealing-with-thousands-of-databases/) for the background and more.
What is the most unexpected experience you’ve had in this position?
I have two answers...
2019-09-05
17 reads
This is part one of a three-part series.
I’ve mentioned in various places, including in blog posts on occasion, that my production SQL Server instance hosts several thousand (nearly 9000...
2019-09-03
19 reads
This is part one of a three-part series. I’ve mentioned in various places, including in blog posts on occasion, that my production SQL Server instance hosts several thousand (nearly...
2019-09-03
349 reads
It feels like SQL Saturday Albany just wrapped up, but I have another announcement to make. I am proud to announce that I have been selected to speak at...
2019-08-13
20 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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