love sql (3/22/2010)

---

Hi Members,

Could you please tell me anyone that what is the difference between querying data from remote server and linked server.

performance wise as well. What are the things...

It should also include the dark mists around it.

There must be some corruption issues out there with lame duck responses from others.

Thanks for posting back.

Alvin Ramard (3/22/2010)

---

CirquedeSQLeil (3/22/2010)

---

Alvin Ramard (3/22/2010)

---

Well, I'm going to try and get myself to finally take one of the MS Exams.

I'm going to see if I can prepare myself for:...

Lynn Pettis (3/22/2010)

---

CirquedeSQLeil (3/22/2010)

---

Going on 15 for me. Feels like about 5 - until I try to remember details of those early years. It's hard to remember facts...

Alvin Ramard (3/22/2010)

---

Well, I'm going to try and get myself to finally take one of the MS Exams.

I'm going to see if I can prepare myself for: 70-433 Microsoft SQL...

Scenario: Backup prod and restore to a "reporting server." Usage on the reporting server...

Luke L (3/22/2010)

---

Gianluca Sartori (3/22/2010)

---

A consulting company here installed a SQL clustered Server with two nodes...

Alvin Ramard (3/22/2010)

---

Lynn Pettis (3/22/2010)

---

GSquared (3/22/2010)

---

My main subjects of conversation so far today have been politics...

Gianluca Sartori (3/22/2010)

---

A consulting company here installed a SQL clustered Server with two nodes and they...

Gianluca Sartori (3/22/2010)

---

A consulting company here installed a SQL clustered Server with two nodes and they...

Nice article.

Your monitoring job would run a script to check the job tables in the msdb database.

(sysjobhistory check the run_status column)

Try the following:

with increment as (

SELECT A.AB_Id, A.Priority, A.Analysis_Code

,row_number() over (order by a.ab_id) as Test_Sequence

FROM dbo.LSR_Prepare A

LEFT OUTER JOIN dbo.LSR_Pass B

ON A.AB_Id = B.AB_Id

AND A.Priority = B.Priority...

Yes you could do that. One method is to create another job that fires off every so often. The job will check the status of each of the...