The article you've linked to points out that a LIKE comparison can be optimised if...

DROP TABLE #Exclusions

CREATE TABLE #Exclusions (ExclusionID INT, ExcludedURL VARCHAR(200))

INSERT INTO #Exclusions (ExclusionID, ExcludedURL)

SELECT 1, '%://llnw-1083.listen.com/6%.rad%' UNION ALL

SELECT 2, '%://fe5357.sidestep.com/servlet6/%' UNION ALL

SELECT 3, '%://cdn-62.blinkx.com/stream/%.flv%' UNION ALL

SELECT 4, '%://genio.virgilio.it/scripts/alice/ifr_virg_comu_genio_cachebust.js_728x90_rmt931648.html%' UNION ALL

SELECT 5,...

Hi Raj Deep

Please could you provide a sample table with a few rows containing data similar to that found in your exclusion table? It should be in a format like...

Eugene Elutin (7/29/2010)

---

Chris Morris-439714 (7/29/2010)

---

Eugene Elutin (7/29/2010)

---

Can you test how long the following query will run and how many records does it returns:

SELECT a.*

FROM dbo.Person a

LEFT JOIN dbo.Person_exclusion b

ON...

LOL!

skcadavre (7/29/2010)

---

I'm feeling generous. . .

This is what you were asked to produce

SET DATEFORMAT dmy

GO

DECLARE @TABLE AS TABLE(

datasource_id VARCHAR(2),

EventType_ID VARCHAR(2),

User_ID VARCHAR(1),

period DATETIME,

Notes VARCHAR(255),...

Eugene Elutin (7/29/2010)

---

Can you test how long the following query will run and how many records does it returns:

SELECT a.*

FROM dbo.Person a

LEFT JOIN dbo.Person_exclusion b

ON a.Name LIKE b.Name_similar

WHERE b.Name_similar...

malavika.ramanathan (7/29/2010)

---

hi all,

i have a query which gives the percentage of time against each user.

I have 6 records in total. I must now select top 3 records from it in...

Try running this statement to see...

No worries Paul I could see you were in deep water there, mate 😀

CREATE TABLE #SampleData (Name VARCHAR(10), Result INT)

INSERT INTO #SampleData (Name, Result)

SELECT 'Joan', 5 UNION ALL

SELECT 'Jhon', 5 UNION ALL

SELECT 'kris', 3 UNION ALL

SELECT 'alice', 2 UNION...

Look up DENSE_RANK() in BOL (Books On-line).

That's just too funny, Ron!

bitbucket-25253 (7/28/2010)

---

Go to

http://technet.microsoft.com/en-us/default.aspx

Input "Upgrading to...

whitlander (7/28/2010)

---

Sorry about that. How's this?

INSERT INTO [PELVIS].[dbo].[Event]

([DataSource_ID]

...

Hi Andy, I'm sorry but I don't have time to convert your post into a set of statements which will populate the sample table.

It should look something like this:

INSERT INTO...