I'm with everyone else, using NOLOCK is actually quite dangerous, mostly due to the ability to get duplicate or missing rows, which, as far as I know, most businesses absolutely...

It sure sounds like you need to do fundamental query tuning, indexing, statistics maintenance, etc. Assuming you can't get someone in to help you who has experience with all this,...

UPDLOCK is telling the server that you want to take out a lock on the table as if you were getting ready to update it. Then, the HOLDLOCK hint tells...

rodjkidd (3/10/2015)

---

ChrisM@Work (3/10/2015)

---

rodjkidd (3/10/2015)

---

Eirikur Eiriksson (3/10/2015)

---

rodjkidd (3/9/2015)

---

Eirikur Eiriksson (3/9/2015)

---

Grant Fritchey (3/9/2015)

---

Great seeing everyone this week at SQLBits.

And, I got to meet Gianluca and Eirikur for the very first time. Total...

Brandie Tarvin (3/9/2015)

---

Jack Corbett (3/9/2015)

---

FYI - if you want to speak at the PASS Summit you only have one more week to submit. I submitted 3 sessions...

Bouke Bruinsma (3/9/2015)

---

Grant Fritchey (3/9/2015)

---

ChrisM@Work (3/9/2015)

---

The optimiser has difficulty with more than seven or eight tables in the FROM list regardless of how they are joined. More than that and...

Great seeing everyone this week at SQLBits.

And, I got to meet Gianluca and Eirikur for the very first time. Total pleasure gentlemen. By the way, Gianluca is a giant.

It's all about the log backup and the recovery model. You can read about it here[/url].

I don't think it would cause issues, but I'm not clear on what problem it solves.

Grace09 (3/8/2015)

---

Can anyone help me tune this query? Name column is nonclustered index with include column, ID and ParentID

SELECT DISTINCT .[ID], .[ParentID]

FROM [Items]

WHERE LOWER(.[Name]) = 'Test'

execution plan is...

t.mounika01 (3/6/2015)

---

Actually, what i meant was that I just have thereotical knowledge and I have been practicing queries on ssms installed in my laptop. I want to know how...

It sounds like a blocking or resource contention issue. Let's assume that your queries are tuned, but they suddenly start timing out. It's likely that there's one resource of query...

What is the cost of the query as it currently exists?

Setting your threshold to 5 might work, but only if the cost of that query is over 5. If it's...

ChrisM@Work (3/9/2015)

---

The optimiser has difficulty with more than seven or eight tables in the FROM list regardless of how they are joined. More than that and you are very likely...

Most tables in most systems (and by most, 99% plus a few extra digits) should have a clustered index. It doesn't have to be unique as defined, although it's better...