Clustered Column Store Load Pitfalls – Magic number 64 when using WHERE IN clause
The Problem
During our workload we have recognized a difference in performance for queries using IN clause. We are building query...
2018-12-18
189 reads
The Problem
During our workload we have recognized a difference in performance for queries using IN clause. We are building query...
2018-12-18
189 reads
Docker and Container making my life great. these days I can explore every thing using this. I have installed MongoDB...
2018-12-18
318 reads
When doing any new development or major overhaul of existing SSIS architecture, I almost always recommend to clients that they deploy those packages to the SSIS catalog. Using the...
2018-12-18
33 reads
When doing any new development or major overhaul of existing SSIS architecture, I almost always recommend to clients that they...
2018-12-18
356 reads
DBAs have plenty of day-to-day tasks to do as part of the administration, but one overarching task is managing the...
2018-12-17
264 reads
One of the important tasks that is needed for any organization that wants to better protect their sensitive data is...
2018-12-17
360 reads
Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF as an orchestration tool instead of an Extract-Transform-Load (ETL)...
2018-12-17
93 reads
Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF...
2018-12-17
552 reads
It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup opening ceremony. That was also the year (1998) when...
2018-12-17
28 reads
It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup...
2018-12-17
243 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