Luis Cazares (1/2/2015)

---

Thanks to all of you.

I just re-read all of the posts and Jack's comment puzzles me. I'll try to find out and if I do, I'll come back.

This...

Shafat Husain (12/24/2014)

---

Hi,

Just a thought..!!

Why not use MERGE to get the data from these tables in your local database.

You can schedule a Job using Sql server Agent to run the...

Stefan Krzywicki (12/24/2014)

---

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS...

HLEBOEUF (12/23/2014)

---

Hello,

I need to sync several tables from a purchaes software to our own tables.

Not the complete tables, only selected fields.

Each source table has a timestamp, so I could use...

You are missing an ending parenthesis in what you posted. I put it at the end of the CAST.

Erland,

Thanks. That's where I was thinking of going as well. Just hoping I could find some way to do do it without going to trace or xe.

Turns...

LutzM (12/23/2014)

---

I would have guessed that the user is in another role that deny the execution of that sproc...

Did you check the effective permission for that sproc?

EXECUTE AS USER =...

Sure, but what it is changes every day, so none of it...

Stefan Krzywicki (12/16/2014)

---

Eirikur Eiriksson (12/16/2014)

---

Stefan Krzywicki (12/16/2014)

---

Eirikur Eiriksson (12/16/2014)

---

Jeff Moden (12/16/2014)

---

Steve Jones - SSC Editor (12/15/2014)

---

Jeff Moden (12/14/2014)

---

In the category of learning something new, I just did some testing on...

Considering I still have 20+yrs left in the work force, I've never been more than 4 consecutive years at an employer, salary levels in tech, and the constant change and...

It's hard to say without any code, but whenever something like this happens I start with "bad" parameter-sniffing. I'd start by looking at this blog post[/url].

That's the way I'd interpret the data, except the fact that the clustered index has a bunch of lookups and there aren't a matching number of non-clustered index seeks, because...

I believe you could do a REORG

You can't use T-SQL in SSIS expressions you need to use the SSIS Expression Language. This blog post is a good place to start looking at this.

What jumps out to me in this plan is that there is an index seek followed by a key lookup. I'd be willing to bet that making the non-clustered...