Microsoft 'Always On' technology does not support distributed or cross-database transactions. Why not? Grahaeme Ross shows how to investigate cross-database transactions to understand the problem in more detail, and concludes that a Cross-Database transaction can cause loss of data integrity in the commit phase of the two-phase commit.
2015-04-24
7,846 reads
This article shows the steps to set-up distributed transactions for SSIS.
2013-11-07
8,054 reads
Learn about orphaned distribution transactions in SQL Server and how you can clear them.
2013-07-16
5,159 reads
SQL Script to Open DTC for distributed transactions and also configure SQL Server for Distributed Transactions.
2011-08-12 (first published: 2011-08-03)
714 reads
As an example, I am filtering data by Geography. What is happening is that the user has access to one Geographical region (UK), but this is the only region shown within its Parent (World), so when Analysis Services performs the Drillthrough, it takes the Parent value, searches by World and presents a security problem as […]
2004-07-06
CREATE TABLE calendar ( CalDate datetime PRIMARY KEY, CalYear int, CalMonth int ) INSERT INTO calendar values ('2003-04-01',2003,4) INSERT INTO calendar values ('2003-05-01',2003,5) INSERT INTO calendar values ('2003-06-01',2003,6) INSERT INTO calendar values ('2003-07-01',2003,7) etcSELECT c.CalYear, c.CalMonth, SUM(ISNULL(a.sales,0)) AS 'Total Sales' FROM calendar c LEFT OUTER JOIN a ON a.[date] < DATEADD(month,1,c.CalDate) WHERE c.CalDate >= '2003-04-01' AND c.CalDate <= '2004-03-31' […]
2004-02-09
I am new to SQL but I was just tasked with moving a database from one server to another. I used sp_detach_db and sp_attach_db then copied the database to the new server. I then ran a script I found that migrates all users ID's and passwords. here is thatr script. Don't know if this helps. […]
2003-08-19
1 reads
jraha - Good call! Joining is faster than using IN statements and using a subquery DOES mean that it gets executed for each row. By the way - does TOP mean anything here? The output does not seem to be ordered so why worry about the TOP? Sidebar: TOP N - ORDER BY have bad […]
2003-07-17
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers