That is a lot of rows.. I would definitely look at the indexed view to persist the values otherwise it has to recalculate the values everytime you query them...

Its pretty limited and no pretty.. But it works for http/https/ftp:

SELECT URLCnt = COUNT(URL),

Domain = CASE SUBSTRING( URL, 1, 5 )

...

If you look right next to the SQL server name in the object explorer it shows you the version.. You can say that 9.* is SQL 2005, 10.0.* is SQL...

Agreed Steve..

The row is obviously violating one of the assumptions I made..

My guess is https instead of http..

CEWII

I am fundamentally opposed to going to the registry unless it is ABSOLUTELY necessary.. And in this case it isn't..

SELECT InstanceName = SERVERPROPERTY('InstanceName')

It will return NULL for a default...

That wasn't a full select statement, it was only enough to demonstrate the syntax.. Add:

FROM #URLTbl

It should work..

CEWII

Its called a CROSSTAB and I believe SQL 2008 has a function for it.. Do a Books Online Search and you should get syntax..

CEWII

Very quick way to get the full domain out is:

SELECT Domain = SUBSTRING( URL, 8, CHARINDEX( '/', URL, 8 ) - 8 )

I'm still working on taking something like view.atdmt.com...

I would say yes, but the code to crack the root domain out is going to be slow. And since you are using 7 or 2000 you can't use...

I would say not much changed for me.. 2-3m new records even on a fairly small machine doesn't really scare me..

SQL, probably 2 x 4 cores and 16-32GB of...

Breaking it into smaller chunks probably won't help performance, readability yes..

you mentioned a sort operation without order by, I'm wondering if there is any joins on this table? I'm...

No problem..

CEWII

Excellent..

CEWII

Also a very good idea Gila..

CEWII

If I had my choices I'd use at least three machines, IIS, SSRS, SQL.

SQL should be big in terms of memory 32GB+, maybe 64GB+. I'd probably go at least...