Please don't cross post. it just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic813034-1632-1.aspx

Please post table, index definitions and execution plans. Take a look through this article: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Also, take a look at that article, about narrowing down exactly where the performance problems speciofically...

It's not growth that affects the fill factor. It's...

What are you waiting for?

Absolutely false. Dynamic SQL has its plans cached...

As I said, it depends. It depends purely on the queries...

It depends.

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Replies to: http://www.sqlservercentral.com/Forums/Topic812740-266-1.aspx

Please run the following and post the full results:

DBCC CheckDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

HowardW (11/3/2009)

---

You don't need to use dynamic sql. The easiest way to do this would be to have two select statements and an if else to decide which one to...

C Schaefer (11/2/2009)

---

You CAN export tables from SQL2005 to SQL2000. I just had to do that last week. May or may not give you the results...

Is "E:\DBLogs\modellog.ldf" the correct location of the model database log? If not, move the ldf file there.

Again I ask, how did you move the system databases?

Which dbs did you move? Exactly what did you do to move each one?

Find the SQL error log (it's a text file called ERRORLOG) and post the entire contents.

Once more with feeling....

Memorising interview questions is not the way to prepare for an interview. A competent interviewer can tell someone who knows the material from someone who's memorised answers...

Can you post execution plans?