Happy 2019!
As I’m writing this it’s actually still 2018, so this is both my last blog post of the year and the first blog post of the new year ??...
2019-01-01
16 reads
As I’m writing this it’s actually still 2018, so this is both my last blog post of the year and the first blog post of the new year ??...
2019-01-01
16 reads
Good morning #sqlfamily folks! The very first post in the new year 2019. Tell me: when this time passed??? The...
2019-01-01
207 reads
There was this incident at one of the clients in recent past. It was a nice morning. I was enjoying the tea of the day. I just started my...
2019-01-01
56 reads
I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows...
2018-12-31
448 reads
Firstly, all of us at SQL Undercover would like to wish you a very Happy New Year and all the...
2018-12-31
249 reads
Get off that arctic island and warm up with a little XE fun. This script is quite simple but will show you what you may have out there on...
2018-12-31
13 reads
As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying...
2018-12-31
217 reads
(2018-Dec-31) Back in July of 2018, Ontario provincial government of Canada decided to decrease the number of Toronto city wards from 47...
2018-12-31
1,435 reads
Earlier this week, I blogged about the automatic cleanup process that purges old data from the SSIS catalog logging tables. This nightly process removes data for operations that are...
2018-12-30
18 reads
Earlier this week, I blogged about the automatic cleanup process that purges old data from the SSIS catalog logging tables....
2018-12-30
371 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