Fragmentation Fear
Index fragmentation can certainly cause performance problems, but should it really dictate the way we design our clustered indexes?
2012-10-01
428 reads
Index fragmentation can certainly cause performance problems, but should it really dictate the way we design our clustered indexes?
2012-10-01
428 reads
Companies may look to outsource security in order to take advantage of experts' skills at a lower price. What will that mean for data professionals?
2012-09-27
117 reads
Today Steve Jones talks about pair programming and when it might make sense for data professionals.
2012-09-26
203 reads
When working on a project, you have to make trade-offs. Unfortunately, some managers don't realize this. Steve Jones says we need to help them understand that doing things the right way, and working with trade-offs, makes for better systems.
2012-09-25
147 reads
The forecast for IT work is growing. That's good for those of us working in the field.
2012-09-24
174 reads
If we rewrite the coding rules, will software be more secure? Steve Jones thinks it might and that we should be constantly looking to change the techniques, patterns, and skills we have.
2012-09-24
231 reads
This Friday Steve Jones wants you to have some fun and compare yourself to an athlete or media figure, or even a fictional character.
2012-09-21
149 reads
Worms have been around a long time in computer systems. However changes in the global policies of governments and the possible retaliation for cyber warfare should have DBAs concerned.
2012-09-20
170 reads
2012-09-19
203 reads
Data grows constantly and the size of some of our databases seems to have no end in sight. Steve Jones notes that we might just want to compress everything, just to keep up.
2012-09-18
292 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