2018-10-04
86 reads
Editorial
2018-10-03
57 reads
Are Indexes Actually Changes to the System?
Is an index change equivalent to a code change? Steve Jones asks the question and has a few thoughts.
2018-10-02
204 reads
Give Up on Natural Primary Keys
With the need to remove older data, Steve thinks natural keys may be obsolete.
2018-10-01
242 reads
The Ever Expanding Data Platform
With lots of news coming out of Ignite, Steve talks about a few of the changes.
2018-10-01
77 reads
Picking the Right Type of Tool For the Job
Do we need the right tool or just a tool? A guest editorial from Andy Warren gives a few thoughts on getting things done effectively.
2018-09-28
87 reads
An Open Thank You to the Microsoft SQL Server Team
Thanks for improving the string or binary data truncated error message.
2018-09-27
192 reads
The Uninteresting But Necessary Work
Data classification may not be fun or even interesting, but it is necessary.
2018-09-26
85 reads
2018-09-24
85 reads
2018-09-24
172 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
Question of the Day
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