At the same time I bought the book I mentioned earlier, I also bought

The Art Of War by Sun Tzu

http://www.amazon.com/exec/obidos/tg/detail/-/0486425576/qid=1070437222/sr=8-5/ref=sr_8_5/104-2394228-9088743?v=glance&n=507846

and

Emotional Intelligence by Daniel Goleman

http://www.amazon.com/exec/obidos/ASIN/0553375067/qid=1070437361/sr=2-1/ref=sr_2_1/104-2394228-9088743

To me a classics is

The Prince...

Sure you can do this, but read http://www.algonet.se/~sommar/dynamic_sql.html first and decide then if you want to.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

In addition to what Phil said, I think any good performance tuning starts with a good design. If this design is sub-optimal any performance tuning and tweaking is useless.

So...

???

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes, I know, it might sound nit-picking

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Could it be when opening the reply page or when returning from a thread to the active topics page the focus changes?

It happens that I start typing an answer and...

What are you trying to do?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Seems to be a problem with the loader engine

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Sorry, am I blind or does thread subject and article title not match?

I see 'What is denormalization' along with the articles about 'Indexed views'.

???

Frank

http://www.insidesql.de

http://www.familienzirkus.de

When you look at the execution plan, you'll see that this SET operation does a Constant Scan, which I guess *should* be pretty fast.

AFAIK a constant scan adds a small...

For data validation purposes, where is the difference between 1.2 and 1.20?

You can always use the char or varchar data type, but I guess that doesn't make your life easier...

Nothing like answering your own question.

Yes, even on the start page.

I got confused, because I have the german and the english version installed.

I didn't see it in the german...

Even on the start page?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Btw, just tried for the first time from the BOL start page the 'SQL Server Printed Documentation'.

Could it be it isn't valid?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

When you open BOL and click on the 'SQL Server Books Online' link and then at the bottom of that page on the '©1988-2002 Microsoft Corporation. All Rights Reserved.' link...