Hi Ananda,

I can not find this explicitly stated in MSSQL 2000 documentation

but if there are data drivers on the server I see no reason why it would not work.

Another...

Nice one thanks

Iulian

Nice question, thanks also Oleg for the remark and link to Triangular Joins.

Regards,

Iulian

I am thinking about getting the data for 3 months into a different table every night, or something, and then to query this table. Something like this:

After you create the...

Nice question, thanks also Oleg's script looks great. Here is something that has the same result:

DECLARE @dtFrom DATETIME

DECLARE @dtTo DATETIME

SET @dtFrom = '2010-01-01T00:00:00.000'

SET @dtTo = '2010-12-31T00:00:00.000'

DECLARE @Diff INT

SET @Diff...

Great question, unfortunately I have not seen the comments with SET ANSI_PADDING ON/OFF. This is how I discovered I don't pay enough attention to comments 🙂

Regards,

Iulian

That is really great, thanks a lot Jeff for leading me here.

Cheers,

Iulian

Thanks a lot Stewart, that's a great idea.

Cheers,

Iulian

Thank you Leo,

I was looking at table properties, but I will try also sp_spaceused in the future.

Regards,

Iulian

Hi Jeff, it was about 50MB - not sure exactly.

Now the size is 0.28MB - which is great.

I dropped one unclustered index and left only the primary key...

Thanks Craig you already helped me.

I will check tomorrow the options you mentioned: LOB fields - as far as I remember there is none - but holly double check :-),...

Hi,

How are you upgrading the databases?

See this for understanding the FileStream:

http://blogs.msdn.com/b/manisblog/archive/2007/10/21/filestream-data-type-sql-server-2008.aspx

Regards,

Iulian

I am sorry Chris I don't have the table structure at hand.

Thanks,

Iulian

I have a few columns: nvarchar(255) and a few with varchar(50) could this be the cause?

50MB is not such a bog size I just can not explain how 1000...

Good point, thanks

Iulian