Jeff Moden (3/25/2012)

---

P.S. I also think that there's a whole lot more "community" support for SQL Server than there is for Oracle. Again, it's just my opinion but...

GilaMonster (3/23/2012)

---

Doesn't show...

Jeff Moden (3/24/2012)

---

Lynn, despite the title, I don't believe that the database is in the "read only" mode because of what the OP asked. I believe the "read only"...

First, It isn't crappy software.

When you attempted to stop the job, exactly how did you do this? Please provide the exact steps or T-SQL code you used.

Second, although I...

First, can you explain a little more regarding this read only database? Is it a snapshot of a mirror, a log shipped database in standby?

Here is what I see from looking at the execution plans. I would appreciate others thoughts in this regard as well.

First, if you look at both plans they are...

Head to desk. I just saw the problem.

Your code:

SELECT FirstName, LastName, FullName

FROM TestNames

WHERE FirstName + ' ' + LastName LIKE 'Bob Sm%'

What you needed:

SELECT FirstName, LastName, FullName

FROM TestNames

WHERE...

Here is why I ask. I worked with a developer you asked why in a test environment his procedure wasn't using the index we had just elevated. Doing...

er.sivaganesh (3/24/2012)

---

lynn you need the script of all the table to get the solution

the only thing is if search a sentence it...

er.sivaganesh (3/24/2012)

---

lynn you need the script of all the table to get the solution

the only thing is if search a sentence it...

Didn't ask you what you were expecting, I asked how many rows of data in the table you are testing against.

er.sivaganesh (3/24/2012)

---

i dont say like that lynn why u feel like that

i just stated the information plz tell me if any new idea ...

Because your words indicate that you really don't want to learn new...

How many rows in the test table on your server?

You know, if you don't want our help improving your code and your skills working with SQL Server, just let us know and we will go away.

All we are trying...