SQLSaturday Bloopers
Traveling to Charlotte, NC for SQL Saturday #33, Steve Jones takes a break from writing with a short piece, and quite a few mistakes from this year.
2010-03-05
123 reads
Traveling to Charlotte, NC for SQL Saturday #33, Steve Jones takes a break from writing with a short piece, and quite a few mistakes from this year.
2010-03-05
123 reads
Does it make sense to set up another instance of SQL Server just for a power user? Is it a good use of resources? Steve Jones comments today on this DBA tool for enhancing performance.
2010-03-04
181 reads
Software pricing is a controversial topic, but Steve Jones found an article saying many enterprises would prefer usage based pricing. Do you think it's better?
2010-03-03
199 reads
When getting help online, you need to be professional and a part of that is being responsible. Steve Jones reminds us today that we have to be careful about what we post.
2010-03-02
574 reads
Do you put an identity column on every table? That might be a bad habit you want to kick, but not all at once. Steve Jones comments on this common data modeling practice.
2010-03-01
371 reads
This past week's news had a lot of news about cloud computing and Steve Jones comments on a few database related items.
2010-03-01
100 reads
For this Friday poll, Steve Jones asks about storing time values. Should they always be in UTC? Does that solve more problems than it creates?
2010-02-26
338 reads
A guest editorial from Tim Mitchell today talks about the way you handle problems. Other people's problems. A professional way of pointing out mistakes is the best policy.
2010-02-25
329 reads
Google recently unveiled a dashboard to allow users to manage the data that Google stores about them. Including removing search data! Steve Jones comments on the possibility of implementing this for other companies.
2010-02-24
422 reads
Should we evolve the database mirroring technology to work with multiple mirrors? Steve Jones says this might be an interesting idea.
2010-02-23
347 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