pwallis (4/19/2012)

---

The developer is indicating that it is in executing the CREATE VIEW using the SQL statement that takes the time, if we run just the SQL statement without the...

Use the SSIS transfer login task or use a script that copies the SIDs over as well as the login names. With either of those you won't have orphaned login...

Maybe they were looking for severities, maybe they were looking for error behaviours, maybe they were looking for the points at which errors can occur during query execution. Can't say....

http://www.sqlservercentral.com/articles/Indexing/68439/

http://www.sqlservercentral.com/articles/Indexing/68563/

http://www.sqlservercentral.com/articles/Indexing/68636/

Absolutely. I know of many companies...

Could you post the exec plan please (the .sqlplan file)? I don't feel comfortable advising you on details without seeing the plan

Agent job or maintenance plan would be my preference. Maintenance plan is easy if you're fairly new.

These 4 can be replaced with one index

_dta_index_line_item_disposition_5_1662628966__K1NONCLUSTERED00order_numberNULL

_dta_index_line_item_disposition_5_1662628966__K1_9987NONCLUSTERED00order_numberNULL

_dta_index_line_item_disposition_5_1662628966__K1_32NONCLUSTERED00order_numberupdate_dtm

_dta_index_line_item_disposition_6_1662628966__K1_K15_5379NONCLUSTERED00order_number, date_shippedNULL

Single index on OrderNumber, DateShipped include UpdateDTM

These 4 can be replaced with one index

_dta_index_line_item_disposition_5_1662628966__K1_K2NONCLUSTERED00order_number, line_numberNULL

_dta_index_line_item_disposition_5_1662628966__K1_K2_18NONCLUSTERED00order_number, line_numberquantity_shipped

PK_line_item_disposition__order_number__line_number__backorder_numberCLUSTERED11order_number, line_number, backorder_numberNULL

_dta_index_line_item_disposition_5_1662628966__K1_K2_K8_18NONCLUSTERED00order_number, line_number, backorder_numberquantity_shipped

Single index on...

An index spool is a temporary index built in TempDB because the optimiser really needed an index on that column but there wasn't one.

Without seeing the exec plan, it's hard...

drew.allen (4/18/2012)

---

I realize it was just an example, but if there were a 2008-specific feature that was required for the...

Depends on the complexity of the view. If it's view upon view upon view it's probably inefficient. If it's a single view that's not particuarly complex, there's probably little to...

That was just an example. Sub any 2008-specific feature.

Thing is, if the job spec states SQL 2008 skills required, the recruiter may not want to risk his relationship with...

Still, for reporting look at replication.

Both mirroring and log shipping are DR techniques that can...

Lynn Pettis (4/18/2012)

---

Except for doing an upgrade a mirror needs to...

How do you know they're inconsequential for the particular job? The...