Azure SQL Data Warehouse Gen2 announced
Monday was announced the general availability of the Compute Optimized Gen2 tier of Azure SQL Data Warehouse. With this performance optimized tier, Microsoft...
2018-05-02
530 reads
Monday was announced the general availability of the Compute Optimized Gen2 tier of Azure SQL Data Warehouse. With this performance optimized tier, Microsoft...
2018-05-02
530 reads
In this module you will learn how to use the Tachometer. The Tachometer for communicating performance against a goal.
Module 101...
2018-05-08 (first published: 2018-05-02)
2,252 reads
Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security...
2018-05-11 (first published: 2018-05-02)
4,189 reads
I’ve really got to make a plan here at some point. So far I’ve been just putting down things as...
2018-05-02
263 reads
In SQL Server the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The...
2018-05-02
411 reads
As a mini project I wanted to use Azure logic apps to pull tweets from my twitter account when people...
2018-05-02
351 reads
I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the...
2018-05-10 (first published: 2018-05-02)
2,919 reads
A few weeks ago I was presenting at SQL Saturday Raleigh and was asked a question that I didn’t know...
2018-05-09 (first published: 2018-05-02)
1,819 reads
I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the same way that SQL Server. No surprise - I...
2018-05-02
84 reads
This post is part 3 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...
2018-05-01
64 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