The execution plans for those are substantially the same, with the exception that the "filter" step runs faster in my version (but the index scan runs faster in yours). I...

I got it backwards, you just needed to wait for my edit. Happens to the best of us, which is proven by the fact that it happened to me 🙂

You...

A proper stored proc with an if-else block is the better way - this way each query can be optimized separately, and since pulling the whole table is way different...

mpdillon (7/13/2012)

---

Thanks for the additional information.

Do you think if the file is found by the stored procedure that the SQL user would also have access to the file? I...

OK I'm glad you got it working, but please keep in mind that Windows 7 has file-level permissions as well. When you create a folder and set up some access...

You need to give us some more clear rules. Why is searching for a 2 adult room any different from searching for a 3 adult room? I don't follow the...

Looks like a permissions issue to me. It's not telling you the file doesn't exist, it's saying it can't be read. That either means it doesn't have permission, the file...

Well, I don't know that level of detail unfortunately. What I suspect will happen is they will just deal with what I give them. The camera images are critical (just...

Lynn Pettis (7/12/2012)

---

Many years ago when I was writing COBOL programs to generate ad hoc reports for users I had one user whose requests were less than useful. I...

David Lester (7/12/2012)

---

Lack of a perfect world is the difficulty I am dealing with. Essentially I have certain limits which are not something I can change. (I can and do...

Hehe... it was still fresh in my mind. Sometimes the spammers deserve a response too. When they are wrong...

That is exactly the problem with the certifications - since not everyone is cut out to...

LSAdvantage (8/31/2010)

---

roger.plowman (8/31/2010)

---

I'd think (from a performance standpoint) using LIKE is the *last* thing you'd ever want to do. Especially the "Like %X%" construction, since at best it's going to...

I was interested to know what this actually does in SQL 2008...

So I created this...

drop procedure dbo.USR_TEST_SEARCH

GO

create procedure dbo.USR_TEST_SEARCH

@fname_search varchar(40) = null,

@lname_search varchar(40) = null

as

select FIRST_NAME, LAST_NAME, MASTER_CUSTOMER_ID

from dbo.CUSTOMER

where...

Brannon Weigel (8/31/2010)

---

About a year ago, someone in our company started using this approach to make stored procedures generic enough so multiple places in the application can use the same...