Another Dive into Transaction Log File Forensics
Over the past three years since I first took a look at the
insides of a Transaction Log file, I have...
2012-11-15 (first published: 2012-11-06)
8,437 reads
Over the past three years since I first took a look at the
insides of a Transaction Log file, I have...
2012-11-15 (first published: 2012-11-06)
8,437 reads
After seeking justice in this matter for years, I am obliged to bring this issue up again (since it affects...
2012-08-02
1,253 reads
With a handful of System Administrators, Network Specialists and DBAs, I gave my third presentation on SQL Server Mirroring this...
2012-06-14
1,529 reads
As a DBA who is always seeking solutions to performance bottlenecks, amidst the
daily rituals of validating backups and other regular...
2012-06-06
1,710 reads
Quebec's Shameful, Coercive Language Law‘Je me souviens’ les palmarès Top 20 de la loi 101 sacrée qui nuit à la...
2012-05-09
15,613 reads
Notes by Hugo S., Print Screens from three Microsoft Presentations
7 December, 2011 with Additions combined from early February 2012 day-long...
2012-03-27
1,261 reads
Free E-Book: Introduction to SQL Server 2012
Ross Mistry and Stacia Misner have again done a wonderful job on this free...
2012-03-20
2,425 reads
Waaaay back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul Nielsen...
2012-03-18
21,335 reads
Starting with the 1000 foot view: During the process of applying changes to a production database - let's call it Change...
2012-03-18
5,189 reads
I have become dependent on my tablet, here is why, thanks to a great summary from the Globe and Mail.
2012-02-23
1,136 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