Viewing 15 posts - 1,066 through 1,080 (of 1,157 total)
GilaMonster (2/9/2011)
Oh, and Apex SQL log retains for about $1000. That's a fair bit of money for an accident.
Most companies would buy a package from Apex rather than a single...
February 9, 2011 at 6:44 am
So long as the data page still exist and havent been reused, it may be possible to recover the table.
I'm pretty sure when a drop command is issued, the pointer...
February 9, 2011 at 6:42 am
ApexSQL claim their Recover product works even in SIMPLE mode.
Check this screenshot at Getting Started/Selecting Recovery Option.
I suggest you begin taking regular back ups straight away
February 9, 2011 at 6:15 am
You can get the plan_handle using this.
SELECT P.plan_handle
, usecounts
, cacheobjtype
, objtype
, [text]
,query_plan as QEP
, db_name(qp.dbid) as [Database]
FROM sys.dm_exec_cached_plans p
CROSS APPLY sys.dm_exec_sql_text(plan_handle)
CROSS APPLY sys.dm_exec_query_plan (plan_handle) qp
WHERE p.cacheobjtype = 'Compiled Plan'
and text...
February 9, 2011 at 6:09 am
sp_recompile should be your preferred method of regenerating a QEP. In a production environment you should rarely if ever have a need to flush the whole cache.
February 9, 2011 at 5:17 am
Check for an open transaction.
If there is and is deemed safe to do so, kill the SPID with the transaction.
Take a transaction log backup and then shrink the transaction...
February 4, 2011 at 9:33 am
I seem to remember a tool in the Idera toolkit which might do this.
February 4, 2011 at 8:07 am
Does the previous dba's windows account still exist? Can you have the password reset and login using this account?
February 4, 2011 at 4:23 am
I know of no way of way of recovering the sa password.
Was the dba a member of a windows active directory group which you could be added to?
Other...
February 4, 2011 at 3:02 am
This will only apply in a small number of situations. The point of SQL Server providing high availabilty means this is not usually possible without a maintenance slot.
A useful...
February 3, 2011 at 6:35 am
My company have recently reached the limit of connections on a couple of occasions during peak operating capacity and we've now looking at scaling out again (4th time).
There are only...
January 31, 2011 at 4:33 am
SQL2008 (non R2) had performance issues with linked servers.
It may be worth looking at the R2 cumulative updates for similar fixes.
January 19, 2011 at 12:21 am
Yes. You can configure each publication to either duplicate indexes or not. Once subscribing, there is nothing stopping you creating different indexes directly on the subscriber.
January 19, 2011 at 12:20 am
Have you configured the subscribers to use queued updates? This can be done at the replication\subscriptions node on the subscriber.
December 30, 2010 at 9:38 am
2) When an article is modified in Publisher, the change should be reflected to the Subscriber instantly and vice versa.
This requirement suggests that transactional replication is what you are after,...
December 28, 2010 at 5:50 am
Viewing 15 posts - 1,066 through 1,080 (of 1,157 total)