4 Reasons To Avoid VARCHAR(8000)
Watch this week's video on YouTube
When first learning SQL Server, I had the brilliant idea of defining every column on my table as VARCHAR(8000). After all, the VARCHAR datatype...
2019-03-19
27 reads
Watch this week's video on YouTube
When first learning SQL Server, I had the brilliant idea of defining every column on my table as VARCHAR(8000). After all, the VARCHAR datatype...
2019-03-19
27 reads
Watch this week's video on YouTube
When first learning SQL Server, I had the brilliant idea of defining every column on my table as VARCHAR(8000). After all, the VARCHAR datatype...
2019-03-19
21 reads
It is MVP Summit time! I have not made it this year unfortunately. I hope all MVPs have a greate...
2019-03-18
360 reads
I’ve recently published an article, “Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures,” over on Simple Talk. In the article, I discuss:...
2019-03-18
25 reads
dbatools is a very well known tool within the SQL Server community, and probably most of the production DBA’s are...
2019-04-04 (first published: 2019-03-18)
2,519 reads
I’m sure by now you’ve heard of the GDPR and some of the large scale data breaches that have occurred within it. If you haven’t heard of the GDPR,...
2019-03-18
24 reads
I’m sure by now you’ve heard of the GDPR and some of the large scale data breaches that have occurred...
2019-03-18
347 reads
I’m in Redmond, or Bellevue, or somewhere nearby. Not completely sure where the Microsoft MVP Summit is this week (as...
2019-03-18
557 reads
I’m a big fan of T-SQL Tuesday. Each month there is a host who comes up with a topic, and...
2019-03-18
460 reads
One of the frequently required job functions of the database administrator is to track disk space consumption. Whether this requirement comes from management or from a learning opportunity after a...
2019-03-18
22 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