How to restore the tail end of a transaction log
Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...
2012-05-25 (first published: 2012-05-21)
2,554 reads
Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...
2012-05-25 (first published: 2012-05-21)
2,554 reads
A friend of mine contacted me through email today having a very common problem with a query he had written....
2012-05-25
816 reads
I had the pleasure of attending SQL Saturday 112 this past weekend. This was my second time speaking at a...
2012-05-17
612 reads
I am not one of these anti PC sorta guys, but I do love my MacBook Pro. I have owned...
2012-05-05
655 reads
“Why I joined Linchpin People as a Teammate”
It was announced publicly this past weekend at SQL Saturday #111 that I...
2012-04-19
788 reads
In just two days SQL Saturday 107 will be in full swing. Tomorrow begins their precon with the infamous Kalen...
2012-04-19
647 reads
Linchpin People, LLC is an organization led by Brian Moran and Andy Leonard with Mike Walsh and Robert Pearl as...
2012-04-13
1,027 reads
I was chosen to speak at SQL Saturday 111 in Atlanta GA this weekend. I will be doing my session...
2012-04-13
585 reads
I was recently selected to speak at SQL Saturday 107 in Houston TX. I am really excited to be selected...
2012-03-26
550 reads
I attended my first SQL Skills event in December 2011. Due to a big project at work I was able...
2012-03-16
722 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
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