SQL Homework – March 2022 – Formatting
Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries ... Continue reading
2022-03-01
13 reads
Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries ... Continue reading
2022-03-01
13 reads
I’ve gotten used to using the Command Palette in VS Code/ADS/Sublime Text regularly to find some setting or change something. What felt strange at first has become a habit...
2022-02-28
138 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...
2022-02-28
22 reads
In the last few Fundamentals posts you were introduced to a couple of ways to limit and control the data stored in the tables in your database. A primary...
2022-02-28
34 reads
We’re reading in some JSON files in Azure Data Factory (ADF), for example for a REST API. We’re storing the data in a relational table (SQL Server, Azure SQL...
2022-02-28
1,696 reads
I’m thrilled to be presenting a new session on SQL Server-on-VMware storage performance tuning as part one of four in the ActualTech Media Expert webinar series this Friday, March...
2022-02-28
68 reads
Today I’m talking about Extent Management in SQL Server, because this is a very important topic, especially when you deal with TempDb in SQL Server. On a very high...
2022-02-28 (first published: 2022-02-14)
647 reads
Just like that puppy you got during the pandemic, your databases hunger for more. And they grow. And occasionally make a mess. I’ll stop the analogy. Anyhow, it’s worthwhile...
2022-02-28
230 reads
Welcome to the latest recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the...
2022-02-28
162 reads
Welcome to a new recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the...
2022-02-28
66 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