Storage options for SQL Server database files in Azure
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to store the database files (.mdf, .ldf, and .ndf). Most...
2019-01-29
447 reads
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to store the database files (.mdf, .ldf, and .ndf). Most...
2019-01-29
447 reads
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to...
2019-01-29
1,079 reads
I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here. I’m going to start doing regular live events on...
2019-01-29
18 reads
I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here....
2019-01-29
193 reads
This post will cover the IN clause and another way to rewrite the same logic. I don’t intend to say...
2019-01-29
2,730 reads
Watch this week’s episode on YouTube.
When building indexes for your queries, the order of your index key columns matters. SQL...
2019-01-29
1,042 reads
Watch this week's video on YouTube
When building indexes for your queries, the order of your index key columns matters. SQL Server can make the most effective use of an...
2019-01-29
14 reads
Watch this week's video on YouTube
When building indexes for your queries, the order of your index key columns matters. SQL Server can make the most effective use of an...
2019-01-29
20 reads
This blog post is related to my previous blog post on Azure SQL Managed Instances:
Azure SQL Managed Instance – full blown...
2019-01-29
367 reads
This blog post is one that I have had percolating in the background since around November 2018.
My good mate John...
2019-01-29
1,187 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