Here's an article on how to do that

http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/

West Side

If you feel you must move them, then script out the drop statements for the FKs, script out the table move to the new filegroup, and then script out the...

Quick article on how to do this here

http://saveadba.blogspot.com/2012/02/move-clustered-index-new-filegroup.html

You can probably get better performance by creating an index on intID and bintTimeStamp.

But you really should not do select * in these queries for better performance.

alan_lynch (3/8/2013)

---

ok I seem to have got a little further with the deploy thing past the permissions problem I am now facing another problem which is

Cannot deploy the report because...

Whip

GilaMonster (3/8/2013)

---

UncleBoris (3/7/2013)

---

Very happy to be corrected but is it true that the Log Chain is only interrupted by the full backup IF the backup regime does Differential backups?...

mtassin (3/8/2013)

---

Well.... probably.... I got it right... I noticed the backwardsness... but the other two were obviously wrong... always...

Christian Buettner-167247 (3/8/2013)

---

I like the question as it leads to some interesting observations 🙂

Upfront: The MSN article is for SQL Server 2000! Here is the link to the version for...

Which Patch level of 2012 are you running?

RC0

RTM

or SP1?

I ran into an issue like this on a Win7 box with RC0 that was excessively frustrating. In the end, I...

And please post index definitions.

The size of that database is not preventing your instance from starting. Check the logs and see if you have another error when you try to start the service...

What is the error?

What is the message from the maintenance plan log?

Manually grow your log file (it seems your instance is started since you were able to retrieve those db settings already).

USE [master]

GO

ALTER DATABASE [DatabaseName] MODIFY FILE ( NAME = N'DATABASENAME_Log',...