Query Store for Azure PostgreSQL
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018...
2019-03-12
395 reads
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018...
2019-03-12
395 reads
The topic for this months T-SQL Tuesday #112 hosted by Shane O’Neill (Blog / Twitter) is about “dipping into your cookie jar”. This reference...
2019-03-12
247 reads
It’s T-SQL Tuesday again, and I’m writing in response to Shane O’Neil’s invitation about cookies. Read what he asks and...
2019-03-29 (first published: 2019-03-12)
383 reads
This month’s TSQL Tuesday comes from Shane O’Neil and he’s asking us to ‘dip into the cookie jar’ (or raid...
2019-03-12
246 reads
This month our intrepid host for T-SQL Tuesday is Shane O’Neill (b/t). He’s asked us to talk about our cookies....
2019-03-12
266 reads
Watch this week’s episode on YouTube.In a traditional gaps and islands problem, the goal is to identify groups of continuous...
2019-03-12
7,838 reads
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
20 reads
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
47 reads
This post is a response to this month’s T-SQL Tuesday #112 prompt by Shane O’Neill. T-SQL Tuesday is a way for the SQL...
2019-03-29 (first published: 2019-03-12)
300 reads
This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...
2019-03-12
13 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