DBA best practices..from the DBA from Heaven
I met Tom Roush for the first time around 9 years ago – at a PASS Summit. If I recall right...
2018-02-01
704 reads
I met Tom Roush for the first time around 9 years ago – at a PASS Summit. If I recall right...
2018-02-01
704 reads
I decided to go to the SQL Saturday at Nashville this year to get some good learning and networking in...
2018-01-15
450 reads
T-SQL Tuesday is a monthly blog party started by respected SQL Guru Adam Machanic. I was honored with hosting this...
2017-12-18
830 reads
This month’s T-SQL Tuesday is hosted by…er..yours truly. I picked a topic that usually comes up for me every December...
2017-12-25 (first published: 2017-12-11)
2,404 reads
This is my first opportunity hosting a T-SQL Tuesday and am super excited!!T-SQL Tuesday is the brainchild of well respected SQL Guru...
2017-12-04
960 reads
This month’s T-SQL Tuesday is hosted by Ewald Cress, and the topic is ‘Folks who have made a difference’. This...
2017-11-14
441 reads
Last week I listened to a podcast from one of my best friends in the sql community – Kendra Little. In...
2017-11-23 (first published: 2017-11-11)
2,015 reads
I have been a PASS summit attendee for 14 years now. This year is my 15th. Every year is different...
2017-11-05
716 reads
ANOVA – or analysis of variance, is a term given to a set of statistical models that are used to analyze...
2017-10-16 (first published: 2017-10-09)
2,566 reads
R is particularly good with drawing graphs with data. Some graphs are familiar to most DBAs as it has been...
2017-10-03 (first published: 2017-09-25)
2,674 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