ALL CAPS!

No problem.

You have no less than 12 objects scans. You also have functions that possibly also do table scans.

There's no 2 minute solution I can give you...

All capitals letters = shouting. Please stop it.

Thanks in advance.

Yes but now we have to make it work when there's no slash!!!

As always... string manipulation gets complicated real fast!

BEGIN TRAN

DECLARE @Table TABLE (ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, URL...

We need the .sqlplan file. We can't do anything with that jpeg.

P.S. posting in all caps...

Laurence Neville (11/11/2011)

---

Hi Grant,

One question about the book:

You refer a couple of times to indexed views that "only refresh once per day". My understanding was that indexed views are updated...

Too late now but I was going with Jeff's splitter.

Now that I think of it just using left (patindex) makes more sense to find the end character.

You can't use .com...

I had the solution, I wanted to know if it was a known bug before wasting...

I've shrunk down the db so tha I can move it around more easily and use it on express.

The bug seems gone in express R2 and Denali CTP3.

So I'll call...

Ninja's_RGR'us (11/11/2011)

---

Brandie Tarvin (11/11/2011)

---

If you can resolve the problem by moving your WHERE clause, though, is it really that big of a deal?

I personally think you should upgrade to SP4,...

Ok, I'm just playing with ya'll.

id10t error.

The SSMS is installed in english but part ofthe install is done in french.

I don't even want to know how they managed that.

Trying again...

I know, hence TEST server :-D.

Nothing corrupt,...

Cancel that... seems like the upgrade failed.

Who said there was no risk? :hehe:

Brandie Tarvin (11/11/2011)

---

If you can resolve the problem by moving your WHERE clause, though, is it really that big of a deal?

I personally think you should upgrade to SP4, BTW....

The query's the easy part. How did you test the concurrency part?