free_mascot (1/31/2011)

---

When you are transfering large data to new table; I suggest you create just basic structure of the table i.e. without indexes, rules etc.

Once transfer is done you...

I would create a role to assign the users to and then assign that role to ddladmin, data_reader, data_writer, and security_admin for the database. That last role is probably the...

The hint when applied to a query will take precedence.

Wow... That's a rather large query. A couple of notes. You have NOLOCK all over the place. Yes, that prevents locking, but it can lead to bad data being returned...

You don't want to try to "beat the Operators." You want to try to work with the...

Those have been available since the Visual Studio 2005 Team Edition. Decent tools. Really. Not...

Glad I could help.

Yeah, 2008 you no longer have a choice on the JOIN syntax. Might as well jump.

Also, keep an eye out for opportunities to use UNION ALL instead...

GilaMonster (1/28/2011)

---

I disagree. Only...

This needs a ton of work to make it generic, parameterized, but if you guys want the raw form, this powershell script will automatically generate scripts for all databases on...

As to why the costs might not accurately reflect performance, that's because query plan costs do not accurately reflect performance. They are estimates of cpu and io cost, completely dependent...

To my knowledge, that's a server level permission setting. We got around it by allowing developers the ability start a SQL Agent job that then started the trace.

There's always PowerShell and ADO. Pretty easy that way.

Wayne Coles (1/27/2011)

---

Hi

Thanks for replying,sorry for delay in my response, other things...u know

below is a sample of my code

select a1.id, a1.CoName,a1.Tel, a2.agent, a2.ondate,a2.result, a3.agent,a3.ondate,a3.nextaction

from details a1, history, a2, pending...

Check for contention, blocking, that would make prod run longer than dev. How about the physical machines themselves? I ran into situation once where I spent at least a day...

Pink123 (1/27/2011)

---

Thanks for your reply.

I am a begineer .

I tried to check the actual execution plan.

There is an index seek on Table A which having cost as 37%.There are other...