If you post sample tables in the form of CREATE TABLE statements, sample data in the form of INSERT INTO statements and the SSIS Package you are working with I'll...

Orlando Colamatteo (4/16/2016)

---

...

Now, interestingly enough, the same test using the built-in FORMAT function yielded similar performance to CONVERT. I am not sure if optimizations have been added but I am...

Orlando Colamatteo (2/10/2016)

---

Ed Wagner (2/10/2016)

---

Orlando Colamatteo (2/10/2016)

---

Luis Cazares (2/10/2016)

---

micang (2/10/2016)

---

Orlando Colamatteo (2/9/2016)

---

The performance of FORMAT is very poor when used over large sets of data which is unfortunate because the...

Your configuration is going to be uncommon to say the least (SQL 2005 is beyond end of life). Any response on a Forum is going to be heresay from the...

thebigvalbosky (4/14/2016)

---

Hello - loved the article as well. I tried implementing it using 2008 R2 and i ran into the problem where this reference does not exist.

[Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute]

I've...

checkpoints do not cause log truncation when in full (or bulk logged) recovery mode and a log...

Practical, useful information from the front lines. These settings are analog to setting Max Memory on a new instance. They certainly caught my team and I off guard when first...

diamondgm (3/29/2016)

---

TomThomson (3/28/2016)

---

You have my deepest sympathy.

I wrote some of...

As I mentioned I would use SSIS...

Are you trying to incite a riot, Phil?

In my experience (and I think IBM did some work around this that support it) a consistently formatted codebase has less bugs than...

Thanks for the question.

sqlnewbie17 (3/24/2016)

---

Apologies to disappoint people on board for their 'humour'. But that is not the case.

I need to extract the result from the stored procedure from a bunch of servers...

william.palace (3/24/2016)

---

The stored procedure presented in this article appears to be incomplete as of the time I am writing this post. The last line I can see in the textbox...

I'd attend. I think there is a razor thin line between being a team player and carrying out the broader plan even when some implementation details may be suboptimal and...

A couple places I willfully employ triggers:

1. maintaining audit columns like last modified date and user

2. copying modified or deleted rows to an audit table or shadow-history table

I see it...