Adding File to Database in AlwaysOn Availability Group
When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database,...
2018-07-27
6,256 reads
When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database,...
2018-07-27
6,256 reads
Keep up with SQL Server Patches with us with our feed from Microsoft. Check it out! http://vitamindba.com/sql-server-releases/
The post Keep up with...
2018-07-26
315 reads
It’s a time to turn the corner from “DBA” to “DBA specialist”. This in-depth guide explores the importance of database...
2018-07-26
407 reads
In the SQL Server AlwaysOn setup, whenever you are using a listener to connect to a secondary node, you have...
2018-08-10 (first published: 2018-07-26)
2,599 reads
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote...
2018-08-08 (first published: 2018-07-25)
2,045 reads
In this module you will learn how to use the Acterys Matrix Light. Acterys Matrix Light is designed primarily for...
2018-08-14 (first published: 2018-07-25)
2,166 reads
In this article, we’ll see the how the backup-and-restore meta-data tables store the information in the MSDB database. How do...
2018-07-25
347 reads
In this article, you’ll see the Q&A about the database restore and recovery internals. To learn a lot about SQL...
2018-07-25
340 reads
Let’s deep dive and review each of the database backup command topics to get a better understanding of what it...
2018-07-25
330 reads
I like to write Pester checks to make sure that all is as expected! This is just a quick post...
2018-07-25
1,301 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