jarrederoberts (4/6/2010)

---

I am trying to use SP_msforeachdb to query one table in every DB I have, but no system db's. here is the syntax im using. im not sure this...

I agree with Grant, if the idea is to "practice" datawarehousing think of this data movement as a whole ETL a.k.a. Extract, Transform & Load - process.

Remember, datawarehousing has...

I do think using a cursor is the right strategy.

Post suggest there are a number of secondary processes and tables involved, may be the process is slow because some of...

:crying: Is anybody concerned about referential integrity here? I bet whoever set that FK did it for a good reason.

I would start by taking full table scans out of the picture by ensuring there are indexes in place to serve queries and updates.

I would also create/recreate indexes with a...

I agree with Gregory. This approach should work just fine.

I assume that when you say "backup everything" you mean you are taking a physical backup of the whole server -...

Taking into consideration most queries rely on cluster index on client+date - as I can see it partitioning by date will certainly hurt performance during querying.

As a result of partitioning...

Are you trying to query a table that got dropped?

By the way, SQL Server does not keeps track of who drops and object but you can be certain was either...

I've seen so many "duplicate rows" postings lately that I feel somebody has to tell people Microsoft is not charging a license fee per unique index.

Once you have a...

you made my day! 😀

Did you went to tables/details pane, right-click the table on which the trigger exists, point to AllTasks, and then click ManageTriggers?

Glad to help

Please start by searching for "sliding window" in BOL; there is an...

Partitioning may be the answer for this archive and purge scenario.

Have you considered a sliding window on SERVER1?

You can send last partition rows to SERVER2 then truncate partition on SERVER1.

As a rule of thumbs I think on a new version of a product as the fullfilment of whatever the vendor promised for the...