Roy Ernest (10/28/2009)

---

I got into an accident yesterday. A four car pile up. Thankfully no one got hurt bad. My whole body is sore. Hit my chest badly on the...

Matt Whitfield has written a .NET test harness that maybe could be helpful in choosing the fastest solution.

You could call him in the thread and ask for some info.

If you want a more in-depth reference on the subject, you could also read Erland Somarskog's blog:

http://www.sommarskog.se/dyn-search-2005.html

I suggest you to read this article on how to post performace problems

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

With a quick look I see a couple of potential problems:

1) NOLOCK is bad, it could return...

@Table in your script is a varchar variable, not a table.

To do what you're after, you would have to create a sql string in code and then execute it with...

It's not possible unfortunately.

There's no such suffix to append to consider constants in a particular datatype (looks a lot like java...).

Moreover, a stored procedure ALWAYS returns type int, so that...

I have seen how fast is this technique for the first time during the "Phil Factor SQL Speed Phreak Competition: No 1".

It was Peso that came up with the...

I don't know how you intend to display more than two transfers, but this is just a guess on your data:

DECLARE @Transfers TABLE (

...

I suggest you take a look at this article and post data in a more readable manner:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Glad to hear everything...

If it's true that hierarchical model is somehow nearer to OO design, this doesn't mean we would have better design. I often see bad design in Object Oriented languages. Probably...

Can't you reboot the server and get into the RAID utility?

That would be the first place to look into.

Otherwise, I think you will have to guess.

I don't think this is the point, Bob.

What I don't find appropriate is storing non-relational data in a relational database and expecting this to behave and perform as if it...

This looks the most sensible answer, but my favourite one is "ask...

Which article?