Did you solve this issue?

I am having the same problem and was wondering what your solution was.

Thanks

The article that was posted is a must read... and the Log file and it's size mangement seem to be a classic example of a misunderstanding of SQL's inner workings.

but...

I guess i have a question...

Would a company really upgrade their production SQL server to the upcomming version and then say...

hey! lets just upgrade SQL server but keep it running...

...

It is wider than that. As I mentioned above, if you are a pro,for 64 bits you better develop under 64 bits. That means upgrades to dev workstations and...

it some point the world and Microsoft has to move forward.

are we saying that developers that currently have 32 bit development platforms will never have 64-bit available to them Ever!...

I dont understand..

if a company has the money and need to purchase SQL server 2005/2008 and all the licensing that goes with it.

if the next version of SQL came out...

Chris ad scott,

let me test what you two have posted and i will give you an update.

E is a time stamp for each hour of the day. so there are...

thanks for your iput on that..

i am currently working with:

Select A, B, C, sum(D) as Total, min(E) as MinID

from statsTable

group by A, B, C

as this query retuns exactly what i...

LoL.. this is not home work... well i guess it is since its for work, but i am at home. 🙂

to clarify a little:

we have a table in our DB...

to all,

thanks for all the replies on this issue.

this database actually keeps some statistical data about the application. this table is the data the detailed data for the current week....

Gail,

honestly from what i can tell, from the app programmers, its only used for delete operations.

As the data in other rows could be very similar.

I hate to pass the buck...

Steve,

so what your saying is that the DBCC Checkidentity command only resets what the ID will be of the next column that is inserted ... but does not actually change...

Lowell,

Thanks for the reply,

There are no foreign keys to other tables from this identity column.

But, there are foreign keys to other tables on other columns in this table like User_id,...

thanks for your replies..

i ran the following query:

select min(stats_ID) as min_id, max(stats_id) as max_id, Count(stats_ID) as total from The_maxed_out_table

currently the table is like this..

min ID = 308,673,131

max ID =...

andrewd,

I have tested your suggestion on sample data and it worked perfectly as is.

running the T-SQL on the actual data worked successfully, and I appreciate you for your time...