Thank you for the question

Iulian

Thank you for the question

Iulian

It is a string comparation.

Dates comparation might be:

IF (CAST( '2011-07-31 00:00:00.000' AS DATETIME) BETWEEN CAST( '2011-07-01' AS DATETIME) and CAST( '2011-07-31' AS DATETIME) )

PRINT 'Yes'

ELSE

PRINT 'No'

Regards,

Iulian

and I am sorry about your mater db 🙂

Thank you Hugo, now I understand better not only the sql exercise of the qotd

but also the exercise of making a good question.

Well done! I hope to see more...

After doing the calculation I was tempted to answer the queston but to be sure I ran the script and got the error:

The statement has been terminated.

Msg 1101, Level 17,...

Thanks for the question

Iulian

Thank you for the question.

Regards,

Iulian

Page splits might be due to index fragmentation

Iulian

First you need to create the connection here is a step by step approach: http://www.bidn.com/blogs/kylewalker/ssis/997/setting-up-an-ssis-package-with-a-dymanic-excel-source

Then you need to loop through the files and here is also a step by step...

Starnge, I though so too.

But look what I found here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=124332

It seems that the SSMS 2005 does not show the DTS package logs but you still can query...

Thank you Ninja's_RGR'us and GilaMonster for the very good examples: charts with aproximate values and session tables.

Jared I don't think that NOLOCK can generate the timeouts you...

What is happening if for example there is one table that updates on a daily basis,

another table that updates every hour and there is a query that joins the...

I think it depend on how often the data does change. If it is updated, let's say, once a day I would see no issue in using With(NoLock).

Regards,

Iulian

Thanks Philip, 🙂 now I see it. They thought at this one too isn't it?

Regards,

Iulian