antonio.estima 4150 (9/25/2012)

---

Hello,

We have a problem in the query within the attached file. When I run in sql server 2000 it returns the result without errors,...

GilaMonster (9/24/2012)

---

laurie-789651 (9/24/2012)

---

2. You could consider using

FROM Table1 SD WITH (NOLOCK) JOIN Table2 WITH (NOLOCK) etc.

as long as the table isn't being updated - this saves time as no...

opc.three (9/19/2012)

---

Jeff Moden (9/18/2012)

---

And some folks wonder why I/O is one of the biggest bottle-necks on some servers. Imagine what it would cost to get a 300% improvement by...

It would be a regular windows user account, that is part of an Active Directory domain. How do you log into your machine (not SQL\SSMS)?

Does the user NCG_009SOCSB_DBO_AP exist in the CORP domain?

surma.sql (9/20/2012)

That table has all historic info.

that table contains all user archive log entries for application. and it will starts from last 2 years. I already put red flag on...

You also may want to consider using the WITH COPY_ONLY for the backups used to refresh dev, so you do not mess up the transaction log sequence of your primary...

Is the SQL Browser service running?

Not sure if a delete trigger solves the problem, because TRUNCATE is non-logged. That is why it is so quick, but also why it requires elevated permissions.

Is it...

What is the actual value for the /SERVER parameter, where you have "SERVERNAME"? Are you using Local, or "."? Or is it possibly on a clustered instance and...

Some fantastic info on deadlocks and DL graphiong can be found here:

http://blogs.msdn.com/b/bartd/archive/2006/09/09/deadlock-troubleshooting_2c00_-part-1.aspx

Regarding the value of a certification, I would not say that a cert + no experience is worthless. For someone entering the field, getting a cert does show some...