Troubleshooting SQL Server: A Guide for the Accidental DBA[/url]

Is it your proc? Does it need to exist, and if so do you need to preserve it's interface because it has other uses? What is the proc doing? Depending...

Jeff Moden (6/4/2012)

---

opc.three (6/3/2012)

---

You ought to put that one in...

Jeff Moden (6/3/2012)

---

opc.three (6/3/2012)

---

It is your lucky day rka 😉

Jeff, I have attached a sample package that does what I outlined in the pseudocode above. It is done in...

You can go away from using PIVOT and use a traditional crosstab. This should help clear things up. There is a link to part 1 for static data as well:

Cross...

Assuming you mean a regular view and not an indexed view you would optimize the underlying query. A view (regular) is not able to be optimized in and of itself.

Ideally you and your testing team would have access to the same source control repository. Using some of the features built into TFS for example, you could leverage Labels or...

You could look into merge replication or transactional replication with a pull subscription. With those two methods you can control when replication runs. You would need to setup some type...

I would be happy to help if you provide DDL in the form of a CREATE TABLE statement, sample data in the form of INSERT statements and your expected results.

RBarryYoung (6/3/2012)

---

Jeff Moden (6/2/2012)

---

RBarryYoung (6/2/2012)

---

Jeff Moden (6/2/2012)

---

I'll say "IT DEPENDS". Let's have a race. You write a...

I hope that addresses all the requirements. A package like this takes about 30 minutes to develop for a simple flat file and I only bother the database engine when...

Jeff Moden (6/2/2012)

---

opc.three (6/2/2012)

---

For the record what the OP wants to do can be done without the use of any custom Script Tasks or Script Components, i.e. using only in-the-box...

Thomas Stringer (6/2/2012)

---

SQLCLR is an excellent tool, and there are just some things that can't be accomplished with pure T-SQL. Mostly the Windows environment, and aspects outside of the...

For the record what the OP wants to do can be done without the use of any custom Script Tasks or Script Components, i.e. using only in-the-box SSIS objects.

Perry Whittle (6/1/2012)

---

Yes it does it's a sort of one size fits all, default...