Reduce your Azure Development Subscription Cost
Azure VMs
Usually you should convey to developers and testers to shut down the VMs manually when they are not using non production virtual machines. Also there some ways to...
2018-09-11
44 reads
Azure VMs
Usually you should convey to developers and testers to shut down the VMs manually when they are not using non production virtual machines. Also there some ways to...
2018-09-11
44 reads
Are you looking to do a major update to your data warehouse or looking to modernize? Many technologies have come...
2018-09-27 (first published: 2018-09-11)
3,079 reads
Introduction
In this blog post, I would like to explain what a columnstore segment elimination is and how to load data...
2018-09-11
204 reads
This post is part of #tsql2sday event :)I know, in the world of the database administrators and developers, the triggers...
2018-09-11
562 reads
I love New York. Every time I get to travel to the city, I get excited and look forward to...
2018-09-11
320 reads
Anything that happens in a trigger happens within the same transaction of the command that called it.
Part of me feels...
2018-09-11
223 reads
This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches...
2018-09-11
267 reads
It’s the second Tuesday of the month which must mean only one thing…
We’re all skint and payday feels like a...
2018-09-11
288 reads
Overview
In most of the cases, users create a backup file of their database on their machine. This help the users to perform recovery at the time of any disaster,...
2018-09-11
39 reads
Overview
In most of the cases, users create a backup file of their database on their machine. This help the users...
2018-09-11
1,814 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