Viewing 15 posts - 35,701 through 35,715 (of 49,557 total)
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...
November 23, 2009 at 2:05 am
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...
November 23, 2009 at 1:26 am
Two print copies, both signed by various authors/editors, one for me one to be given away at a usergroup meeting sometime next year.
November 23, 2009 at 1:20 am
y.koteswarrao-652921 (11/23/2009)
yes, recently i have taken full database backup and i missed .mdf file,how to recover it?
Can you explain in more detail what you've done, what happened and what you...
November 23, 2009 at 1:19 am
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.
November 23, 2009 at 1:17 am
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...
November 21, 2009 at 2:29 am
syedkamranfaisal (11/20/2009)
will db performance be improved if we delete the log file and create new one?
No, but you could very likely end up with a suspect and unusable database. The...
November 21, 2009 at 2:21 am
Gianluca Sartori (11/20/2009)
...Uhmmm... I'm getting hungry.:-)
Likewise, and I had supper a couple hours ago.
November 20, 2009 at 12:26 pm
gregory.anderson (11/20/2009)
November 20, 2009 at 12:23 pm
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...
November 20, 2009 at 9:32 am
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...
November 20, 2009 at 9:15 am
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...
November 20, 2009 at 9:13 am
Gianluca Sartori (11/20/2009)
It's not pork chops, but I think it could be time for the friday recipe. 🙂
Interested in a 3-hour pork goulash recipe? Or maybe a 6 hour beef...
November 20, 2009 at 9:08 am
AhTu_SQL2k+ (11/20/2009)
November 20, 2009 at 6:19 am
Viewing 15 posts - 35,701 through 35,715 (of 49,557 total)