Two very different features. Both really for working across servers, thought it's possible to replicate within an instance

Start here:

Mirroring http://msdn.microsoft.com/en-us/library/bb934127.aspx

Replication http://msdn.microsoft.com/en-us/library/bb500346.aspx

Once you're read through that lot, if you still have...

Take a look at this series: http://www.sqlservercentral.com/articles/Indexing/68439/

Columns specified as include are ones in the select clause, but not used in where/join. Don't trust the missing index dmvs totally. Test out...

Two print copies, both signed by various authors/editors, one for me one to be given away at a usergroup meeting sometime next year.

Can you explain in more detail what you've done, what happened and what you...

Restore the latest backup of MSDB (perhaps to a test instance), script out the job, apply the script on the server where the job was deleted.

Firstly, statistics as controlled by Create/update/drop/ DBCC SHOW_STATISTICS are completely unrelated to SET STATISTICS XX. The first are column statistics used by the optimiser, the second shows query execution statistics.

Some...

No, but you could very likely end up with a suspect and unusable database. The...

Likewise, and I had supper a couple hours ago.

gregory.anderson (11/20/2009)

---

If a proc's plan is cached, and I make changes to the procedure via an "Alter" statement, does SQL Server know that it needs to rebuild the execution plan...

Double (triple) check that you're looking at the same server from the Quest tool and management studio. Double (triple) check that it's the same database. Double (triple) check that it's...

How do you know it's not executing?

select <column list>

from sys.dm_exec_cached_plans cp

Cross Apply sys.dm_exec_query_plan(cp.plan_handle) qp

Inner Join sys.objects o On o.objectid = qp.object_id

Run this in the DB that the object is in rather than master, otherwise you'll get...

Double check the code of the procedure to make sure somehow the old version didn't get re-applied over your changes. When you change a proc, the very next call will...

Interested in a 3-hour pork goulash recipe? Or maybe a 6 hour beef...

AhTu_SQL2k+ (11/20/2009)

---

Anyway, I followed your advice to make sure those 'join' columns and 'where' columns have their index; Rtrim(Ltrim(()) and Order by clauses were also removed but it still takes...