Capture Index Maintenance Operations
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index...
2017-12-20
674 reads
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index...
2017-12-20
674 reads
A quick post this week, since it’s that time of the year when people do gift exchanges and put up...
2017-12-20
385 reads
Since I started working as a data professional some 15 years ago, I’ve had an enjoyable and successful career. I...
2017-12-20
358 reads
One of the hardest things you can do as a blogger is to come up with a post topic. Do...
2017-12-20
357 reads
Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing...
2017-12-20
983 reads
Since starting the Guy In A Cube series over three years ago, Adam Saxton has become the front man for...
2017-12-20
374 reads
A little less than 2 years ago, my wife and I loaded up our cats and dog and moved from...
2017-12-20
487 reads
I was honored to be on the author team of the new SQL Server 2017 Administration Inside Out book by...
2017-12-20
810 reads
Quite a few of you have read or attempted the previous puzzle SQL Puzzle 1: Magic Squares
As a quick reminder, when...
2018-01-05 (first published: 2017-12-19)
1,690 reads
For testlab purposes, I often have a group of Azure VMs to manually spin up/spin down at once. I've had...
2017-12-19
389 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