Wintop,

Are you an Oracle guy or SQL? (Or both)

I see you are in Melbourne, Australia. I thought the IT employment situation over there was quite good these days, have things...

Hello,

Yes, set up a lab at home, that's always good whatever your doing. I am going to make the assumption that you are looking for a permanent position, but if...

Thanks Gail.

Regards,

P.

Hello,

Sorry if I am highjacking the thread slightly, but I'm in a similar situation, however I am going to go ahead and take the exam regardless, what I am wondering...

Thank you, Gail.

Regards,

D.

Hello,

Just to complete the tread, the increase to the cost of parallelism from the default 5 to 40 did in fact solve my issue. I will still be putting an...

Hello,

The query did indeed return 0 rows, so I will add a clustered index and see what happens. I will also change the parallelism as well, I will leave a...

Hello Howard,

The session table has no indexes. Its always functioned ok in the past, this problem appears to have come out of nowhere. I'm not sure how to find out...

Ah, I was just reading about that in the link that Howard sent through, my server is indeed set to 5, so I shall change it, before I do does...

Hello,

Thank you both so much for getting back, I have attached the dead lock graph as requested. Sorry, it comes out a bit small.

Regards,

D.

Hi Jerry,

Thanks for getting back, but I have everything you mentioned covered already. I am no closer to working out why I have this issue.

Regards,

D.

Hello Lee,

What would be a good idea is to buy a beginner book both in SQL administration and in T-SQL, then get yourself the developer edition of SQL Server from...

What happened in the end?

Regards,

D.

Just want to say a thank you to you all for replying to my post and giving some good advice, I'll be setting those alerts up very soon.

Regards,

D.

Hello,

In case anyone out there has the same issue, I dont want them to get to the end of this thread and find no resolution, so I'll just say that...