The Top 4 Data Technology Trends Every DBA Should Know About in 2019
Join Sentry One, Kevin Kline, and me in an exciting (and laugh-filled) panel session this Wednesday, January 9th, at 2pm...
2019-01-07
51 reads
Join Sentry One, Kevin Kline, and me in an exciting (and laugh-filled) panel session this Wednesday, January 9th, at 2pm...
2019-01-07
51 reads
Being the start of the new year and with new projects most likely starting again I would like to share...
2019-01-07
339 reads
Gathering metrics is quite difficult if there are no queries. So, if you’re working in non-production environments, but you still...
2019-01-17 (first published: 2019-01-07)
2,362 reads
This is post 3 in the series about query fingerprints. Here’s the previous posts in this series:
Query HashSQL Handle
What is...
2019-01-07
964 reads
ARITHABORT can be a short termed head scratcher. Pay close attention to what has changed in the environment. Test alternatives. And check those connection strings.
Related Posts:
Failed to Create the...
2019-01-07
20 reads
ARITHABORT
I was coding along one day, working on rolling out some monitoring for a client—monitoring that I had used for previous...
2019-01-07
308 reads
I am extremely happy to announce that I’ll be presenting a preconference training session with Bob Pusateri at this year’s...
2019-01-07
271 reads
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with ever-higher expectations of speed, privacy and returns on investment....
2019-01-07
46 reads
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with...
2019-01-07
323 reads
My third data warehousing tip is to build thin slice. Deliver subsets of valuable functionality. Get feedback and buy in,...
2019-01-16 (first published: 2019-01-07)
2,862 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