Paul,

Sorry for the late response.

That - is brilliant. Genious thinking. Thank you ever so much. I never thought of it quite like that.

I am not 100% sure...

However the question was still wrong as you still dont reference another column. You reference a UDF.

SQL Kiwi (1/31/2012)

---

Hugo Kornelis (1/31/2012)

---

There are good reasons why the only way to...

Nakul Vachhrajani (1/31/2012)

---

I disagree with the answers (2nd time in the same week). Here's why:

3. A hint overrides a SET option

4. A database option overrides an instance option and a...

I must admit i dont like the questions which contain trickery.

However on the flip side - its interesting to see how people have got round these limitations. ...

Ok - for the read uncommited (my first issue) i was planning on the stored procs that read the data for the reports to set it in there.

Dan

Ashish,

Sorry for which of my two scenarios are you sugguesting using nolock?

Thanks for your help

Dan

Thanks for all suggestions.

Unfortunately no i cant change front end. Only thing i have a chance to do is change what people type in - and you know how...

Hi,

If you read the data of a table that you have made changes to - you will see the changes even if they have not been committed.

To highlight this i...

paul.knibbs (12/16/2011)

---

Because doing a shrink will fragment the indexes again, thus...

Good article - quick question though.

If rebuilding the indexes can cause the file to grow - why not rebuild the indexes then shrinkfile afterwards?

Dan

If anyone is interested - the only way i could get rid of them was via the code.

Unless anyone has a better way? odd.

TIA

Dan

The plot thickens.

If i do this

CONVERT(DATETIME, PAD.AdditionalDetail1)

or this

CONVERT(DATETIME, PAD.AdditionalDetail1,0)

The problem goes away. However if i do this

CONVERT(DATETIME, PAD.AdditionalDetail1,101)

or

CONVERT(DATETIME, PAD.AdditionalDetail1,100)

It still errors.

The field has dates that ares...

Doh Sorry i worked it out. I didnt need the partition.

have a look here

http://msdn.microsoft.com/en-us/library/ms190324.aspx

Sad i know but i was actually quite pleased to have got the right answer on a multi choice with such a low percentage of right answers. I had...