Cloning a SQL Server Database
The following script will backup and restore a database to the same server with a different name. Tested on SQL...
2014-03-01
55 reads
The following script will backup and restore a database to the same server with a different name. Tested on SQL...
2014-03-01
55 reads
The role of PASS in the community has evolved a lot over the past few years. Back in 2006/2007 PASS...
2014-02-28
1,309 reads
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2014-02-28
1,458 reads
Come join me for this webinar on 3/13/2014 at 11:00 AM EST
Introduction to Power BI
The future of Business Intelligence has...
2014-02-28
1,358 reads
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in...
2014-02-28
1,787 reads
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-02-28
1,464 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-02-28
1,139 reads
Why wait statistics are important and how you can start collecting them now!
Wait statistics have always been a very important...
2014-02-28
1,405 reads
If you work in IT, the office becomes your second home. It’s where we make a living, and most of...
2014-03-11 (first published: 2014-02-28)
2,968 reads
This is part of a series where I set up a virtual lab for testing and misc. work. The other...
2014-02-27
1,477 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...
Comments posted to this topic are about the item Adding Bits I
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