Renewed as MVP for SQL Server
I have been renewed as an MVP for SQL Server. This is my 4th award. It's humbling to receive the...
2012-01-02
1,266 reads
I have been renewed as an MVP for SQL Server. This is my 4th award. It's humbling to receive the...
2012-01-02
1,266 reads
The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.
Here’s an excerpt:
The concert hall at the Syndey...
2012-01-02
751 reads
Fragmentation of an index can severely affect performance. When logical ordering of the key within a page does not match...
2012-01-02
1,014 reads
SELECT 'Happy '+ DATENAME(dw, GETDATE())Welcome to the penultimate installment of SQL Server A to Z (it’s not often I get to...
2012-01-02 (first published: 2011-12-26)
2,319 reads
Goal Setting
Last year, I did a wrap up post of the year to see where I landed from where I...
2012-01-02
1,000 reads
Blimey, doesn’t seem like a year since I wrote my last end of year review End of year review 2010...
2012-01-01
688 reads
Today is the first day of 2012 and some commentators and bloggers in the SQL Server blog space use this...
2012-01-01
1,094 reads
I received my fourth (or fifth?) renewal notice as a Microsoft MVP this morning. I am proud to be recognized...
2012-01-01
940 reads
What is a role of a DBA in an organization?What are the daily activities of a DBA?What shall I check...
2012-01-01
755 reads
It’s the first day of 2012. Setting New Year Resolutions is often a futile activity – and resolutions I’ve set in...
2012-01-01
411 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