What Counts for a DBA: Laziness
Louis Davidson is willing to bet that a relatively small handful of lazy people have done more for the world than all of the hard working people combined.
2013-03-25
301 reads
Louis Davidson is willing to bet that a relatively small handful of lazy people have done more for the world than all of the hard working people combined.
2013-03-25
301 reads
SQL Server has grown and expanded to provide administrators and developers with a great deal of information on how it processes queries. However Steve Jones asks if you want more information and options for tuning.
2013-03-22
122 reads
The growth of data, and the sheer scale of data we store and manage is stunning. Steve Jones looks at the rates of growth these days.
2013-03-21
183 reads
On this quiet Friday, Steve Jones skips a poll and talks about life. This editorial was originally published on Jun 6, 2008. It is being republished as Steve is on vacation.
2013-03-20 (first published: 2008-06-06)
267 reads
Steve Jones talks about the serious storage that EMC is bringing to the Vatican library.
2013-03-19
226 reads
Today Steve Jones talks about backups. Setting up a process is good, but you cannot count on it working forever. You need to check periodically to be sure it's working, and that your skills are not deteriorating.
2013-03-18
216 reads
This Friday Steve Jones notes that changing and altering your opinions is good and invites you to share things you might have learned that changed your mind in the past.
2013-03-15
147 reads
If you are the type of person that doesn't run DBCC checks, Steve Jones thinks you're a gambler. And you might think about attending SQL Intersection next month in Vegas.
2013-03-14
235 reads
Steve Jones asks the question why so much data in SQL Server is cleared when we restart an instance.
2013-03-13
212 reads
Today Steve Jones gives his vision of the database in the future. He hopes that databases contain more information about not only their objects, but their needs, like backups and maintenance.
2013-03-12
396 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