A Quick Look At The All New Undercover Catalogue, Preview Release Due Out Soon…
I thought I’d give you all a little preview of our latest offering, the Undercover Catalogue which should be available...
2018-08-06
274 reads
I thought I’d give you all a little preview of our latest offering, the Undercover Catalogue which should be available...
2018-08-06
274 reads
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote...
2018-08-08 (first published: 2018-07-25)
2,045 reads
A couple of times recently I’ve seen the question asked, ‘How can I select a single row at random from...
2018-07-26 (first published: 2018-07-20)
748 reads
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here.
Bert...
2018-07-18 (first published: 2018-07-10)
2,718 reads
I’ve been having a little play around with AWS recently and was looking at S3 (AWS’ cloud storage) when I...
2018-06-18
1,000 reads
Sometimes emails from SQL Server go missing, especially when you share an inbox with colleagues. On most occasions it doesn’t...
2018-06-14 (first published: 2018-06-05)
2,412 reads
Now this is something that I’ve seen asked a few times and it’s always a question that gets a fair...
2018-05-24
2,584 reads
Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling...
2018-05-14 (first published: 2018-05-02)
2,436 reads
This month’s T-SQL Tuesday is brought to you by Jens Bestergaard – the subject is Essential SQL Server tools, the original...
2018-04-10
1,107 reads
We all go to great lengths to make sure that our databases are secure (or at least I really hope...
2018-04-09 (first published: 2018-04-04)
2,506 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