GSquared (3/16/2011)

---

What you're describing is essentially a "mutex" (mutual exclusion). If you're going to use one of those, you can skip the whole synonyms thing entirely and use it...

Bob,

You may want to check out using a synonym in your data retrieval queries and have 2 tables for order strategy. I've used it successfully on a couple of...

pwalter83 (3/15/2011)

---

Thanks again. atually there is no stored procedure to be used…I just want to add some functionality in the table that even if the records are added or deleted...

Chris,

Using BETWEEN as a join condition is fairly common. It's really the same as using >= AND <= in either the join or WHERE clause. The efficiency depends...

BeginnerBug,

As Jeff pointed out, with no clustered index you will end up with a lot of white space in the table with forward pointers. This in itself is a...

GSquared (3/9/2011)

---

There are advantages over a delimited list beyond just avoiding having to first concatenate the list together and then shred it back apart again.

First, the table variable has a...

Another good use for a cross join is when you want to create records on a 'for each' basis. A typical example would be a table of inventory locations...

Gianluca Sartori (3/9/2011)

---

Arjun Sivadasan (3/9/2011)

---

tfifield (3/4/2011)

---

Tony,

Please be advised that while this type of scalar UDF (accessing a table based on parameters) has its place in some applications, it can lead...

Sean and Gus,

Thanks so much for the example and proof of concept. I've been trying to figure out when I would actually use an input table variable that would...

jojupi01,

You can't use a variable in an IN () construct. It's one of those things we've all wished for. You will have to do the whole query in...

Holly,

I would go to the console on one of the non-problem servers and log on under the same service account that starts SQL Server. Then go into windows explorer/network...

premkuttan,

You have no way of knowing exactly what the problem is unless you have something to compare it to. How long does it take to copy some 10 MB...

Michael,

If your product table isn't very large I would use GSquared's solution #1. (Insert into a temp table for the actual product code and check @@rowcount). It's very simple...

KermitTheRock (3/3/2011)

---

Todd,

This is why FTS is hard. splitting some text by whitespace, building a list of "words" and pointers back to the text isn't difficult.

Knowing when and how to group...

Tony,

Please be advised that while this type of scalar UDF (accessing a table based on parameters) has its place in some applications, it can lead to very bad performance that...