just a few things i'd throw in there, but it sounds like you've got it covered pretty well.

Post-Migration, make sure you rebuild statistics for all tables, in each database with...

d.velders (11/19/2013)

---

It's indead an idea to generate a SP that does the calculation of these working days.

Does anyone have an example on how to do this or even better a...

the default length is 1.

when you use cast or convert, the default length is 30, but for column definitions, it's a single character.

this seems to work for me;

I had this saved in my snippets:

SELECT depz.referenced_schema_name,

depz.referenced_entity_name,

objz.type_desc,

...

with the data you posted, everything is older than 40 months, so i assume the item has no official value any more; i added one example to the sample data.

so...

like SQLSACT said, you need something in place already to get "by hour" counts.

for example, this query gets the # of rows in each table. if you saved the results...

late response, but here's my advice: switch to using the 2012 SSMS immediately.

the differences are minor, but they are there, and there's no valid reason to be afraid of the...

Like Perry, I'm not sure where the question is, but i'll throw out a...

my first guess is that you ar emissing a GO statement;

you've got the CREATE / ALTER, and then a call of the same proc on the last line...so it calls...

raysteve43 (11/18/2013)

---

I am trying to upgrade to SQL 2012 from SQL 2005. I have a job that deletes expired records from a single table one a month....

answering my own question:

found a post that referenced "linked server" along with the error;

it pointed out that toggling this option on the linked server from true to false resolved the...

assuming you would join Source_X_Entity to the other two tables ,

i would think that if you create a non clustered index on Entity(NaturalKey), or maybe a non cluster on(Entity(EntityID)...

but a logon trigger would not tell what or when a database was accessed; it only fires at login, and...

yeah that's one of the problems with a linked server; data gets copied over to tempdb, and then joined to your data locally, so you could see a million+ row...

ahperez (11/18/2013)

---

Well, since this is a third-party app this might not be a practical option. Auto update stats is a database level command, impacting the whole db. Below is the...