Trust me: losing backups is much more expensive than SAN disks.

If you back up your SQL Server to the same machine where the server runs and the server fails, you...

You could post your solution then: it would benefit future readers that run into the same problem.

A possible solution is to get...

What does "use LOOP" mean? Can you please clarify?

Backing up to a local disk is a terrible idea. Why do you think you need to do that?

Raising the logging level show you some warnings that you can safely ignore. I would revert to the original level.

Try this registry change to enable additional logging to a file:...

LIKE would do as well:

WHERE ex NOT LIKE '%[^A-G0-9]%'

OUCH! I missed this part...

BTW, partitioning is an enterprise-only feature.

Looks like a good place for partitioning. If you can make your table partitioned on the predicate you use for deletes, gettin rid of that data can be a simple...

OK, it looks like the data is not there or is not accessible.

Same places to look for information:

-- From the monitored server

SELECT * FROM msdb.dbo.syscollector_config_store; -- this shows you if...

I strongly suggest starting another thread for your question.

Post back the url here and I promise I will try to help you.

You could compute changes to the clustered index as updates to the table (insert/delete/update).

I have a script here: http://spaghettidba.com/2015/04/20/tracking-table-usage-and-identifying-unused-objects/

Save index usage stats on a daily basis and compare with the...

The configuration is stored in the RSreportserver.config file. It's not trivial to shred the file in T-SQL, nor I think it's the right tool for the job.

xsevensinzx (5/8/2015)

---

GilaMonster (5/8/2015)

---

xsevensinzx (5/8/2015)

---

What if you are allowed to have duplicates with transactional records that have customer ID's which forms the relationship? What purpose is the PK giving you outside...

Please post the actual code, otherwise it's impossible for us to help