Awareness
This week Steve Jones looks back at the T-SQL Tuesday blog part and its theme of monitoing.
2015-05-18
88 reads
This week Steve Jones looks back at the T-SQL Tuesday blog part and its theme of monitoing.
2015-05-18
88 reads
Would you want a query optimizer that searches for the best plan for your code? Steve Jones thinks this might not be a bad idea.
2015-05-15 (first published: 2010-09-13)
297 reads
2015-05-13
849 reads
Tim O'Reilly, head of O'Reilly publishing, has been an advocate of better date movement in the world. Steve Jones has a few comments on an interview he gave earlier this year.
2015-05-12
115 reads
In which Phil Factor claims that professional application development requires a broad knowledge base.
2015-05-11
114 reads
The recent SQL Server 2014 Service Pack fiasco wasn't the first, but hopefully it won't be the last.
2015-05-11
228 reads
Steve Jones looks at the next version of SQL Server, SQL Server 2016. Until this week, it was known as vNext.
2015-05-07
287 reads
2015-05-04
79 reads
When we write scripts, we often assume many settings will be at some default value. When we generate scripts, that's not the case. Perhaps we should be sure that we always include the settings we expect.
2015-05-04
151 reads
This week Steve Jones has a poll on performance tuning code. Since many people aren't experts, the answers this week might help them learn where to focus their efforts.
2015-05-01
254 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