SQL Server Central Guest Editorial
My second guest editorial is up at SQL Server Central. These are fun to do (especially the video) even though they’re...
2009-10-14
562 reads
My second guest editorial is up at SQL Server Central. These are fun to do (especially the video) even though they’re...
2009-10-14
562 reads
If you’re involved with maintaining Microsoft Operations Manager, you probably have a few things you’d like to tell the developers,...
2009-10-13
529 reads
I keep seeing these concepts that have long been disproven, posted again and again on newsgroups as if they were valid information. The...
2009-10-13
680 reads
Well, part of one anyway. I wrote three chapters of Rob Walter’s new book, Beginning SQL Server 2008 Administration. I...
2009-10-10
560 reads
The PASS Summit is only three weeks away and I’m getting awfully excited. It’s not too late to register. Heck,...
2009-10-10
650 reads
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and...
2009-10-08
605 reads
Brent Ozar, Andy Warren and Jeremiah Peschka have put together a blogger award called the PASS Log Reader Award. I...
2009-10-08
733 reads
Ohio?
I’m presenting on Thursday to the Columbus SQL Server Users Group, home of the newly minted MVP, Jeremiah Peschka (congrats again)....
2009-10-06
547 reads
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-05
3,215 reads
Great news. We’ve managed to get one article all the way through the process. We’ll have our first publication out...
2009-10-02
733 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