Luckily it was a minor issue. When you select...

tom.groszko (5/2/2016)

---

Did you ever find a PBM way to do this.

I have been unable to find any facet that looks at code.

The facet Multipart Name only looks at the...

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