The purpose of this query is to generate feed for other method in front end. For some reason it always asks for, say, Jan-Dec data as data input in that...

This can of course easily handled by using multiple queries in sp, but I have to embed the sql command in front end code, that is, I can't store it...

But I have to put the group by there. That's the key. I am just using the Northwind as an example.

I also have to...

Sorry, it works. It didn't work probablly because the record was just revised and the index was not updated.

I have solved this problem by using adding an additional field to temp table, then increment the record that matches the term in another table, then select the record that...

Then in this particular case, what would you recommend to do to make it faster when trying to dig something from the database? I thought adding index would benefit that.

Hi bnordberg,

I didn't index date.

This is the original table schema:

CREATE TABLE [dbo].[IISlog] (

[date] [datetime] NULL ,

[time] [datetime] NULL ,

[c-ip] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[cs-username] [varchar]...

Hi bnordberg,

I didn't index date.

This is the original table schema:

CREATE TABLE [dbo].[IISlog] (

[date] [datetime] NULL ,

[time] [datetime] NULL ,

[c-ip] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[cs-username] [varchar]...

OK, I got the query result:

select max(len([cs-uri-query])) as [max-cs-uri-query], max(len([cs(User-Agent)])) as [max-cs-User-Agent], max(len([cs(Referer)])) as [max-cs-Referer] from iislog

took almost 28 minutes to finish on server this time.

What does this...

FYI, here is some data from the table:

select top 10 * from iislog

date ...

I have a local copy of the original data files, so it't not a problem to use your suggestion (SELECT/INTO) to create a new well-designed schema on the server.

Hi Jeff, and other gurus,

Thank you so much for the analysis. I apologize I reply late because of the holiday reason. (Happy Easterday! )

Yes...

Hi Jeff,

I totally agree with you that the table is not well designed at all. I am just trying to fix problem instead finding who designed the database.

But my question...

By executing the following query, it took me 8 minutes (query from indexed 63 million rows). Is it OK or not good? The hardware is: Intel Xeon 2.4G with 1G...

AFter two hours, it's done and returned:

Warning: The table 'IISLog' has been created but its maximum row size (13625) exceeds the maximum number of bytes per row (8060). INSERT or...