Are you using the EXACT same data type in your query as the column has?

Please post the table definition (including all indexes) and the code you are using...

Look in BOL for @@OPTIONS to see a list of the different values.

sys.dm_exec_plan_attributes ( plan_handle ) has user options object was compiled with.

sys.dm_exec_requests has a number of bits...

Matt Crowley (5/21/2014)

---

It is true, that using Profiler may extend the duration of the test, as it will take up some resources, but in this case, I think that is...

1) You have no filter in the views. Are you using one in the query? If so, what is your code?

2) What is the plan that is chosen...

ssinger-815504 (5/20/2014)

---

TheSQLGuru (5/20/2014)

---

1) Did the test finish more quickly with CPUs pegged? That could be an indication that things are running 6X faster. Not likely, but not unheard...

ssinger-815504 (5/20/2014)

---

We run a Java application on SQL Server. We are load testing on this machine:

HP DL380 G8 duel E5-2650 CPU

16 CPU Hyperthreaded to 32 cores

32GB Memory

Dedicated san...

Grant Fritchey (5/20/2014)

---

Chances are you didn't run the restore with the syntax KEEP_CDC. In this event, even though, as Kevin says, the backup includes the CDC tables and data, they're...

What information are you using to state that CDC is disabling?

Markus (5/19/2014)

---

TheSQLGuru (5/19/2014)

---

Kinda what I figured. It does sound like you either have too many servers or more hopefully you are expecting to grow into the ones you have...

mario17 (5/19/2014)

---

Hi,

what would be the most economy solution for this WHERE, I see the code where we have covnert to 101 type on both sides of equation, which I tnink...

bhavik.bk (5/19/2014)

---

Hi

i did not find a satisfactory answer to my question over how can any function be non-deterministic? What I don't understand is how can a function like GETDATE()...

Taking another opportunity to steer the user (and every SQL Server...

CDC is an advanced and complex subsystem within SQL Server. You need to do a lot of reading and study to be able to configure, monitor, and use it...

Kinda what I figured. It does sound like you either have too many servers or more hopefully you are expecting to grow into the ones you have (that are...

Markus (5/19/2014)

---

For the bulk of systems there aren't any additional features in 2012 or 2014 that will make a system run better for us. The biggest feature of SQL2008R2...