Last Week Reading (2019-03-24)
OMG! My brain almost blew up. All because of MVP Summit I’ve just returned from. Obviously (due to NDA), I can’t tell you what I’ve seen and found out,...
2019-03-25
11 reads
OMG! My brain almost blew up. All because of MVP Summit I’ve just returned from. Obviously (due to NDA), I can’t tell you what I’ve seen and found out,...
2019-03-25
11 reads
Learn how to get a list of all Unicode characters to copy and paste, or use in queries / web pages / programs, or search by value, etc.… Continue...
2019-03-25
658 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-03-25
983 reads
This is in response to someone asking about getting started with their database in SQL Source Control and then hosting at BitBucket. I’m going to assume people can set...
2019-03-25
441 reads
I love the questions I get when presenting: Can You Force a Parallel Plan in Query Store. I haven’t a clue. The trick I think is going to be...
2019-03-25
111 reads
Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server ... Continue reading
2019-03-25
49 reads
There seems to be a myth out there that when deadlocks come a-knocking, then just throw this little directive (ROWLOCK) at it and all will be well. This is...
2019-03-25
19 reads
There seems to be a myth out there that when deadlocks come a-knocking, then just throw this little directive (ROWLOCK) at it and all will be well. This is...
2019-03-25
251 reads
Good day! Good week! Let’s start it with some news form the Data Platform world!
SQL Internals – Physical Table Structure under...
2019-03-25
261 reads
Setup the DRU What is it? The Distributed Replay Utility (DRU) on SQL Server allows you to capture Profiler trace information on one or more client servers and then...
2019-03-24
236 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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