I'm in favor for the options Leo.Miller provided :w00t:

as already stated: it depends.

If that column is used in where clauses, as a join argument, or order_by\group_by, it may be good to create an index for that column.

Should it...

Horrible screenshot to read :ermm:

Does your instance have an E-drive ?

Does that E-drive contain a path called "program files\microsoft sql server\Data" ?

Does your sqlserver service account have the needed auth...

jcrawf02 (8/6/2010)

---

Chris Morris-439714 (8/6/2010)

---

Brandie Tarvin (8/6/2010)

---

In a total change of topic.

Out of the blue this a.m., I suddenly wanted Circus Peanuts. So, what is the one candy that you want...

I'm verry sorry for that :unsure:

but I...

Why don't you run the sproc locally ?

(have it push the data to your linked server using insert into linkedserver.linkeddb.linkedschema.linkedtable)

In general I'm not fond of using linked servers for...

here's a nice article at SSC http://www.sqlservercentral.com/articles/SQL+Server/70505/

It also mentions these great links on tempdb:

- Working with tempdb: http://technet.microsoft.com/en-us/library/cc966545.aspx

- troubleshooting performance: http://msdn.microsoft.com/en-us/library/cc966540.aspx#EEAA

These links provide good insight on why it is uses...

- Are you capturing deadlock info in your sqlserver errorlog ? (startup trace flag -T1222 )

- indeed your sproc cold have been written in a far more optimal way :hehe:...

Brandie Tarvin (8/6/2010)

---

One thing I'm suddenly confused about. 1) Why is a performance issue question in the Security forum?

Back to the point, Doesn't the data being in different places,...

Brandie Tarvin (8/6/2010)

---

GilaMonster (8/6/2010)

---

Not permitted (except row...

As a rule of thumb I have the magical number "7" 😀

Meaning, if you need more than 7 indexes, you'll have to expect troubles and take things more in your...

Gianluca Sartori (8/6/2010)

---

Access is often a trojan...

Best of luck with the new challenge !

seandeyoung-1145978 (8/5/2010)

---

Frequent criticism of the DBA staff is that they can be difficult to deal with. Sometimes viewed as a prima donna, DBAs can be curmudgeons who have vast technical...

seandeyoung-1145978 (8/5/2010)

---

I provided the script 3 times. I told them strictly/directly as I stated verbally the issue was with that field being of the value 0. There is no confusion....