Hey all, have a look at these two articles.

http://www.sqlservercentral.com/articles/Performance+Tuning/howdynamiccanstaticbe/631/

and http://www.sqlservercentral.com/articles/Performance+Tuning/howdynamicsqlcanbestatic2/684/

An nice fancy way of building SQL using case statements and it covers select, where, joins and...

Hugo, Sorry if you thought I was trying to enter into a flame war, that was not the intent.

To all others that have read my previous post and feel I...

Trick questions are the reason I rearely bother with QOD. It woudl be great to learn things but when there is so little information and only a mention of...

Hope it all works and makes sense now. Don't worry about Joe, I completely agree with him and at times we all want to rant in the same manor....

Have a look at Brad McGehee's latest article on server documentation. It is fantastic and has a lot more than what your current needs are

http://www.sqlservercentral.com/blogs/aloha_dba/2012/06/05/do-you-document-your-sql-server-instances/

As minALTID is a derived column and does not eist in the context of the group by it woudl requrie the same derivation within the group by. Look forward...

OK, so what your are really saying is you have two servers that need their data to be synchronised on a weekly basis. This is not querying and there...

A couple of issues. You have two tables aliased as S, the master table in the first from and the sub query, hence the MSG 101. Secondly the...

Wow, did a google search and there was no mention in any of the four posts I checked about the count_big so I got it wrong. Nice Q and...

Books on-line, the SQL help files, cover all of this and more. There are also articles on this site on index basics.

Search the site or try this link

Thanks Jeff, they're just the sort of hints and tips I love getting.

I believe the details in these articles will help, I don;t fully understand how they work but they work a treat.

http://www.sqlservercentral.com/articles/Performance+Tuning/howdynamicsqlcanbestatic2/684/

http://www.sqlservercentral.com/columnists/rmarda/howdynamiccanstaticbe.asp

Your poblem is probably related to the "select *" stuff. When SQL creates the view with select * it creates the view in the underlying DB engine as select...

Difficult to understand the question. The sele3ct clause itself only takes UDF, fields or constants. Q query may include and order by clause but select itself is a...

bkubicek (10/3/2011)

---

A thread is someone's question correct? So if I respond to a thread, I don't necessarily want to be emailed when other people respond to the same thread...