GilaMonster (1/15/2009)

---

To offer any real help, I need to see the deadlock graph.

Without that, I can give you generic advice - make sure all your queries are written a optimally...

You can take a look at Maxdop to limit the number of CPUs used for the Jobs.

Are you saying that the Developers access your production DB where your clients...

Instead of sys.objects, why not try

SELECT *

FROM INFORMATION_SCHEMA.ROUTINES

...

The naming convention of SQL Server is a four part name.

Try this naming convention

You should not have DBO in that name

Check the event viewer to see if it is throwing an error. Also try to see what the Error log shows.

You can use this script to generate Grant permission for each procedure to the application user.

SELECT 'GRANT EXECUTE ON [dbo].['+ ROUTINE_NAME + '] to ApllicationUser'

...

To see more details about Indexable view please check this link.

http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx

You can look at Marathon clustering. Seems very efficient. But not sure of the performance. Set up is not easy. You get both Hardware and Software redundancy. Also it does...

I assume that your Data center has Generator that will kick in Automatically. Keeping the Servers in two physical location reduces your options.

Keep in mind that Clustering means both...

Did you try doing a derived table?

Something like this.

Select idt1,nme1,nmeP,varC, var_CD,nme_O from

(SELECT DISTINCT

M.idt1, M.nme1, M.nmeP,

R.varC, R.var_CD, O.nme_O, M.idt_P

FROM

fact_M M INNER JOIN

dim_R R ON M.sur_id_M = R.sur_id_M INNER...

Instead of editing the Index, Did you try updating the Stats of that table? Maybe the Statistics is outdated and that is why the query engine is taking a plan...

Because depending on the type of trigger if it fails it could roll back the transaction. Also you are making one more step to a normal transaction. (ie an Insert...

Writing a trigger would be the best way to go. Since triggers do not have that much over head in 2005 like it had in 2000, triggers shouldnt be an...

You could always use Dynamic SQL to do these kind of things. But be very very careful when using Dynamic SQL since this is one of the best way to...

Thanks Jack for completing my answer. I have to work on my answering skills. I always give the answer in a general form. Not specific to the question.