Revenant (11/1/2011)

---

There is no absolute answer to what is "the best." Dropping indexes may speed an INSERT-based load; however, if the load is done by MERGE (for example, to...

This really depends on how fast the stored proc retrieves data versus what the business expects for speed. If they want a report to run in 2 seconds, and the...

Revenant (11/1/2011)

---

jared-709193 (11/1/2011)

---

. . . Isn't it interesting how Microsoft developers can't design an application that effectively uses their own database engine? I would even accept one that followed at...

Matt Miller (#4) (11/1/2011)

---

Two things to consider:

- there's no such thing as a "physical order" in a DB. if you want to be able to track the ordering...

adams.squared (10/28/2011)

---

A couple of guys that I talked with here mentioned dropping the index as well and then add it back. Maybe one day one of us can take...

I hate Dynamics!...

Here is a script that I use that also allows a replace:

/*

* CATEGORY: Script

* AUTHOR: Luiz Barros

* OBJECTIVE: Find and Replace a string in all string fields (char, varchar, etc)...

mthurber (11/1/2011)

---

I guess I haven't learned how to separate my comment from the piece I was responding to. The first line only was from the original poster.

I suspect there may...

mthurber (11/1/2011)

---

I would like to do the same for division so for 01/01/2011 00:00 my calculation should be 2 / 4 / 6

You must have some kind of sequencer, right?...

MysteryJimbo (10/28/2011)

---

jared-709193 (10/27/2011)

---

Scenario:

Application may be routed to 1 of 4 servers depending on load and location: Colorado, Michigan, 2 Illinois. Data from each server needs to be replicated to 1...

Warren Peace (10/27/2011)

---

PaulB-TheOneAndOnly (10/27/2011)

---

Well... in a fifty serves environment is reasonable to have a well established division of responsibilities.

Weekend pages are part of our job or as one of my...

PaulB-TheOneAndOnly (10/27/2011)

---

jared-709193 (10/27/2011)

---

PaulB-TheOneAndOnly (10/27/2011)

---

jared-709193 (10/27/2011)

---

Scenario:

Application may be routed to 1 of 4 servers depending on load and location: Colorado, Michigan, 2 Illinois. Data from each server needs to be replicated...

PaulB-TheOneAndOnly (10/27/2011)

---

jared-709193 (10/27/2011)

---

Scenario:

Application may be routed to 1 of 4 servers depending on load and location: Colorado, Michigan, 2 Illinois. Data from each server needs to be replicated to 1...

Warren Peace (10/27/2011)

---

OK, I walked into an environment where with the following....

The SQL DBA Does not install the OS.

The SQL DBA Does not Install SQL Server. :crazy:

The SQL SBA...

Thanks!