Generate test data using DBGen
Over the last couple of months I have on several occasions found myself in need of test data for demos,...
2012-01-24
14,434 reads
Over the last couple of months I have on several occasions found myself in need of test data for demos,...
2012-01-24
14,434 reads
This past Saturday January 21, 2012 I had the opportunity to speak at my first IT Pro Camp in Orlando,...
2012-01-24
894 reads
In my last post, I wrote that the game plan was to post by Dec. 10 on changes in data...
2012-01-24
1,996 reads
One of the things that has been annoying for a long time in SQL Server is adding lots of data...
2012-01-23
29,065 reads
Inspired by common emails and questions I see, I figured I’d do a series of blog posts on common mistakes...
2012-01-23
1,004 reads
I was working on a Cube in Analysis Services for a client recently and needed to sort on a field...
2012-01-23
3,867 reads
Since Microsoft recently released a couple of new Cumulative Updates for SQL Server 2008, I thought it was finally time...
2012-01-23
1,188 reads
I get 15-30 calls/emails a week from recruiters (not counting the dozens of auto-generated emails I get). Being a contractor...
2012-01-23
912 reads
Remember kids...
Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do...
2012-01-26 (first published: 2012-01-23)
3,587 reads
There are four different ways you can get information about deadlocks in your system. These are:
traceflag 1204traceflag 1222trace eventsextended eventsFor...
2012-01-27 (first published: 2012-01-23)
3,088 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