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

We constantly run into communication problems !

That's about the biggest challenge of being a DBA :w00t:

Take a deep breath.

Now:

- refrase the question and the answer(s).

- try to use the...

BOL contains good info on indexes.

There are some nice articles on indexing at SSC :

- Introduction to Indexes (by Gail Shaw) : http://www.sqlservercentral.com/articles/Indexing/68439/

- Indexing Strategies (by Ramesh Gummadi) : http://www.sqlservercentral.com/articles/Indexing/indexingstrategies/1252/

-...

isnull is a proprietary version of COALESCE, but with just a single replacement value.

From BOL

ISNULL (check_expression ,replacement_value )

Check BOL: http://msdn.microsoft.com/en-us/library/ms184325.aspx

So the where clause will return only rows...