Chirag (3/27/2009)

---

If your clustered indexes are on identity columns then you have some control over the order of the data. If the indexes are on other columns then it would...

Hmm, that's a thought

I have full control over how the data comes in (I designed the SSIS package to do it)

Unfortunately there's no real order, as such. Our Id fields...

Thanks Grant

So the order in which I'd reorg indexes would not be important then, I expect?

The tables are reasonably small (generally under 20000 rows), so I'm going to monitor for...

Lynn Pettis (3/26/2009)

---

I'm actually thinking that the company doesn't have a dedicated DBA for the SQL Server systems and that the Developers are also doing the DBA work. That...

Do these tables have clustered indexes?

Something like this could work, assuming "TOP -1" means you want the second from the top!

SELECT ...

FROM

(SELECT TOP 2 ... , ROW_NUMBER() OVER (ORDER BY statut DESC) as rownum)

WHERE rownum...

Well, the beer festival was much fun (although my head would disagree this morning). I partook in Ale Caesar, Mad March Bear, Black Dog, Dark Brains among others, but missed...

hehe, current favourite beer name from the links kindly posted: Yellow Snow IPA

All this talk is making me very thirsty!

I think the mere mention...

Thanks for the tip.

I'm only a very recent...

Leeds-based, so I'm off here this evening: Leeds beer festival[/url] 😀

And when...

Is that Sainsbury's, UK?

If so...

as I understand it:

First, the query will be parsed.

Then, it is sent to the Query Optimiser, which generates the execution plan.

The plan is then used to return the data...

I'd use something like this in your UDF:

declare @val varchar(50)

declare @p varchar(10) -- phone number

declare @e varchar(10) -- extension

set @val = '(950) 993-1151....9999'

WHILE PATINDEX('%[^0-9]%',...

Is the phone number (without the extension) always the same number of figures, ignoring brackets, full stops, etc?

It looks like it from the sample data you hae provided.

If so I...