Final Prep for SQL in the City
I can’t believe this will be the fourth SQL in the City in London next week. It’s amazing to me...
2014-10-13
944 reads
I can’t believe this will be the fourth SQL in the City in London next week. It’s amazing to me...
2014-10-13
944 reads
1) Take Full backup of database at Principle Server
BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’
2) Take Log Backup at Principle Server
BACKUP...
2014-10-17 (first published: 2014-10-13)
15,980 reads
Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the...
2014-10-12
1,491 reads
I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to...
2014-10-17 (first published: 2014-10-12)
6,608 reads
Originally posted on Peter's blog:
If a user is a member of Sysadmin server role of SQL Server 2005, the...
2014-10-11
1,316 reads
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-10-10
974 reads
The first week of November, we’ll be at the PASS Summit inSeattle, WA. This is the highlight of most SQL Server speakers’...
2014-10-10
661 reads
Introduction
After finishing up six months of managing the marketing for SQLSaturday Orlando I’ve been going back through all my blog...
2014-10-10
775 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-10-10
477 reads
This is a temporary post that was not deleted. Please delete this manually. (e5bad5db-3b7d-4641-ba91-15ab900e8f70 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2014-10-09
420 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