The error is happening here:- on t2.vp_name=bp.id

vp_name is a VARCHAR and ID is a UNIQUEIDENTIFIER

Can you just change the destination of the backup files to a different location so that they do not overwrite any files that are already there?

If you database is in the full recovery mode, you need to be taking regular log backups.

Where are you getting the 12% free space figure from?

For an index that small I really wouldn't worry about fragmentation, it won't affect performance.

Also the script you posted just returns the fragmentation of the indexes, it won't rebuild them.

Looks like it but there are loads of other resources for the new features in SQL Server 2014. Have a look online.

Have a look here:-

http://borntolearn.mslearn.net/btl/b/weblog/archive/2014/03/10/certification-update-sql-server-2014.aspx

It says that the existing 2012 MCSE exams will be updated to include features from SQL 2014. Click on the links to go to the inidividual exam...

For the hour behind use:-

SELECT

SampleDate,

CAST(SampleDate AS time),

SampleID

FROM

DateTimeQuery

WHERE

CAST(SampleDate AS time) >= CAST(DATEADD(hh,-1,GETDATE()) AS TIME)

AND

CAST(SampleDate AS time) < CAST(GETDATE() AS TIME)

Try that and see if you still...

Microsoft documents what issues each update addresses in full, see here for SQL Server 2014 CU2:- http://support.microsoft.com/kb/2967546

Read through the document and see if any of the fixes would address...

Here you go:-

SELECT

SampleDate,

CAST(SampleDate AS time),

SampleID

FROM

DateTimeQuery

WHERE

CAST(SampleDate AS time) >= CAST(GETDATE() AS TIME)

AND

CAST(SampleDate AS time) < CAST(DATEADD(hh,1,GETDATE()) AS TIME)

If you perform an in-place upgrade then no, the instance of SQL Server will be taken offline for the duration of the upgrade. I would not recommend this approach as...

Does your transaction table have a column that records when the transaction was made?

If so it should be fairly easy to limit the result set to just the current day.

Completely agree that it depends on what type of DBA you are. We have a dedicated Data Warehouse Team here so I don't really interact with the DWH database on...

Safest way is through the SQL Server Configuration Manager.

Right click the database engine service and choose stop. Be aware this will immediately stop the service!

No worries! Completely agree, having to specify where in the XML the value comes is a bit of a pain.

I'm not sure of you can pull out all the values...

Without knowing your database schema I can't really write you a script to manage your partitions.

I would recommend that you do some research, write a script yourself and then test...