There are something interesting. Before we never seen parallel queries. We have an IIS box querying a separate SQL box. Over the weekend our dev guys added...

I just read some posts here and pretty sure that this is a result of parallelism. The server has 2 dual core AMD Opteron 2.0GHz processors. Never...

Thanks guys. The database is not for mirror, not replicated. There is no open transaction. I went over each possible cause shown in Gail's article but I...

Here are the numbers from another performance log:

Avg. Disk Queue Length: 7.47

Current Disk Queue Length: 6.96

Avg. Disk sec/Read: 0.02

Avg. Disk sec/Write: 0.00

Disk Read Bytes/sec:11,800,433.25

Disk Write Bytes/sec: 7,661.90

Thought?

Thanks.

Thanks Champ. It works like a charm.

thank guys for the input.

I so far hit level 1 tech support. They just said that the version was tested only with 32-bit when released so they...

Steve Jones - SSC Editor (1/8/2011)

---

I found this: http://www.sqlnewsgroups.net/sqlserver/t18795-32bit-sql-64bit-windows.aspx

If Linchi has done it, you should be OK.

Your plan should work, but I don't know that many people that have done...

VM is not supported by the vendor. The app...

I just talked to a reseller and she confirmed I can install on either 32 or 64 bit hw.

Thx.

already done that, still waiting for email from MS. I thought someone here had been through this.

Thx.

tikkani.praveen (8/14/2009)

---

Can u tell me what does this logical_name and 650 refers to, and how can i do it in my context.

My database name is FINCON_RETAIL_LIABILITIES_MIS.

Please expalin me a bit...

This is NOT always true. Couple of my SQL...

Okay, here is a scenario for you.

At 12:10 PM Wednesday afternoon your server crashes and corrrupts your database forcing a restore. You attempt to restore from the full backup you...

Until you get to SQL Server 2008 where the truncate option no longer works. Besides, why truncate the log right after you have backed it up? Doesn't do...

Lynn Pettis (8/13/2009)

---

htt (8/13/2009)

---

here is what I have done for years to my SQL 2000 and SQL 2005 databases: full bk nightly; log bk every 15 minutes from 5 am...