SQL Server 2008 RTM - Maintenance Plans need Integration Services installed
The tail end of last week was a bit of a throwback week for me. For reasons that I’ll not...
2017-01-31
921 reads
The tail end of last week was a bit of a throwback week for me. For reasons that I’ll not...
2017-01-31
921 reads
I’m delighted to announce that I’m selected as a speaker for the Techorama event.
Techorama is a developer congress focusing (but...
2017-01-31
678 reads
If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about...
2017-01-31
1,183 reads
In this article I will only be discussing the AX product and an easy tweak to make troubleshooting that product much easier from the perspective of the database administrator....
2017-01-30
28 reads
Dynamics AX and SQL Server
More and more I am seeing clients requiring assistance with the Microsoft Dynamics Suite. Each of...
2017-01-30
2,146 reads
2016 was a great year, both personally and professionally. Personally, our family is well and the kids are growing into...
2017-01-30
651 reads
When Redgate purchased ReadyRoll a few years ago, I wasn’t sure this was a great idea. After all, SQL Source...
2017-01-30
788 reads
One of the other DBAs I work with noticed a warning message that was flooding the log files on one...
2017-01-30
1,898 reads
In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well...
2017-01-30
691 reads
This is not an article or a script. I am posting this just to share my experience and I feel...
2017-01-30
993 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. A. Yani No.25 B, Dusun Onggoprayan, Kepolorejo, Kec. Magetan, Kabupaten Magetan, Jawa Timur...
9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132
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