It's generally a good idea to have SQL Server run on a machine by itself and not share the server with other processes. SQL Server only consuming 85% sounds like...

Bouke Bruinsma (2/23/2015)

---

GilaMonster (2/23/2015)

---

Absolutely not. You...

Run DBCC CHECKDB.

The output will tell you what is corrupted. If you're lucky, it's a nonclustered index. You can drop it and recreate it and walk away a winner. If...

You can only update multiple rows in a single statement if they have matching criteria. For example, there's a ShipByDate and they all have the same value, then the WHERE...

Here, read this.[/url]

I've heard about this being an issue before, but I'm not sure what the solution is. In most circumstances, you shouldn't be running SSMS on the Production server. Instead you...

Ed Wagner (2/20/2015)

---

Grant Fritchey (2/20/2015)

---

Sean Lange (2/20/2015)

---

Grant Fritchey (2/20/2015)

---

Ed Wagner (2/20/2015)

---

jasona.work (2/20/2015)

---

Lynn Pettis (2/18/2015)

---

... Mark one off, 9 days on the calendar to go. 9 days on the calendar to...

Sean Lange (2/20/2015)

---

Grant Fritchey (2/20/2015)

---

Ed Wagner (2/20/2015)

---

jasona.work (2/20/2015)

---

Lynn Pettis (2/18/2015)

---

... Mark one off, 9 days on the calendar to go. 9 days on the calendar to go, 9 days to...

BOR15K (2/20/2015)

---

Grant Fritchey (2/20/2015)

---

Yeah, the queries run on the server. Filtering, ordering, etc., that are defined within the query, will all be done on the server. Now, once you have...

Yeah, the queries run on the server. Filtering, ordering, etc., that are defined within the query, will all be done on the server. Now, once you have the result set,...

Ed Wagner (2/20/2015)

---

jasona.work (2/20/2015)

---

Remember to stay...

The query will return what the query returns. So, in your first example, all the 1,000 rows are loaded into memory in Australia and then they're sent over the wire...

Koen Verbeeck (2/20/2015)

---

Grant Fritchey (2/20/2015)

---

Here are a few suggestions in addition to what Koen already said.

You might want to drop all indexes and foreign keys from the table you're loading...

Here are a few suggestions in addition to what Koen already said.

You might want to drop all indexes and foreign keys from the table you're loading to, depending on how...

I'm not surprised the event_sequence isn't available in 2008, but I could have sworn they supported sql_batch_completed. Take a look at the events available by running the query from here....