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???

Yup, the good old addage that you can achieve 80% of the results by doing 20% of the work. That holds extremely true in sql server tuning.

I've even found...

I got a big challenge for you guys.

How to link to 3500 servers (all outside your network and company) over the internet, dynamically, safely and in real time.

http://www.sqlservercentral.com/Forums/Topic973049-1526-1.aspx

check out ROW_NUMBER() using the partition by clause in books online.

Keep in mind that the new column is only available in the where clause after going to a derived table...