String or binary data would be truncated: get the full picture in SQL Server 2017
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server...
2018-10-31
529 reads
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server...
2018-10-31
529 reads
Creating a table to be in memory compared to standard tables that use the files on disk can have several...
2018-11-13 (first published: 2018-10-31)
7,820 reads
Did you know compression can gain you more than just space on a disk, it can allow you to fit...
2018-11-13 (first published: 2018-10-31)
2,665 reads
It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but...
2018-11-12 (first published: 2018-10-31)
2,920 reads
The title says it all, this year I have been selected as a speaker at the world’s largest Microsoft Data...
2018-10-31
271 reads
Next week is the week when I used to dread looking at Twitter and especially the #PASSsummit hashtag, watching all of...
2018-10-31
274 reads
In this post I will explain what the DACPAC is and how to create it. In previous post in DevOps...
2018-10-31
2,605 reads
(last updated: 2018-11-01 @ 00:50 EDT / 2018-11-01 @ 04:50 UTC )
SQL Server 2017 introduced a new security restriction for SQLCLR in the...
2018-11-12 (first published: 2018-10-31)
3,423 reads
In my previous blog post of this topic, I talked about the definition of what GDPR is and also described...
2018-11-09 (first published: 2018-10-30)
3,503 reads
A while back I wrote a post, Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions
Recently Manish...
2018-11-08 (first published: 2018-10-30)
2,586 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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