ever tried changing your cleanup to specify smaller portions?

delete top 1000 from....

and make it run every 10 mins as well.

instead of

delete from table...

Easiest and best way to fix your issue: Buy a Ent License 😉

Personally I would uninstall and reinstall with the Std key.

Let me start of with saying, it's not important, it's critical.

Managing db's, with odd proc's running against them, is not a task I want to spend my full day on.

I...

V1 i2, as you SQL instances are hosted on the virtual servers and not your physical.

Windows or SQL Autentication in the ODBC setup?

p.ramchander (9/22/2009)

---

HI,

i am in a process of creating a job to export data from database to excel sheet using ssis package... but when i am trying to run the job...

http://www.tizag.com/mysqlTutorial/

http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

http://www.mysqltutorial.org/

http://www.devshed.com/c/b/MySQL/

(Please correct me if I am wrong) but I am almost sure those are the only options, I have Server Storage as a option as well, but doubt if it...

hope it helps, i know it is not ideal.

play with it.

mak3 (9/22/2009)

---

can someone help with a STORED PROCEDURE that reads the errorlog file and filter out the following key words:

error, warn, kill, dead, cannot, could, fail, not, stop, terminate, bypass,...

assigning a temp datafile, to each core (given they were created correctly, all the same size) will avoid contention for the main tempdb usage, major increase in performance.

There is...

Silverfox (9/21/2009)

---

Henrico Bekker (9/21/2009)

---

Narendra-587652 (9/21/2009)

---

thank's for prompt response

i have 500 server and differnt version of SQl(2000,2005,2008) and have to

find SQL client or SQL server...

Narendra-587652 (9/21/2009)

---

thank's for prompt response

i have 500 server and differnt version of SQl(2000,2005,2008) and have to

find SQL client or SQL server installed on these...

george.frewin (9/21/2009)

---

Hi All,

I am running SQL Server 2005 and when i run large queries i find that i am losing significant amounts of hard drive space very quickly (about 7gb)...

I must agree with "90% of what?"

but:

Backup Log db_name with Truncate_only --(clear it without deleting it)