How many pages does the nonclustered index have?

homebrew01 (1/22/2013)

---

Yes, but that is blank. I would think you need the dropdown populated, or...

bugg (1/22/2013)

---

GilaMonster (1/22/2013)

---

bugg (1/22/2013)

---

GilaMonster (1/22/2013)

---

In general:

Optimise the queries. If that doesn't fix the problem use one of the row versioning-based...

bugg (1/22/2013)

---

Thanks...

bugg (1/22/2013)

---

anthony.green (1/22/2013)

---

Do you have traceflag 1222 enabled?

If so can you post the deadlock graph from the error log

If not run

DBCC TRACEON (1222, -1)

and then post the graphs once a...

In general:

Optimise the queries. If that doesn't fix the problem use one of the row versioning-based isolation levels

In the job step dialog, right above where the command is, is a database dropdown.

No. That DMV measure's SQL's memory usage.

Total server memory is not measured in %, it's measured in KB

Total server memory. It's a SQL counter.

Because it reads every single allocated page in the database and, like all other operations, reads them through the buffer pool. Unless you happen...

Don't use Task Manager to check SQL's memory usage. It can report a completely incorrect figure. Use perfmon.

karthik M (1/22/2013)

---

#1)

Logical Read : 20

#2)

Logical Read:2

which one is better? Less Logical Read. But it uses "Table Scan". Again I think as the table record is very less, it...

You don't create indexes just based on that. The missing index DMV are suggestions, nothing more. Create an index on a test server, run a representative load, see if the...

karthik M (1/21/2013)

---

All,

I found some wierd thing today when i ran the below two

version of queries.

select * from sub_fund

where sub_fund_id in (1,2,3,4,5,6,7,8,9,10)

scan count = 10

select * from sub_fund

where sub_fund_id in...