Just remember that partitioning the table wont make your queries faster.

For an explanation much better than i can provide myself please see this link

https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

Using isnumeric wont really give you an accurate answer.

Please see this article for an explanation

http://www.sqlservercentral.com/articles/IsNumeric/71512/

We found a full EF was way overkill for what we wanted.

We decided to go for a lightweight alternative in PetaPoco.

Before you go down the EF route make sure it...

First thing i would do is try to access the remote computer via a browser

http://remotecomp --if this fails then you have either iis/firewall issues

This will tell you if...

As a guess you may need to turn off the firewall for the required ports on your local machine.

Take a look at inner joins.

Based on what you have written this should get you the information you require.

Thanks Chris,

This looks like it will be a bit easier to use in my actual code.

select * from dbo.SplitStringsByComma('Hello-Madam-how-are-you-Madam','-') split where items= REVERSE(items)

OK so first thing you need to do is change the '-' to a space ' ' and then use your real input...

Do you have the string splitter ?

And you really need to post what you are using and any issues rather than "its not working".

Try posting some full ddl, sample data...

Excellent - looks like this will do the trick.

Thanks for the help.

Try this.

select 'Hello-Madam-how-are-you-Madam' "col1"

into #testString

select Item

from #testString cross apply dbo.DelimitedSplit8k(#testString.col1,'-') split

where item = reverse(item)

It does require DelimitedSplit8k though (easily searched for on the forums)

Really without seeing any form of DDL and the actual view + proc its going to be impossible to say one way or the other.

Attaching a .sqlplan file will be...

Cant you just set the column to a case sensitive collation ?

edit : Column is already set to CS

That will teach me for replying before reading the entire post.

I think this is what you are after.

In SSMS right click on the database server -> properties

There is a memory tab which allows you to modify min/max memory for the...

I will give this a go.

Notice the space between INNER and JOIN and also in the ON clause i changed the...