Provided that you have scheduled (for example hourly) jobs for the...

- Transaction Log Backup

- Transaction Log Copy

- Transaction Log Restore

then when network connectivity is restored, these jobs will continue to...

You're welcome, glad to help.

Hi Geert,

Each page in SQL Server is 8KB in size.

Essentially, a dirty page is an in memory page that has had changes applied to it that are pending being written...

Hi Geert,

Great questions!

You can use the DMV sys.dm_os_buffer_descriptors to find out how much of the "buffer pool" memory is being used by a given database. You can use the following...

You mention that I.T does not have regulation to the extent of other professionalisms but there are organisations that are endeavouring to achieve this.

In the United Kingdom there is a...

Wow 20 joins that seems like quite a lot. I wonder if perhaps you are trying to achieve too much in a single procedure. Are you returning the entire database...

Thanks for the share Kendal, very interesting indeed!

Hello and welcome to the forums.

SQL Server 2008 Internals would be an excellent choice in my opinion.

Kendal/David,

Could you also post your CPU configurations please and whether or not you are using Push or Pull subscriptions.

As I'm sure you know, Push subscriptions place more burden on the...

FWIW I asked Chris about the author's suggestion and he indicated that he's never had a case where he found it necessary to create multiple distribution DBs to alleviate performance...

Great article David!

I particularly enjoyed reading about Adding a New Distributor to an existing Replication Topology.

I would be interested to know your thoughts on implementing this but for a high...

Apparently so but that is the very same question that I am currently trying to find out in a parallel thread on the Microsoft Forums.

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/e4c83a65-094e-43f8-b3ea-fef02a7db888

How did you apply the trace flag?

The documentation instructs that the SQL Server Service must be restarted. Did you complete this step?

Hi,

Thanks for your reply!

My requirement is not for DR so the lag in synchronization that could result between the Mirror and Subscriber's is not an issue for me.

Did you "need"...

I would be interested to know how you got on with this.

Did you "have" to restart the SQL Server Service or did your enable the trace flag globally using T-SQL?