DBCC CHECKDB uses the tempdb to store work tables whilst processing.

Is it possible that the drive hosting your tempDB could have run out of space when you ran DBCC CHECKDB?

You...

Hi,

Shrinking the log file does not alter the LSN or break the existing chain, thereby leaving the log sequencing intact.

Truncating the log file, on the other hand, does impact the...

Hi,

I am struggling to understand your example so perhaps you could qualify it a little further please.

What relates (ABOSS) to (A1) in order to create (ABOSS - A1)?...

Hi,

The Wikipedia article is also quite good for determining the differences between the various join types quickly. It also includes examples and source code.

http://en.wikipedia.org/wiki/Join_(SQL)

Cheers,

Hi,

I would suggest following the previous recommendations with regard to determining and developing an understanding of how your data structures are being affected/used.

Reviewing the statistics for the indexes of your...

Hi,

Would it possible to post the source code please.

If the prior posters recommendation does not improve things, I am wondering if perhaps you need to look into performing more focused...

I am having issues with this also.

The syntax Error appears to be in the filepath to the SSIS package that is used to execute the maintenance plan.

If you go into...

I would just like to make one small point regarding all of these brain dumps\question banks that are floating around the internet.

If you are looking for a quick fix/shortcut to...

An excellent article that I really enjoyed reading, so thank you for sharing it with us. I particularly like your clear and logical writing style.

I look forward to reading more...

An excellent article and thank you for sharing it with us.

It would be great if you could also make available the Excel document that you describe.

Cheers,

Sorry 😀

Not really a...

Hi Shaun,

Please do post your script.

Cheers,

Thanks Andy!

Hi,

If you have an identity...