Edd-927544 (9/22/2009)

---

Question.

I have a SQL 2000 database with no need for anything but the simple recovery mode.

I have an ldf file that is 6 times the size of my database...

also add the db autogrowth event to your trace, that will help you determine your point of interest !

Also take into account how your applications connect and use the sproc !

What's their used Isolation Level ? ( should be "read committed" in 99.9% of the cases)

If you had searched SSC for "import errorlog"

you would have come to a lovely script "Deadlock Notifications in SQL Server 2005"

by Patrick LeBlanc ( 2007/10/10 ) which could get you...

Which parameters did you specify in your BOOT.INI file ?

BOL topic "Process Address Space" states :

If there is more than 16 GB of physical memory available on a computer, the...

I noticed if you add builtin\administrators, it gets individual auth in every database, so not...

IMO the question tended to "would it hurt to always activate AWE" .... That answer is "Yes".

Don't enable it, if it is not needed.

- You shouldn't have switched them to simple recovery, before you have the answer to your question.

If you hadn't switched it to simple recovery, you might have been able to...

Yes it is !

But if you need to address more than 8GB RAM on a 32-bit system, it is the only option.

from books online (BOL) SQL2008

SQL Server supports Address Windowing...

You could enable C2 auditing and process the trace file to persist the data you want to.

(have a look at BOL for its content)

Maybe even my little article "SQL...

raym85 (9/20/2009)

---

Would putting the queries in a Sproc be faster? I thought both functions and sprocs parsed and pre-compiled the data. Meaning that performance would be better? Well maybe not...

or use the ever lasting exists with a correlated subquery.

SELECT Q.*

FROM qtral Q

WHERE exists (SELECT 1

FROM qtral Qx

where Qx.tral_no = Q.tral_no

and Qx.tral_pd = Q.tral_pd

group by Qx.tral_no, Qx.tral_pd

having...

The big problem with functions that perform queries, is that they cause hidden joins, hence should be transformed to (well tunable) regular joins !

Functions aren't always visible at first sight...

have a look at Allens article : http://www.simple-talk.com/sql/backup-and-recovery/alert-based-transaction-log-backups---automate-your-database-maintenance-part-2/

afaik size doesn't matter, unless you have a sqlexpress instance.

There has been a limit regarding the number of files when using sp_attachdb.

Best is to use "create database .... for...