4 replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
source | link

Possible Duplicate:
Does SSRS lock the table when querying?Does SSRS lock the table when querying?

I'm using SQL Server 2008 R2 and Reporting Services. Do the reports block other queries or are they executed in highly isolated transactions, such as a snapshot?

Next obvious question: Can reporting services produce deadlocks or timeouts in other queries as a result of locking tables for a long time?

Possible Duplicate:
Does SSRS lock the table when querying?

I'm using SQL Server 2008 R2 and Reporting Services. Do the reports block other queries or are they executed in highly isolated transactions, such as a snapshot?

Next obvious question: Can reporting services produce deadlocks or timeouts in other queries as a result of locking tables for a long time?

Possible Duplicate:
Does SSRS lock the table when querying?

I'm using SQL Server 2008 R2 and Reporting Services. Do the reports block other queries or are they executed in highly isolated transactions, such as a snapshot?

Next obvious question: Can reporting services produce deadlocks or timeouts in other queries as a result of locking tables for a long time?

3 insert duplicate link
source | link

Possible Duplicate:
Does SSRS lock the table when querying?

I'm using SQL Server 2008 R2 and Reporting Services. Do the reports block other queries or are they executed in highly isolated transactions, such as a snapshot?

Next obvious question: Can reporting services produce deadlocks or timeouts in other queries as a result of locking tables for a long time?

I'm using SQL Server 2008 R2 and Reporting Services. Do the reports block other queries or are they executed in highly isolated transactions, such as a snapshot?

Next obvious question: Can reporting services produce deadlocks or timeouts in other queries as a result of locking tables for a long time?

Possible Duplicate:
Does SSRS lock the table when querying?

I'm using SQL Server 2008 R2 and Reporting Services. Do the reports block other queries or are they executed in highly isolated transactions, such as a snapshot?

Next obvious question: Can reporting services produce deadlocks or timeouts in other queries as a result of locking tables for a long time?

    Post Closed as "exact duplicate" by Jon Seigel, Jack Douglas of
2 improved formatting
source | link

I'm using SQL Server 2008 R2 and reporting servicesReporting Services. Do the reports block anotherother queries or are they executed in highly isolated transactions (such, such as a snapshot)?

Next obvious question: Can reporting services produce deadlocks or timeouts in other queries (becauseas a result of locking tables for a long time) ?

Thanks!

I'm using SQL Server 2008 R2 and reporting services. Do the reports block another queries or are they executed in highly isolated transactions (such as snapshot)?

Next obvious question: Can reporting services produce deadlocks or timeouts in other queries (because of locking tables for a long time) ?

Thanks!

I'm using SQL Server 2008 R2 and Reporting Services. Do the reports block other queries or are they executed in highly isolated transactions, such as a snapshot?

Next obvious question: Can reporting services produce deadlocks or timeouts in other queries as a result of locking tables for a long time?

1
source | link