Can you disclose the procedures, tables, indexes, execution plans and any other information related to the objects in question so that we can take a look.

Right, while the second shots are on and I have some time to myself I'm going to try and go back and get 70-450 polished off.

Anyone got any further reading...

Unfortunately I'm in the same boat, going to go back and do 70-450 in a couple of weeks if I can find the funds, failed it twice now with a...

Yes, follow the link i detailed in my original post.

Catalog is the reports that you have on the report server, so it is updated deleted when you add or remove reports.

The ExecutionLog2 view works off ExecutionLogStorage which is cleared...

Well if your LDF is on the E drive shrinking it isnt going to help your C drive.

Would seem to me like you need to get some monitoring on your...

Ensure SQL server service is running as a domain account

Give that domain account permissions on the share

Or

Backup to local disk, and run something like robocopy

Or

Map a network drive at backup...

CREATE TABLE [DatabaseFileUsage](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[DatabaseName] [sysname] NOT NULL,

[FileID] [int] NULL,

[FileSizeMB] [decimal](18, 2) NULL,

[SpaceUsedMB] [decimal](18, 2) NULL,

[FreeSpaceMB] [decimal](18, 2) NULL,

[LogicalName] [sysname] NOT NULL,

[FileLocation] [sysname] NOT NULL,

[DateCollected] [date] NULL,

CONSTRAINT...

SSDT is the new BIDS for SQL2012.

BIDS wont work with 2012 as SSDT is written in VS2010 not VS2008.

Your two options are correct, upgrade to 64 bit machines or get...

If you haven't put in custom auditing the only way would be to query msdb.dbo.backupset and compare the backup sizes, but it might not be a true representation depending on...

First why is the log on the C drive and not on a different drive?

What is the activity of the databases? Is it likely that the file will get...

If your any good at shredding XML, you can shred the ExtensionSettings column from the subscriptions table

Interview question?

one way

CREATE FUNCTION [dbo].[RemoveCharsVARCHAR](@Input VARCHAR(MAX))

RETURNS VARCHAR(MAX)

BEGIN

DECLARE @pos INT

SET @Pos = PATINDEX('%[^0-9]%',@Input)

WHILE @Pos > 0

BEGIN

SET @Input = STUFF(@Input,@pos,1,'')

...

Can you please provide DDL and sample data as per the second link in my signature so that we can help you out better.