If you can indeed not make it, then please...

himanshu.sinha (4/12/2016)

---

I am into a situation where I am seeing of lot of deadlock / blocking . I have inherited a SP in which the whole code is within BEGIN...

Jason Tontz (4/12/2016)

---

-- First Query - Inline View/Join

SELECT COUNT(1) FROM TestTable100 Hun

WHERE Hun.ID IN (

SELECT Nine.ID

FROM TestTable99 Nine

WHERE Nine.ID = Hun.ID)

-- Second Query - Standard Join Syntax

SELECT COUNT(1)

FROM TestTable99 Nine...

GSquared (4/12/2016)

---

I just found another query by the same person, where it divides a Numeric column by 100, then casts it as Varchar, then LTrims and RTrims the result, in...

I originally had...

The best way is not to do this at all. Relational databases are designed to work...

reinhardcilliers (4/13/2016)

---

2. Should I only do a small subset of say 100 indexes a night and let my job run once a day for 10 days in case it causes...

Sure!

One of the things about CTEs is that they make it easy to disect a query. You can highlight just the text...

Yes, I know. Perhaps I phrased it in a confusing way. What I wanted to say is that (a) there are cases when...

I'll be there. Presenting on Friday, and attending sessions on both Friday and Saturday. (I won't there for the precon days, as I am presenting in Copenhagen in the first...

You are not rambling at all and your problem is in fact intrigueing. Unfortunately I had a long day and I cannot get my brains to clear out the fog,...

I can, but it will probnably involve...

Peter Shilovich (4/12/2016)

---

This is the query:

--Set Statistics Profile Off

Select

Coalesce ((Select Value From Test Where ID = (Select ABS(CheckSUM(NEWID()) / 100000000))), -1)

--Set Statistics Profile Off

And use the actual plan or statistic...

wrightyrx7 (4/12/2016)

---

John Mitchell-245523 (4/12/2016)

---

No, a primary key is a property of the table, not of a particular query that you...

Sean Lange (4/11/2016)

---

Forget about optimization for a second. Think about normalization. What are you going to do when a user name changes? Somebody changes their name and suddenly you have...