P90X

vidya_pande (4/3/2010)

---

I have seen huge CRM application (Product) is with out FK's. These databases are in hundreds of GB's.

One advandate is definitely there - hiding the DB design.

Also i have...

I'm glad you guys suggested...

Congrats

Paul White NZ (4/3/2010)

---

It simply isn't good enough to state that entity integrity must be enforced by the database layer, and anything else is somehow irresponsible or dangerous. The...

Paul White NZ (4/3/2010)

---

Have used LiteSpeed quite extensively, but never HyperBac. The thing I don't like...

sumit.joshij (4/2/2010)

---

I am totally agree with your point that database should maintain its integrity itself. but if interface should have that much of control that it can handle and check...

Jeff Moden (4/2/2010)

---

Gosh... :blink: You would think that an MCM would be required to know how to distinguish between good code and bad code as part of some sort...

Steve Jones - Editor (4/2/2010)

---

I haven't gone through Brent's Blog on it, but I doubt they have a lot of T-SQL taught. I think it's more details on the SQL...

olie480 (4/2/2010)

---

lmu92 (4/2/2010)

---

Btw: What do you mean by "query manager"?

If you're using SQL Server 2000, the query shouldn't run at all since table variable as well as ROW_NUMBER function that...

WayneS (4/2/2010)

---

CirquedeSQLeil (4/2/2010)

---

WayneS (4/2/2010)

---

Paul White NZ (4/2/2010)

---

Steve Jones - Editor (4/2/2010)

---

You...

Some of your query response time is going to depend on indexing strategies employed. Some of it will depend on the actual structure of the query (i.e. the use...

From the 6.5 servers I administered through the 2008 servers that I administer, the default for fill factor was 0. I don't know where your instructor got their information...

George, I think you would be ok with RedGate Backup. It's not like most other backup tools for SQL server. It integrates nicely with SQL server and iirc...

It uses better search arguments and also limits the result set. The better search argument allows better index use. If you include your graphical execution plan - you...