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....

Check here instead. Microsoft usually keeps these pages pretty up to date. But you're right, no CU for SP4.

There are both tools and education resources on source control and it's use on this page at Redgate Software[/url].

I'm with Lowell, rpc_complete would be the way to do this. But, just for an example, I did one that captures sql_batch_complete so that I can test it from SSMS:

CREATE...

patrickmcginnis59 10839 (2/19/2015)

---

Eric M Russell (2/19/2015)

---

OK

When a table is...

Volunteer to build databases for organizations in your area, soup kitchens, synagogues, Scouts, whatever. That'll get you experience, which is the most needed commodity when looking for a job.

It's usually very dangerous to compare cost to cost between different queries. Since the costs are just estimates, when the query changes, so do the calculations. Costs are good within...

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

---

Grant Fritchey (2/19/2015)

---

shane.green 1227 (2/19/2015)

---

There are exceptions to every rule, so while "All tables should have at least one index" is good rule - it doesn't...

I strongly suggest you start putting your database code into source control in the same way as you would manage your application code. If this code is "important" as you...

You're not using this in any other place in the query? I set up a test:

SELECT CASE cr.CountryRegionCode ---Mod # 2 Start

...

I wouldn't say either is better either. From what I can tell I think I'd have the same issue with both. I think you're going to get a single plan...

In addition to Gail's excellent articles, for even more detail, check out my book on query tuning in my signature below.

You might also look at the free book Troubleshooting for...

Check your Configuration Manager to see if you have any config issues, aliases, something along those lines. Compare your Config Manager to the person who is successful to see if...