Daily Coping 30 Dec 2022
Today’s coping tip is to give thanks. List the kind things others have done for you. I know that my life is great, but it’s because of a lot...
2022-12-30
38 reads
Today’s coping tip is to give thanks. List the kind things others have done for you. I know that my life is great, but it’s because of a lot...
2022-12-30
38 reads
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. December is usually quiet, though this year I spent the...
2022-12-30
27 reads
I am humbled that many posts were submitted for T-SQL Tuesday #157. There is such a wide range of plans to wind down 2022. So enjoy the posts below...
2022-12-30 (first published: 2022-12-20)
267 reads
Today’s coping tip is to ask for help and let someone else discover the joy of giving. I do most of the cooking in the house, but I thought...
2022-12-29
44 reads
People have done creative things with SVG measures in Power BI, ranging from KPI cards to infographics to fun games. For my latest Workout Wednesday challenge, I used SVG...
2022-12-28 (first published: 2022-12-15)
329 reads
Today’s coping tip is to look for something positive to say to everyone you speak to. This works well during the holiday season as most people are in a...
2022-12-28
27 reads
We looked earlier at the various places our data lives – on disk, in memory, in-transit across the network. A good strategy will protect all of these locations –...
2022-12-28 (first published: 2022-12-14)
565 reads
Today’s coping tip is to share a happy memory or inspiring thought with a loved one. This is a memory for me: This came up in a Google Photo...
2022-12-27
34 reads
I’m heading back to VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel I’ve never visited. I’m excited...
2022-12-27
58 reads
I’m doing another webinar on Jan 18, 2023 with the SQL Solutions Group. You can register here and reserve a spot. Scott Klein and I did a webinar last...
2022-12-27
49 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