TSQL Challenge #12 - Build sequential ranges of dates with propagation to missing values
Take the new challenge from MVP Jacob Sebastian. Deadline is next Monday.
2009-08-18
4,515 reads
Take the new challenge from MVP Jacob Sebastian. Deadline is next Monday.
2009-08-18
4,515 reads
A new PASS chapter is now on the island of Curacao. Roy Ernest, longtime SQLServerCentral contributor, runs it. Come support this chapter in the Caribbean.
2009-07-28
383 reads
Come see John Welch speak on Getting Started With Analysis Services 2008, July 7, 2009 in Columbia, SC
2009-06-25
1,554 reads
It's time for the Exceptional DBA Awards again, and SQLServerCentral.com and Red Gate want to give recognition to a DBA for outstanding work and achievements. Enter Today!
2009-06-15
1,386 reads
If you are near Ahmedabad, come to this event with MVPs Pinal Dave and Jacob Sebastian.
2009-06-12
426 reads
SQLSaturday #17 will be held Aug 1, 2009 in Baton Rouge, LA. Read more about it.
2009-06-10
232 reads
Birmingham (May 20), Pensacola (June 6), and Portland (June 6) are upcoming SQLSaturday events. If you are in the area, please attend.
2009-06-04 (first published: 2009-05-05)
1,524 reads
Come learn about advanced data modeling with Paul Neilsen and DMVs with Glenn Barry, Thur, May 21 in Denver. Steve Jones will attend as well.
2009-05-20
1,223 reads
2009-05-19
751 reads
The June meeting of the Triangle SQL Server User group features MVP Andy Leonard. If you are in the Raleigh area, check this out.
2009-05-18
338 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