Did you bother to read the article I linked?

For the UK residents, what are my travel options for Birmingham -> Swansea?

Not yet certain if that's where I'll go, but may well be a place to start.

The DMV only contains stats for procedures whose plans are still in cache, so if the procedure hasn't run since SQL last started or the plan has since been aged...

If the index needs the clustering key to support the queries, explicitly add it. Don't rely on implicit behaviour.

So, an index for that query will be (Col1, ID) INCLUDE (Col2)

Take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/

It won't be due to CheckDB, it makes no changes to the DB.

Look for other stuff that changed. Make sure stats are up to date, the usual performance troubleshooting.

TomThomson (4/25/2014)

Steve Jones - SSC Editor (4/24/2014)

On the shed-dyule for Bits, and planning on it....

And possibly indexes as well.

As for data, offhand I...

sysdatabases is deprecated and should not be used any longer. It's included only for backward compatibility with SQL 2000

Use sys.databases instead.

Original where clause predicate:

isnull(PF.Spend, 0) != 0

So, if any row has NULL for Spend, make that 0 and then look for rows where the resultant value is not 0. i.e....

If you change the database's default collation, then all that will happen is that new tables get the new collation by default. Nothing else changes.

If you want to change the...

What's the reasons behind the split? What are you trying to achieve?

Please in future start a new thread for your questions. Thanks

Start by tuning the queries. Partitioning is not a silver bullet.

Can't do much without these

There's no such thing. A log file size is dependant on transactional workload, recovery model and log backup...