Thank you again. I appreciate you giving your time to help newbies like me develop my understanding.

Regards

Andrew

Thanks for your response it is good to know that it could have been done without corruption - I was just being conservative due to the length of the recovery...

I think 'frank and fearless' is likely to be way more constructive than 'brutal'. If you have a group of people in a room, all pointing out shortcomings in...

mark hempen (6/15/2012)

---

Also don't forget to check out what user account owns the stored procedures and the security role attached to that login. I have had many instances in...

Another suggestion from me would be to consider creating foreign key / unique / check constraints if they don't already exist. I initially do this in a local copy...

Depending on your constraints (coding standards etc) it may be possible to use Dynamic SQL to do this.

Google is your friend...

http://beyondrelational.com/modules/2/blogs/88/Posts/14196/changing-rows-to-columns-using-pivot-dynamic-columns-for-pivoting-in-sql-server.aspx

This should not be done lightly - I...

How about

;with distinctMonths

as

(

select distinct dateadd(month,(t.[month]-1),

dateadd(year,(t.[year]-1900),0)) as MonthDate,

t.[MONTH],

t.[year]

from temp as t

),

earliestMonth

as

(

select t.PAN,min(dm.monthdate) as EarliestMonth

from distinctMonths as dm

INNER JOIN temp as t

on dm.Month = t.Month and

t.Year = dm.Year

group...

The execution plans - one with ix_ProblemIndex takes 1 min 20 sec to run, if you drop problem index you end up with less than a second.

For me, I would say the DMVs included in 2005 and later, including one I recently found very useful, sys.sql_dependencies. It allows you to find all the stored procs...

Maybe you could use Try/CATCH