SQL Server 2022 is Coming
We still don’t have an exact release date for SQL Server 2022 but at this stage we can have strong confidence that it will be with us before the...
2022-11-15
107 reads
We still don’t have an exact release date for SQL Server 2022 but at this stage we can have strong confidence that it will be with us before the...
2022-11-15
107 reads
Today’s coping tip is to get outside and observe the changes in nature around you . Nature is changing in Colorado as winter approaches. It’s been a dry year,...
2022-11-14
37 reads
My journey might be somewhat unusual, but perhaps not. I started writing articles on the Internet at a few different places before I started SQL Server Central. There were...
2022-11-14 (first published: 2022-11-01)
106 reads
Back in July I suggested that you get your resume up to date. It’s something I’d wish I’d kept up ... Continue reading
2022-11-14 (first published: 2022-11-01)
284 reads
Hello Dear Reader! Last week I was fresh off of finishing the Run Dinsey 5K, 10K, & Food and Wine Half Marathon. My good friend Josh Luedeman (@JoshLuedeman |...
2022-11-14
105 reads
Many of us have learned how to research and get new information online. I certainly think the written word, whether from formal articles at places like SQL Server Central...
2022-11-14
18 reads
As I write this, it’s the weekeend before PASS Data Community Summit 2022 and depending upon when I finish, it’ll post either shortly before SQL Saturday Oregon, or in...
2022-11-12
62 reads
Cloning is a powerful feature within snowflake (also known as zero copy clone). You can obviously clone at the database or schema level but also tables too. It’s a...
2022-11-11
114 reads
In a few previous articles, I have talked a lot about Managed Service Accounts (MSA) and Service Principal Names (SPN) and given examples of managing the separately. As a...
2022-11-11 (first published: 2022-11-01)
379 reads
Today’s coping tip is to make a list of new things you want to do before the end of the year. Hmm, definitely some things to do, but what’s...
2022-11-11
23 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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