Zero Width Characters
Another bit of miscellany, this one shows how you can use zero width characters to tag/fingerprint data. Reminds me of...
2018-07-23
566 reads
Another bit of miscellany, this one shows how you can use zero width characters to tag/fingerprint data. Reminds me of...
2018-07-23
566 reads
PsPing tool is part of the sysinternals PsTools download found – ( https://docs.microsoft.com/en-us/sysinternals/downloads/psping) This is the tool of choice when wanting to...
2018-07-23
678 reads
Another break for me. This might actually be the first year I use all my vacation allowance.
In any case, I’m...
2018-07-23
846 reads
As always with something like this, I like to start with a definition so we are all starting in the...
2018-07-23
181 reads
When a space growth operation is done within SQL Server (create, restore, auto-grow) the engine places zeros across the file...
2018-07-23
138 reads
I’ve written many posts on SQL Saturdays , especially the one at Louisville. This one is a bit different. This is...
2018-07-23
249 reads
When someone says still uses SQL Profiler.
Image is taken from hereAn ancient, dark place, a source of many legends and...
2018-07-23
1,592 reads
I’m a Windows guy.
Kinda have had to be, given my profession as a SQL Server DBA. But recently I’ve become...
2018-07-23
313 reads
If you are working on SQL Server Availability Group Databases, you may have seen that Availability Group is online but at-least...
2018-07-23
956 reads
I am extremely proud to announce that I am presenting in conjunction with VMware Corp. an all-day boot camp for...
2018-07-21
392 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