Matt Miller (#4) (7/12/2011)

---

The water cooler must be leaking, because it just got deep in here:).

That said - trying to disassociate law from social contract is like trying to separate...

Stefan Krzywicki (7/12/2011)

---

GSquared (7/12/2011)

---

WayneS (7/12/2011)

---

The "robbing" just takes your money, without having to...

I don't use FKs to cascade deletes. I map out the actual data dependencies, and build scripts/procs that explicitly handle the data correctly.

This avoids a couple of issues. ...

WayneS (7/12/2011)

---

The "robbing" just takes your money, without having to deal with the...

Stefan Krzywicki (7/12/2011)

---

GSquared (7/12/2011)

---

Steve Jones - SSC Editor (7/12/2011)

---

Stefan Krzywicki (7/11/2011)

---

Jim Murphy (7/11/2011)

---

Stefan Krzywicki (7/11/2011)

---

I don't know if none of the best banks are US based, but most of the...

Steve Jones - SSC Editor (7/12/2011)

---

Stefan Krzywicki (7/11/2011)

---

Jim Murphy (7/11/2011)

---

Stefan Krzywicki (7/11/2011)

---

I don't know if none of the best banks are US based, but most of the worst banks are...

Using functions, especially string functions, in the Where clause, will almost always make a query slower. Frequently, much slower. However, when it's the only way you have to...

First, datareader and datawriter are dangerous rights to have to grant. Given that you sometimes have to do so, to accommodate poorly designed applications, you have to recognize in...

Pad it with leading zeroes and use the Right() function.

select Right('00000' + cast(1 as varchar(5)), 5);

You've got the quotation marks wrong.

Try this:

EXEC sp_MSforeachtable @command1= 'PRINT ''?''; ALTER INDEX ALL ON ? REBUILD WITH (ONLINE = ON)'

Note that the quotation marks around the command are single-quotes,...

They probably have a contract with Microsoft. That kind of thing...

You have to add agents to the SQL Agent set up.

You do that through the Proxies tab. You'll have to set up a Credential first (server security).

As an aside,...

Usually, your application will capture SQL errors. What are you using for your front-end?

I guess it depends on what you mean by "nested select statements".

Are you using derived tables?

select *

from

(select Col1, ColA

from Table1

inner...

How about transaction logs? Any databases running in Full recovery, are the logs getting backed up?

Do you run backups onto the D drive or somewhere else?