VirtualBox – Cannot Register the Hard Drive Because a Hard Drive with UUID Already Exists
Virtualization is awesome! It really helps when you are a developer. On my laptop I don’t even have SQL Server...
2011-12-21
5,414 reads
Virtualization is awesome! It really helps when you are a developer. On my laptop I don’t even have SQL Server...
2011-12-21
5,414 reads
As I write this the final hours for the 2011 PASS Board of Directors elections are ticking away. Before the...
2011-12-20
956 reads
I've used SQL to generate countless blobs of xml over the years and one feature that I have come to...
2011-12-20 (first published: 2011-12-15)
8,869 reads
Back when i was in school, me and a bunch of friends used to hangout at a diner. The diner was...
2011-12-20
6,738 reads
A tribute is an expression of gratitude or praise. As I head into this holiday season I wanted to express...
2011-12-20
525 reads
If you are like me then you like to reinstall Windows on your laptop every few months to keep things...
2011-12-20
936 reads
One task that often needs to be done when migrating a database to production for the first time is to...
2011-12-20
1,427 reads
A good rule of thumb with the public role is to leave it be. Do not add permissions to this role. Add permissions on a per database and per...
2011-12-20
23 reads
With SQL Server 2012 comes a new set of conversion functions, that will certainly help doing type casts and conversions...
2011-12-20
1,218 reads
Looking at 2011 and the planned events so far for 2012 it’s easy to see that SQLSaturday is starting to...
2011-12-20
663 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