your sequence doesn't contain re-creation of the objects you dropped before altering the CLIX (NCI, constraints, FK-indexes,..)

Here's another great resource by Brent Ozar that may get you on track tackling potential problems with san configurations for sqlserver

http://www.brentozar.com/sql/sql-server-san-best-practices/

other factors that can influence performance:

- concurrent connections/users (b)locking on objects

- tempdb IO and tempdb sizing

- not using set based approaches

- organization of your tables, indexes, indexed views, ...

- over...

hemanth.damecharla (12/7/2011)

---

Automating daily tasks is not only easy with Posh but, fun as well 🙂

Chad Miller's MSCS code on poshcode site is a wonderful starting point if you want...

Samuel Vella (12/7/2011)

---

Use cases:

Dev environment with 100's of tables, stored...

Lowell (12/6/2011)

---

ALZDBA (12/5/2011)

---

When you switch to the engine level compatibility (100):

- did you update all statistics

- did you perform dbcc updateusage

- did you perform full db maintenance

- did you...

Thank you, Mohammed.

Samuel Vella (12/7/2011)

---

skron (12/6/2011)

---

I have found Powershell to be invaluable to me as a DBA. I have been able to...

Did you commit the alter table statement ?

What's the @@opentran count for that session ?

Thank you, Roy. I hope it gets people started.

skron (12/6/2011)

---

I have found Powershell to be invaluable to me as a DBA. ...

There is no need for two tables having a FK relationship to be able to use it in a join condition.

I would check:

- the sqlserver errorlog

- the default trace (it records object creation and delete)

and off course as already suggested a sqltrace will throw light on this issue.

Co-ordinate it with...

Do I read "a new addict" ? 😀

GilaMonster (12/5/2011)

---

ALZDBA (12/5/2011)

---

When you switch to the engine level compatibility (100):

- did you update all statistics

- did you perform dbcc updateusage

- did you perform full db maintenance

- did you...

Does Powershell come in to picture ?

http://ask.sqlservercentral.com/questions/36601/powershell-export-multiple-tables-to-csv

When you switch to the engine level compatibility (100):

- did you update all statistics

- did you perform dbcc updateusage

- did you perform full db maintenance

- did you run DBCC...