Jeff Moden (7/22/2012)

---

But, by bringing it up and since I'm one to call Powershell from xp_CmdShell, it does seem...

Also, if you ran it with DATA_PURITY through Ola's scripts last week but without it over the weekend that could explain the difference in time.

PS as long as it had...

If you do not mind sharing a bit...

That is not nearly enough info for us to begin helping.

How to Post Performance Problems by Gail Shaw[/url]

If you only install Express you'll be missing server management tools like Profiler. Here is a good rundown:

What does this Express Edition look like, anyhow? By Tibor Karaszi

GilaMonster (7/22/2012)

---

opc.three (7/22/2012)

---

I suspect if someone were to get serious about using fn_dblog to count 'middle page splits/sec' they could somehow achieve this by referring to the object to find...

Jeff Moden (7/22/2012)

---

opc.three (7/21/2012)

---

Jeff Moden (7/9/2012)

---

Koen Verbeeck (7/9/2012)

---

SSIS can rename files. I do it all the time.

It just happens to be that with a script task using .NET I have...

This article explores, compares and contrats some of the issues being discussed here: Using the WMI Event Watcher Task in SSIS to Process Data Files [/url]. The article demo is...

I was aware of Jonathan's work in this area with EE on 2008 but had not kept up with the latest developments on 2012. The Xevent A Day series he...

weary

Robert Davis (7/21/2012)

---

Page splits have a Transaction Name of 'pagesplit'. It's just a matter of counting them and dividing by the number...

Jeff Moden (7/9/2012)

---

Koen Verbeeck (7/9/2012)

---

SSIS can rename files. I do it all the time.

It just happens to be that with a script task using .NET I have more control over...

Have you evaluated Merge Replication?

Jeremy Brown (7/20/2012)

---

Hi everyone!

I'm looking for a few good design examples for how someone has thought about SSIS WRT contract management, data quality, and data lineage reporting.

For example, there are...

Looks like a data conversion error. Can you confirm there are no lines in the file where that field is empty? You may want to change your derived column expression...