Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
SELECT ELIG.ID_STD_DEMO_DISTRICT,ELIG.TXADAELIGCODE, MAXADA.MAXTXADAELIGDATE ,AEC.ADA_ELIGIBILITY_CODE_CODE FROM dbo.TXADAELIG ELIG INNER JOIN (SELECT ID_STD_DEMO_DISTRICT, MAX(TXADAELIGDATE) MAXTXADAELIGDATE FROM dbo.TXADAELIG GROUP BY ID_STD_DEMO_DISTRICT )MAXADA ON ELIG.ID_STD_DEMO_DISTRICT = MAXADA.ID_STD_DEMO_DISTRICT AND ELIG.TXADAELIGDATE = MAXADA.MAXTXADAELIGDATE and MAXADA.MAXTXADAELIGDATE <= getdate() INNER JOIN dbo.CDM_SET_ADA_ELIGIBILITY_CODE AEC(NOLOCK) ON AEC.ID_SET_ADA_ELIGIBILITY_CODE = ELIG.TXADAELIGCODE WHERE ELIG.ID_STD_DEMO_DISTRICT =5001
|Query - which index being used?||2||61|
|upgrade sql 2005 32bit to sql 2008 32 or 64bit on a server 2008 r2 box||6||76|
|Need help debbuging stored procedure||21||44|