Thank you Prasad!

This was making me go insane. The update you posted was the specific fix I needed as I am using a HP computer. I also changed the...

There are a couple of issues I found with the script Chris.

1- If there was no BEGIN after the AS at the beginning of the SP then the WITH ENCRYPTION...

Hi Dewes,

I'll try and explain this in layman's terms, as these are the terms I understand.

This issue is not uncommon I believe. Collation's describe the ordering of data within...

To my dismay, our company is also having problems dealing with this setting. Our company has been using ANSI Padding OFF as our standard (I'm not sure why, but it's...

Thanks for the great check list, but i also want to take some of your other advice that this doesn't substitute reading books and white papers on SQL Performance. Can...

thisisfutile (3/11/2010)

I too have the same curiosity....

Richard,

Thanks for your constructive input; not including the schema was a definite flaw. Your suggestion for Table Row count has also improved performance on the database I'm using to test...

To answer your concerns Flavio, I agree the creation order of views needs to be explicit due to dependencies if one view does depend on another, but the order of...

The way we document database objects as well as any comments of SQL code changes is something we have recently changed at our organisation. I won't go into what we...

Thank guys. I stumbled over your forum and found that I have the exact same problem as Brandie. I needed a new Data Model app that could replace Erwin. I...