Terri (11/7/2008)

---

Wouldn't using views or stored procedures solve the problem of the jr HR person. In our shop we never give access to base tables. Either we a...

ramadesai108 (11/7/2008)

---

My question is: if t.SoldYR2 is greater than t.SoldYR1 (which

means t.SoldYR2 has to be at least greater than zero). If it is greater than zero, then it cannot be...

So is Backup log with truncate only and both have been completely removed in SQL 2008.

Null won't cause a divide by zero. Anything divided by null (or added to null or multiplied by null, ...) is null....

Karl Klingler (11/7/2008)

---

Hi,

just so i know - do you guys think it possible that an open transaction getting rolled back on the table might be a reason for this kind...

Build 1399 is RTM, meaning it's never been patched at all. The latest will be SP2 CU 10. Get SP2 and apply it to the machine where the client tools...

Depends. Was record a deleted before Diff2 was taken, or afterwards?

Logins can be created on the mirror, because logins go into the master database. Make sure that you script the login from the principal with the SID. That will ensure...

Does the path F:\MSSQL.1\MSSQL\LOG\ exist?

If so, what files are in there?

Are there any other errror relating to tempDB or Model in the error log?

Can you ask the users what exactly they mean by 'locking'?

3605 isn't required for deadlock graphs. Personally I find 1204 to be unnecessary if 1222 is...

Did you do anything to the tempdb files? Did you copy then anywhere, rename anything or anything like that. Basically, what did you do to the server between the time...

You're dividing by t.SoldYR1 in the code that works and t.SoldYR2 in the code that doesn't. Are there any rows where t.SoldYR2 is 0?

These two should give you a good place to start. You may have to tweak an existing script if you can't find one that does exactly what you want.

http://www.sqlservercentral.com/scripts/Index+Management/63649/

http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/

clive (11/6/2008)

---

2.

If you truncate a log file which is usually around 2GB, but is now 7GB due to bulk inserts, truncating it is recommended (unless you have plenty disk space...

TRACEY (11/6/2008)

---

Thanks gila - i do some monitoring. I turned in on now and keep eye on the query being executed to ensure they are using the indexes and...