OCTom (1/20/2014)

---

Steve,

I agree with you comlpetely. It can set one apart from the crowd.

I find it ironic that you are writing this as your editorials often have misspellings and grammatical...

What do you mean 'best way'?

To change collation, you need to run an ALTER TABLE ... ALTER COLUMN on the columns you're changing.

Test in a non-production environment first, make...

Ok, and...?

With the trigger as you have posted it, any insert will fire that trigger and hence will run that procedure. Whether it works as intended is another matter, but...

Collations aren't per database or object. The collation on the database is just the default for new columns, there's no collation on an object. Columns are what have collation defined...

It's called parameter sniffing. Plans ARE replaced when you recompile.

Recompile either removes the plan from cache on the spot forcing a new compile the next time, or marks the...

Define 'doesn't work'?

What does that procedure do? What's the trigger supposed to do? Why is the trigger not referencing inserted or deleted pseudo-tables at all?

Also consider the SSIS Transfer Logins task.

If you're getting a collation error, you have two different collations. Check the columns, the database setting just defines the defaults

As for changing... Test on a non-production environment first! You...

Yes you can change it, it's a tonne of work. You'd have to run an ALTER TABLE ... ALTER COLUMN on every single char and varchar column in the database.

Doing...

It should be, but why count(<column name>) rather than Count(*)?

Wait until recovery finishes!

There is no alternate solution. There is no magic 'instantly finish recovery' button. Be patient and wait for the recovery to complete, then your DB will come...

So what do you expect to do when something goes seriously wrong and the DB...

Wait.

There is nothing else you can do, particularly since you have no backup. You have to wait until recovery is complete.

When you restarted the server all you did was force...

Should be the same all other considerations being equal.

Depends. If you create the index on the partition scheme, it will be partitioned like the table and stored across the three filegroups. If you create the index on a...