SSC Editorial: Would You Move for a Job?
I won’t say never, but it’s unlikely I’d move for a job – my roots are here in Orlando and I...
2016-04-07
455 reads
I won’t say never, but it’s unlikely I’d move for a job – my roots are here in Orlando and I...
2016-04-07
455 reads
Let it be known that the word “backup” is a noun (it refers to a thing), and “back up” is a verb (it...
2016-04-07
528 reads
Hi Everyone
In the daily team meeting today, we had a requirement to find out the stored procedure used/referenced by SSRS...
2016-04-07
1,577 reads
SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...
2016-04-07
1,896 reads
Backup is one of the major task for DBAs, it has many different options and ways for each companies to...
2016-04-07
1,647 reads
What do you need to do in order to access data in a SQL Server that’s encrypted with Always Encrypted?...
2016-04-06
842 reads
To Install and Getting started with MongoDB refer the below links
Getting Started with MongoDBInstall MongoDB 3.2 on WindowsInstallation Guide
How to...
2016-04-06
532 reads
With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS,...
2016-04-06
717 reads
Register to attend this joint chapter meeting at https://www.eventbrite.com/e/opassmagicpass-joint-april-meeting-w-ben-miller-tickets-24457339561.
OPASS and MagicPASS are proud to present a special joint meeting with Ben...
2016-04-06
572 reads
This is one of those frequently ignored best practices.
When you create an object, specify the schema where it will...
2016-04-06
718 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