Adaptive Query Processing - Adaptive Joins - Plan resue - 3
Continuing on the series on Adaptive Query Processing covered overhere, this post would cover what happens to adaptive joins when...
2017-12-23
558 reads
Continuing on the series on Adaptive Query Processing covered overhere, this post would cover what happens to adaptive joins when...
2017-12-23
558 reads
Despite it being new, it seems there are a handful of "facts" already published about it that may or may not be accurate. Due to that, I want to...
2017-12-22
23 reads
I have been working on this article for far longer than one might think is necessary for something of this...
2017-12-22
129 reads
I have been working on this article for far longer than one might think is necessary for something of this...
2018-01-04 (first published: 2017-12-22)
2,036 reads
There have been a number of enhancements to Hadoop recently when it comes to fast interactive querying with such products...
2017-12-22
108 reads
There have been a number of enhancements to Hadoop recently when it comes to fast interactive querying with such products...
2017-12-22
1,768 reads
One of the most underutilized assets in SQL Server Management Studio is the SSMS project. Within Management Studio, one can...
2017-12-22
552 reads
Introduction
Hello everybody! Welcome back! One of my favorite features in Azure SQL DBaaS is Failover Groups. I have been working...
2017-12-22
176 reads
Data visualization should be iterative. You should get a good initial draft put together and then check to make sure...
2017-12-22
806 reads
When I first moved to the city where I now live, I found an oil change place just a couple...
2017-12-21
390 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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...
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