Why you should never use default string lengths.
TL;DR; You probably don’t know what you’re going to get. Even if you do know the person maintaining your code ... Continue reading
2020-03-30 (first published: 2020-03-25)
805 reads
TL;DR; You probably don’t know what you’re going to get. Even if you do know the person maintaining your code ... Continue reading
2020-03-30 (first published: 2020-03-25)
805 reads
My Pluralsight course for new SQL Server DBAs Image credit to Jeff (t) Back in June of 2019, I published this YouTube video covering the highlights of the various...
2020-03-25
80 reads
People have been writing about how evil scalar functions are in SQL Server for ten years. But people still use scalar functions in their code all the time. And...
2020-03-24
93 reads
Or database developer, report writer, whatever. SQL Server, SQL Server Management Studio, and all the tools provide a bunch of ways to get things done. However, some ways are...
2020-03-24
61 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-24
63 reads
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2020-03-24
57 reads
We’ve got a session coming up in the free Redgate Streamed virtual conference on, “How database DevOps levels up remote work.” When thinking about that session I began thinking...
2020-03-23
55 reads
Of all the things that Extended Events does, I’ve found the ability to quickly and easily gather a little bit of data and then use the Data Explorer window...
2020-03-23
106 reads
Travel is limited, or banned, in many cases these days. Events are cancelled or postponed, and there is a limit to how much contact we should have with each...
2020-03-23
27 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-23
34 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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