TheSQLGuru (1/4/2016)

---

lucien.jacquet (1/4/2016)

---

My point is not to contradict your assertion that scalar functions "can be" expensive, but to suggest that your example is a worst-case scenario. Is it possible that...

mw112009 (1/4/2016)

---

Please see the attached pic first.

I like to add an event handler and in that I could setup a SQL task to write to a table when a "SQL...

Thanks!

If it's a single-database process, SSIS is rarely a recommended way forward. I'd still put the code in a stored proc though, and use SQL Agent to execute that...

karen.blake (1/4/2016)

---

I have put this here as I am still learning about SSIS and have assumed I can do this using this.

So, there is a table where we need to...

Eirikur's response rendered what I was going to write mostly redundant. But I do have some minor points:

1) If you 'obfuscate' something, you make it unclear or difficult to interpret....

Eric M Russell (12/30/2015)

---

Orlando Colamatteo (12/30/2015)

---

Assuming the identity seeds were both 1, loading with IDENTITY_INSERT ON using the original identity *-1 (what Phil said) is where I would start the...

titsiros (12/30/2015)

---

Hi Phil, thanks for the -1 tip, that would work also..Do you know of any tool that would do this instead of scripting this manually? I looked into Redgate...

If a CASE statement is returning an item from a list...

dndaughtery (12/30/2015)

---

I used a select...into to create a staging table. Its been fine but lastnight I got a truncation error. I was under the "Assumption" that sql server looked at...

Certainly did. And invented a new noun, the "scree-shot" 😛

Eric M Russell (12/28/2015)

---

I'm assuming the scenario is that you have two clients in separate SQL Server instances, each having overlapping sequential integer identifiers, and so you need to assign...

drew.allen (12/29/2015)

---

Your client may be limiting the number of characters returned. It may limit either the total returned or the amount returned per column. For instance, SSMS limits...

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the...

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from...

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical...