Repeating Gail's question:

Are they connecting to the same instance, same database?

First of all, how do you get your data into SQL Server? What are you using?

That's why I included a link to the help topic on those functions. Books online (BOL) or online help or simply SQL Server help (as easy as pressing F1 on...

Here you go, these are all the differences:

http://technet.microsoft.com/en-us/library/bb500435(v=sql.110).aspx

Stan Kulp-439977 (8/7/2014)

---

shah.muhammad (8/7/2014)

---

Bulk Insert works in most cases but if your operation is based on sequence, you can't rely on bulk insert as it loads the data from the...

Eirikur Eiriksson (8/6/2014)

---

benjamin.reyes (8/6/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Grant Fritchey (8/5/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Guess one has to differentiate between five years of work and five years worth of experience. Questions like "what are the...

Try using CAST or CONVERT

A stored procedure (or any process in a batch) runs each statement one at a time waiting for each one to complete.

Deadlocks occur between different sessions, so a single SP...

That's true, but this could work as a guide. This script was originated from a forum post and I thought of sharing it even if it can't be used as...

Eirikur Eiriksson (8/5/2014)

---

Luis Cazares (8/5/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Grant Fritchey (8/5/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Guess one has to differentiate between five years of work and five years worth of experience. Questions like "what are...

Eirikur Eiriksson (8/5/2014)

---

Grant Fritchey (8/5/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Guess one has to differentiate between five years of work and five years worth of experience. Questions like "what are the DAC limitations", "consequence...

GilaMonster (8/5/2014)

---

Luis Cazares (8/5/2014)

---

Koen Verbeeck (8/5/2014)

---

Migrate from Oracle to SQL...

Eirikur Eiriksson (8/5/2014)

---

Luis Cazares (8/5/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Luis Cazares (8/5/2014)

---

Koen Verbeeck (8/5/2014)

---

Grant Fritchey (8/5/2014)

---

You get a phone call. The person on the phone says the database is slow. What do you...

Fix the code.

Change permissions to the web app user to the minimum needed. You'll still get attacked but the damage can be minimized.

Fix the code.

Fix the code.

The code should...

Eirikur Eiriksson (8/5/2014)

---

Luis Cazares (8/5/2014)

---

Koen Verbeeck (8/5/2014)

---

Migrate from Oracle to...