patrickmcginnis59 10839 (12/9/2013)

---

ZZartin (12/9/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

Jeff Moden (12/9/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

Jeff Moden (12/9/2013)

---

This...

patrickmcginnis59 10839 (12/9/2013)

---

Jeff Moden (12/9/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

Jeff Moden (12/9/2013)

---

This is how RBAR...

patrickmcginnis59 10839 (12/9/2013)

---

Solomon Rutzky (12/9/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

Solomon Rutzky (12/9/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

Solomon Rutzky (12/9/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

I'm not saying there isn't a penalty for RBAR in T-SQL. Rather, I think it would...

MarbryHardin (12/9/2013)

---

One of the somewhat insidious problems with undetected or uncontrolled use of RBAR is that it may often work fine. At first.

As both the load and number of...

bens4lsu (9/6/2012)

---

That seems like a lot of work, when you could modify the original stored procedure to save the multiple result sets to a temp table and then return them...

Thanks for the replies, it looks like the problem was due to bad statistics on one of the tables. After updating the query runs fine with the function in...

You can pass information from parent packages to child packages. Go to SSIS and click on Package configurations then click the enable package configurations and click Add. Set...

In the control flow right click it and open the variables screen, create a new variable and set the type to string. When you have that variable selected the...

Yep I believe you can create a variable in the package and set EvaluateAsExpression to True and set the expression for that variable to the file path, then use that...

Indeed you can, use an expression to change I believe the FileAttachments property to the location of the file you want to attach. Here's some code that formats a...

Is there a reason you have to do this in SQL Server? Could you make the switch at the application level instead and only switch it for the applications...

Brian Carlson (9/7/2011)

---

(I should have said last detail row instead of second) What I meant by this was that the "row delimiter" is ~ until the end of the line,...

So if I'm reading this right you have have two sets of data in your input file in each row, the order information which is delimited by commas then the...

Either way your downtime will be the time it takes to copy the database files to the new location.

You could also detach the database, copy the database file(or files if you are moving the logs too) to the new location(s) then reattach the database with the relocated files....