Dear SQL DBA: Remembering Robert Davis, DBA Hero
What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that...
2018-08-02
38 reads
What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that...
2018-08-02
38 reads
Yesterday, I was doing SQL Server Database stress and benchmarking testing on the client side. When I started ramping-up more...
2018-08-02
138,582 reads
06/21 was the date that marked my career as data professional, for the first time ever I decided to participate as...
2018-08-01
270 reads
When Microsoft introduced Extended Events (XE) in 2008, they also gave us a built-in XE session called system_health (though it’s...
2018-08-16 (first published: 2018-08-01)
5,569 reads
Recently Brent Ozar posted a link to the PostgreSQL “Don’t do this” page, which I am shamelessly reproducing below, re-tailored...
2018-08-01
525 reads
This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail.
Why database mail?...
2018-08-01
341 reads
A Question
Shortly after the European PowerShell Conference and the PowerShell and Devops 2018 summit in the USA Mike Robbins b...
2018-08-17 (first published: 2018-08-01)
2,757 reads
Recently, I was working on the AlwaysOn Availability group issue where the log records were not moving from primary to...
2018-08-01
489 reads
by Steve Bolton
…………In the last installment of this amateur series of self-tutorials on DIY data mining metrics, we saw how...
2018-08-15 (first published: 2018-07-31)
2,351 reads
The truncate option is fast and efficient but did you know that it takes a certain lock where you could...
2018-07-31
592 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