Lynn Pettis (4/11/2012)

---

Nadrek (4/11/2012)

---

PaulB-TheOneAndOnly (4/9/2012)

---

The only way to know is to test and see what happens.

Either way the key portion of it all is the reorg storedproc, be sure the...

Stefan Krzywicki (4/11/2012)

---

Last time I tried to create the index, it told me I couldn't because it already existed, so I figured I'd start the query to create it and...

PaulB-TheOneAndOnly (4/9/2012)

---

The only way to know is to test and see what happens.

Either way the key portion of it all is the reorg storedproc, be sure the process does not...

Lynn Pettis (4/9/2012)

---

I understand how networks work, it seems to be mandatory now a days at home with everyone having their own computers.

I would like to learn more about NAS/SAN...

I'd say that part of the need for 'cross-training' comes from hiring overspecialized people to begin with - which the market in the past couple decades has tended towards.

Programmers who...

Interesting article, but I would note that the email address validation isn't the example I would have chosen.

An actual RegEx to validate email per RFC822 is at http://www.ex-parrot.com/pdw/Mail-RFC822-Address.html; it's significantly...

Joe Clifford (3/30/2012)

---

If your indexes are fragmenting like that in such a short period of time - I would suggest that there is something wrong with the db design -...

Define your disasters carefully - there are differences between what works well for disk failures (head crash), disk failures (read and/or write errors), network failures (cable unplugged to the server,...

Jeff Moden (3/24/2012)

---

Divine Flame (3/23/2012)

---

TheSQLGuru (3/23/2012)

---

I want to jump on the "you MUST adjust your fill factors to avoid such huge index fragmentation" bandwagon!! That is just crazy bad...

Watch out for installed instances you aren't allowed to use; sometimes they're named instances (ACT! is a common example), sometimes they're default instances, but there may be technical and/or contractual...

From a result correctness standpoint, also check your data for where suffixes can go; some systems put them in first name, some in last name, some in a separate field,...

TheSQLGuru (3/27/2012)

---

itpcpro (3/22/2012)

---

I was wondering if anyone has attempted this? We are wanting to create a VM image with SQL already on it so when we create a new VM...

It depends :). Fragmentation primarily slows things down by a logically sequential operation being effectively a random operation...

hexagonshield-odd2 (3/9/2012)

---

Hi

2.At this point can I configure SQL Server to back up to two locations? (The server MSSQL is installed on and a network file server). Is this a...

Do you have the SQL Native Client 11.1 installed, which is the provider specified?