Sure sounds like something is broken in the backup file:

SQL error 3241: SQL error 3241: The media family on device 'SQLBACKUP_273C82FD-3412-49B2-9669-42A275B6845802' is incorrectly formed. SQL Server cannot process this media...

By stating SELECT *, you're asking for everything. The only way to not get everything is to explicitly state what you want as the others have already said.

But, you can...

Glad I could help. I hope the book...

This is the cause of the Remote Scan, not the CTE:

INSERT INTO #tagData SELECT * FROM OPENQUERY([scada-02],'SELECT * FROM usascada.dbo.FloatTable');

What I'd suggest is putting some filters into that SELECT statement...

Welcome!

Those are very likely to be detritus from the Database Tuning Advisor. Why they are there? Hard to say, but it's likely that someone was running the DTA and had...

You have to remember that views (except for indexed views) are just the underlying query. There is no special construct or nifty thing going on with them. Sometimes, the optimizer...

GilaMonster (6/9/2010)

---

Grant Fritchey (6/9/2010)

---

At the point of a delete or insert, you do have access to the deleted & inserted temporary tables that will allow you to see what was...

The reason I used to do this in the past usually broke down into two scenarios. Scenairo #1, way too many columns to make up a single table, so I'd...

2500 stored procedures is a little difficult to maintain. 40 is nothing.

No, I wouldn't recommend jamming all the code into a single procedure. In fact, I'd recommend, as much as...

It depends too much on what you want to do with the data. If you're just storing it as is, no modifications, will that satisfy these future reports? Or do...

At the point of a delete or insert, you do have access to the deleted & inserted temporary tables that will allow you to see what was deleted or inserted,...

I work for a fairly large insurance company and we have SA's responsible for the OS and the Servers and the disks and all things configuration oriented. It works out....

An excellent question, and comparing it to writing a book is pretty apt. I suspect, more than anything, it's a personality trait that drives a person to do that kind...

Steve Jones - Editor (6/5/2010)

---

In a source control session at SQL Saturday #22. Surprising that quite a few people don't use an VSC for their SQL Code.

What do you guys...

dbowlin (6/3/2010)

---

I am working through the information from Blythe. We...