If its acceptable for your reports to contain "dirty reads" changing the transaction isolation level for the connection is an option. This will prevent locking of the data, I...

rajeshn29.dba (12/12/2013)

---

Hi Team,

1.How to apply service pack active - active cluster node. 2005 & 2008

I have 2 active – active nodes like (A,B) both having 2 instances

On ‘A’ node...

No one post on a forum will be able to answer this question.

If you have no experience in these areas I would suggest starting with buying the MCTS SQL 2008...

Adrian_1 (12/10/2013)

---

Hi all

I have read so many threads on this but still seek a definitive answer...

I am trying to pass a parameter in using /SET "\"\package.Variables[Parm1].Value\"";xyz

I can use a package...

It's certainly possible, only thing to watch out for is SSIS when running the two versions if you plan on installing it.

This thread may be of some use for tips on optimizing the distribution db.

http://www.sqlservercentral.com/Forums/Topic892451-60-1.aspx

Hadrian (11/29/2013)

---

Hi Guys,

I have a job which run from Data collector and failed with this error message Name of the job is collection_set_3_upload .

Component name: DFT - Upload...

WHERE b.PropertyCode='PCH'

AND b.CreatedON BETWEEN '2013-11-29' AND '2013-11-30'

This will give you the time range '2013-11-29 00:00:00.000' till '2013-11-29-29 23:59:59.999' encompasing the whole day.

Another option is

WHERE b.PropertyCode='PCH'

AND CAST(b.CreatedON...

What are you thinking is an issue?

Is it the distribution DB is too big?, with the latency and undistributed commands details you have provided it appears your replication is running...

My experience has been that no monitoring tool has offered the bespoke solution we have needed for each and every scenario.

Every issue you listed is easily captured without the need...

Here is the msdn article:

http://technet.microsoft.com/en-us/library/hh710053.aspx

den_sidr (11/28/2013)

---

Hello,

quick question.

For example my AG consists of two instances that are set up with synchronous data movement. Also the readable secondary option is set to NO for both...

Most likely yes, for log shipping you will have at least one folder where the transaction log backups persist. And the SQL Accounts used by the log shipped...

First of all good luck in obtaining all those certifications as its a lot of work especially if you dont already work in that field.

What I would say is that...

Clustering the VM's is not hugely different to clustering physical servers.

The issue you may have is that if both VM's are hosted on the same underlying physical hardware and the...