Tom.Thomson (8/22/2010)

---

Ninja's_RGR'us (8/22/2010)

---

My first instinct was to build a vpn tunnel between the servers but then I remembered that we can only have 1 vpn connection on 1 machine at...

Thanks Gail, now 1 follow up question : Since I can't seem to find the option to get the details per table for reads in profiler (please point...

GilaMonster (8/22/2010)

---

In addition...

So if you can't trust the plans, can you trusts the ms, reads, writes, cpu... from the profiler 'cause that's pretty much the data I ended up trusting after a...

Nils Gustav Stråbø (8/22/2010)

---

Ninja's_RGR'us (8/22/2010)

---

Thanks for the link, but just a few quick questions before I spend 2 days reading all those articles :w00t:.

1 - How fast is the response...

I see your point. My own pers. favorite has always been to use table aliases and using it on the columns, even with only 1 table in the query....

Nils Gustav Stråbø (8/22/2010)

---

Just a thought, but for the clients that are using SQL Server (2005 or higher) you could perhaps use Service Broker?

...

http://rusanu.com/articles/ has a lot of very good...

I'll keep service broker in mind.

However we do have sql 7, 2000 in place so I'd prefer to develop a 1 size fits all system as much as possible due...

That kills al usefull...

The difference will be in the connection setting which is most likely affecting the dateformat or the first day of the week.

Check dateformat and first day of week in both...

I'm already looking hard into it.

Making a link server to and ip adress over internet is not the issue. I want to make sure I have the max security...

So did you pass your interview yet?

abhitkumar (8/21/2010)

---

Hello All Experts,

I have made one matrix report, in which i have taken one column group named as "Branch".

It will display dynamically all the branches. Now in that column...

Cool, it would be awesome if you could post your findings and articles here. I'm sure it'd help a few people along the way.

Yes for the new thread and how many accounts of what???