Initialize a Transactional Replication from a Database Backup
During the last days I'm working on Replication – especially with Transactional Replication.
The main idea of Transactional Replication is that you...
2012-08-05
9,255 reads
During the last days I'm working on Replication – especially with Transactional Replication.
The main idea of Transactional Replication is that you...
2012-08-05
9,255 reads
During the last days I’m working on Replication – especially with Transactional Replication. The main idea of Transactional Replication is that...
2012-08-05
1,561 reads
Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I'm
talking about Extents, and how SQL...
2012-08-04
1,136 reads
Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I’m talking about Extents, and how...
2012-08-04
649 reads
We are all living in a fast moving world, especially in the IT industry. We have to
learn new technologies every...
2012-08-01
1,316 reads
We are all living in a fast moving world, especially in the IT industry. We have to learn new technologies...
2012-08-01
505 reads
Yesterday evening (European Time zone) Microsoft has released the SP2 for SQL Server
2008 R2. You can download the Service Pack...
2012-07-27
2,593 reads
In the last 2 blog postings you have learned how to setup your first Availability
Group with SQL Server 2012. Today...
2012-07-31 (first published: 2012-07-26)
4,741 reads
Der Sommer 2012 ist schon ein interessantes Phänomen
– gestern Sonnenschein mit 34°, und heute wieder Regen mit 20°. Gestern war...
2012-07-25
1,304 reads
In the last blog posting about AlwaysOn you have seen how you can deploy your first
Availability Group through the AlwaysOn...
2012-07-25 (first published: 2012-07-23)
7,148 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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