Erin Stellato (11/19/2012)

---

Ohhh, that's a good question. I don't have any current plans to write about SSIS baselines, but that's an excellent idea. I'm not a SSIS guru...

Excellent article Erin,

I've already watch your course about baseline on pluralsight and now I'm waiting for the rest of this series of articles. 🙂

Will you write about SSIS baseline?

I work...

Hi GilaMonster,

If using enterprise edition it's possible to rebuild indexes online without bloking the access to that index right?

Best regards,

Hi,

Also use DMV, if you are using SQL Server 2005/2008, search for "find most expensive query using DMV", "performance DMV" or "bottleneck dmv" in google.

After a deploy and...

Hi,

Did you check the database compatibility level?

I the DB is still on SQL server 2000 compatibility level try changing to 2005 and then i would recommend rebuild all...

Hi,

Once I need to write to a new Excel file and what I did was the following:

-Create a Excel connection manager to a file, if you need you can...

Hi All,

Will bet on the first option, why?

you have to copy the data on both option so there is not gain were.

But on the cluster index, this...