On the exorcism of Ghost Records
There was a question earlier on one of the SQL forums as to whether or not Ghost Cleanup overwrote the...
2011-06-07
1,898 reads
There was a question earlier on one of the SQL forums as to whether or not Ghost Cleanup overwrote the...
2011-06-07
1,898 reads
I blogged a week ago about the sessions that I submitted for the PASS Summit this year. At the point...
2011-05-18
1,086 reads
Do errors encountered within a transaction result in a rollback?
It seems, at first, to be a simple question with an...
2011-05-17
13,307 reads
I missed the Pass summit last November for a number of reasons, but I’m hoping I can attend this year....
2011-05-10
967 reads
Frikkie Bosch opened the day with a short keynote giving an overview of Denali, talking mostly from a marketing point...
2011-05-09
811 reads
All of the indexing strategy posts I’ve written in the past have been concerned with predicates combined with ANDs. That’s...
2011-05-03
1,061 reads
From Tom LaRock’s latest idea…
For a change I’m not going to mention performance (well, not more than once anyway)...
2011-05-02
1,326 reads
Earlier this year I had a look at a query pattern that I often see on forums and in production...
2011-04-05
5,929 reads
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-22
2,087 reads
Earlier this week I took part in the 24 Hours of PASS live webcast event. There were far more questions...
2011-03-18
717 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