The Value of Shortcuts
Decades ago when I was working as a retail clerk, I had a boss named Billy. Billy was a pragmatic...
2017-12-16
421 reads
Decades ago when I was working as a retail clerk, I had a boss named Billy. Billy was a pragmatic...
2017-12-16
421 reads
This blog post is about Team Foundation Server (TFS) and is about the situation where you need remember to update...
2017-12-16
540 reads
I have had a problem with DSC in Azure Automation for a few months now, there was a change made...
2017-12-15
357 reads
I have had a problem with DSC in Azure Automation for a few months now, there was a change made to the xSqlServer DSC resource which meant that the...
2017-12-15
22 reads
I have had a problem with DSC in Azure Automation for a few months now, there was a change made...
2017-12-15
63 reads
I have had a problem with DSC in Azure Automation for a few months now, there was a change made...
2017-12-15
101 reads
Back before I started doing technical presentations or writing blog posts, I frequently found myself in awe at those who...
2017-12-15
609 reads
There are a few different choices for tools to use when it comes to SQL Server, while the "experienced" amongst...
2017-12-14
354 reads
There are a few different choices for tools to use when it comes to SQL Server, while the “experienced” amongst us have used query analyzer, enterprise manager and probably...
2017-12-14
16 reads
There are a few different choices for tools to use when it comes to SQL Server, while the “experienced” amongst...
2017-12-14
49 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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