Join me next week at my first GroupBy session
2021 has been the year people want to learn about Temporal Tables, it seems. Not only am I speaking at the SQL Trail conference next week, but I was...
2021-10-20
59 reads
2021 has been the year people want to learn about Temporal Tables, it seems. Not only am I speaking at the SQL Trail conference next week, but I was...
2021-10-20
59 reads
My updated course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available on Pluralsight here! If you want to learn about the course, check out the trailer...
2021-10-20
81 reads
Recently a customer was asking about how they could move data with SQL Data Compare from one server to another. In this case, the customer had a complex join...
2021-10-20 (first published: 2021-10-04)
388 reads
I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an interesting way to comment an IF-THEN-ELSE ... Continue reading
2021-10-19
79 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-19
28 reads
CREATE DATABASE [Story]
ON PRIMARY
( NAME = N'Story', FILENAME = N'C:DataStory.mdf',SIZE = 101MB),
FILEGROUP [Line1]
( NAME = N'File1', FILENAME = N'C:Data_.It',SIZE = 102MB),
( NAME =...
2021-10-18 (first published: 2021-09-30)
528 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-18
29 reads
As we all know there is already a lot of information available about SQL Server related topics in English. But I’m also dealing more and more with customers who...
2021-10-18
45 reads
As we all know there is already a lot of information available about SQL Server related topics in English. But I’m also dealing more and more with customers who...
2021-10-18
62 reads
As we all know there is already a lot of information available about SQL Server related topics in English. But I’m also dealing more and more with customers who...
2021-10-18
16 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