If this is a dev server and the data's not important you can set the DB to simple recovery mode. That way you won't need to do log backups.

Be aware...

dewa_himatif_sf (11/13/2007)

---

IN SIMPLE MODE,

can you help me?

but I've heard that the record from table was delete, isn't not permanent deleted, we can undo "delete proses" if we can read the...

All data changes are written to the transaction log. If the DB...

Jez (11/13/2007)

---

We already have WITH RECOMPILE in the procs and it seemed to make no difference. That's why I made the other changes.

Our processing sometimes involves a few thousand...

I don't have your tables handy, so I can't run that query. Maybe this will suffice. Against a SQL 2005 SP2 server

select name, object_id, type_desc, create_date, create_date

from sys.objects

-- Runs fine....

The order by clause runs after the aliases in the select have been applied. This is most likely undefined behaviour deriving from technically incorrect SQL. Most likely whichever column gets...

As an alternative to local variables, I would suggest that you change the procs back to using parameters and mark each proc WITH RECOMPILE.

With variables you'll get average performance, never...

Is not fair then....

With this, you're going to have to resort to dynamic SQL. Build up the statement as a string, then execute it. (sp_executesql)

The other problem with that is that when the proc compiles, all of the selects compile, based on the values of the parameters for that call. That's even if the...

Shuffle, shuffle, shuffle the pages... I wrote a post about this, after encountering way too many people shrinking databases for no good reason. (http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/%5B/url%5D) I've had an uphill battle with...

Do you mean compatability mode? (80,90,...)?

I doubt it will. All the compat mode does is enable of disable the new features. It does not make the server behave like an...

There's...

Jeff Moden (11/9/2007)

---

Heh... good point. But have had this argument with many other folks... there's very little you will ever need a CLR for if you actually know T-SQL...

You can use profiler to capture the insert statements, and also to check is the app is doing a begin transaction before the insert and when/if it is doing the...