I searched many combinations. And saw many responses where people claimed that it is coming with SQL Server 2014 express, but i couldn't find anything on MS official site.

Beatrix Kiddo...

thanks all. I was able to get an index seek.

Sorry, I didn't see this answer before my last post. Let me check on this if it works

Lowell (5/12/2015)

---

GilaMonster (5/12/2015)

---

Lowell (5/12/2015)

---

i tried putting together an example, but i keep getting...

Thanks For putting up the example. My table is with 20 million records and I too get table scan with same query. I even tried to use index hint but...

Hi Gail

Thanks for your input. We currently have unencrypted values stored in this table but only authorized users have access to that.

So I can add another column with hashed values...

Thanks Grant. Unfortunately Azure is not an option for us.

Hi jjolk

Can you pls explain how you are managing the workaround from jobs?

jjolk (6/14/2013)

---

Hi Michael,

I do not have a resolution to this error. Instead, I've been working around...

Thanks for the advice Grant!

I don't want to move. NO. I have always loved SQL Server and I still do, absolutely. All I wanted to know if people have done something bigger in SQL...

So after 1 day, I can conclude that they land nowhere 🙂

Hi

I have already tried disk queue length, processor time, disk read and write, peges/sec etc...but didn't try these 2 counters. Hence mentioned 2 🙂

SSIS and SSRS are not there. But I'll check for CLR. Thanks for pointing.

SQLRNNR (6/27/2014)

---

Are you running any CLR?

Are you running SSIS on this box?

Are you running SSRS on this...

Ok, thanks. I'll try these 2 counters of perfmon.

ya, I checked the available memory as well and it was some 190 MB. So it is pretty less given that box has 32GB total RAM. SQL Server is taking...

Ok Gail. Thanks for this recommendation. But is it possible that it shows the total physical memory used also as wrong? Is there a sure shot way to check the...