Do You Need A Log Recovery Tool?
A couple of weeks ago I wrote a post dispelling the myth that the simple recovery model disables the transaction...
2013-11-04
963 reads
A couple of weeks ago I wrote a post dispelling the myth that the simple recovery model disables the transaction...
2013-11-04
963 reads
Don’t tell Brent Ozar, but here’s another DBA writing another helpful article about shrinkage. Before he gets bent out of...
2013-11-08 (first published: 2013-11-04)
3,992 reads
I just posted a new version of sp_BackupDatabases. The biggest change is that the procedure now creates one-time SQL Agent...
2013-10-29
1,629 reads
Welcome to the first issue of what I hope will become a monthly series called “What’s In My Utility Belt?”....
2013-10-29
586 reads
“Psssst….”
“Hey buddy! Yeah, you there in the propeller hat. You’re a SQL nerd, right? Can you help me tune this...
2013-10-24
934 reads
If you’ve spent any time with me in person, trading war stories, you’ve likely heard my rant about the consultant...
2013-10-21
6,289 reads
First, let me say that yes, I’m aware of Ola Hallengren’s excellent set of maintenance scripts, including those for doing...
2013-10-05
394 reads
I’ve been struggling for months to bring this blog back to life. I’d love to produce content dedicated to the...
2013-10-02
439 reads
Nobody wants duplicate data. It’s messy, wastes space, and looks really bad on a report – I get that. What I...
2013-10-02
1,337 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