I remember feeling like that at least twice in my life. It's not easy to turn around but it is possible.

The first time I got back to school and...

Stop using that function. THIS IS random > CHECKSUM(NEWID())

You can use this to generate numbers :

CHECKSUM(NEWID()) % <max value goes here>

You might wabt to use ABS() as well because this generates negative numbers as well.

I personally preffer to also include profiler using the event statement completed, also sp_statement completed.

It gives a little more info and you can do multiple runs and do averages. ...

This guy needs help NOW (might be suicidal). I just don't know how to reply to that one...

http://www.sqlservercentral.com/Forums/FindPost1156813.aspx

Please...

FreeHansje (8/9/2011)

---

You are right, I was thinking of an attach-statement, has no truck here.

Anyways, 2 of the 3 offending databases have been succesfully restored, I will try the 3rd tonight,it's...

Remove the filter for >= Today.

You'll need to add a filter for only "uncompleted" trips or something like that (however this is represented in your data). I can't relaly...

Awesome, let us know if you need further clarification after re-reading the articles.

srinath.vanama (8/9/2011)

---

Ninja And Gila,

After shrinking the log i didn't face the problem till date, can u ppl please guide me in my case what to do and what not to...

Please save the execution plan and post it here as per : http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Edit :

Those are nice too to figure out which procs are generating the most problems.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

YOU'RE OUT OF ROOM OF THE DRIVE.

THE END.

Delete data or make sure you overwrite the db when restoring.

That's already what my query is doing, anything between now and the next 3 months.

What dates are you missing in you new requirements?

Good to know!

GilaMonster (8/9/2011)

---

Jeff Moden (8/9/2011)

---

Yowch! 2 WEEKS for the original code? Heh... talk about your basic long running queries. That really does fall in the category of "What...