First, NOT IN usually doesn't perform as well as an OUTER JOIN, so I'd change that right away. Second, you can check to see that values are a number by...

Only because he wanted to return the values and lock them down from other users. So I did the SELECT with the update lock first, then udpate the table to...

Also, on the SELECT...INTO vs. CREATE TABLE & SELECT question. That one depends too. It depends on whether or not you are going to create indexes or in any other...

Now you're being mean.

😎

Matt Miller (3/5/2008)

---

Jack Corbett (3/5/2008)

---

Matt Miller (3/5/2008)

---

I used to throw something like that into my Email signature.

It looked something like:

After I had been using it for...

Or in this case, six months experience repeated 16 times.

Sorry, I'm frustrated. I've got stacks & stacks of interview sheets with little x's next to questions that people with more...

If it's one more, then you've got extra stuff in there. Try using DATALENGTH in the query instead & see how that works.

Jeff Moden (3/5/2008)

---

Grant Fritchey (3/5/2008)

---

FWIW, I put two people through phone screens yesterday. Both had more than 8 years experience in SQL Server. Both were listed as senior level consultants....

Yeah, I was thinking about posting the same thing. Accurate statistics are way too important for getting good execution plans.

Hmmm, maybe non-printing characters.

See if this returns different values than the LEN statement.

SELECT DATALENGTH('testfolder/test.aspx')

That might be the issue.

Matt Miller (3/5/2008)

---

Grant Fritchey (3/5/2008)

---

If the emailaddress is the primary means of accessing this table, then yeah, I'd make it the clustered index. If you have it as a unique...

Nope. Can't do it.

There are a lot of third party tools for this, free, cheap & expensive. Personally, I use Red Gate SQL Prompt & SQL Refactor. Between the two,...

If the emailaddress is the primary means of accessing this table, then yeah, I'd make it the clustered index. If you have it as a unique non-clustered index, you'll have...

FWIW, I put two people through phone screens yesterday. Both had more than 8 years experience in SQL Server. Both were listed as senior level consultants. Neither could describe the...

select right('testfolder/test.aspx',len('testfolder/test.aspx') - charindex('/','testfolder/test.aspx'))