It seems that a small change to the TSQL select statement will make the query much slower. Just adding one more (int) field to the output column list causes a...

You aren't limiting the list to a particular type of backup (Full, Differential or Log)... is this really what you want?

I suspect the script should include AND Type = 'D'

... which is progress of a sort.

Can you post the DDL for...

GSquared (9/2/2009)

---

To reiterate, what you're looking at is a classic example of parameter sniffing. At least, I'd bet 9:1 that's the problem. Take a look at Gail's blog...

Darn... Just a hunch, but I remember seeing a case (on SQL2000) where a parameter of Bigint for...

What is the datatype of ReadingID in the table?

Does it match the datatype of the SP parameter?

Not sure what your question is, but...

The error message you are getting means that SQL Server is trying to replicate an UPDATE or DELETE command to the subscriber database, and...

I doubt anything's wrong, the SP2 you're refering to is going to be the OS version, not the SQL Server version.

What do you mean here?

I'm certain I have added files...

From a SQL point of view, you can't improve the performance... selecting all columns from all rows in a table will just have to read all the pages allocated to...

From a performance perspective... they are the same. Have a look at the query plans, and you will see that they should be the same.

The second type query has been...

Lynn Pettis (8/22/2009)

---

Hopefully by treating them in this manner they may change how they act as well. Unfortunately, we know that won't always work, but hey, if you don't...

How about posting a list of "stroppy" posters?

I'd hate to accidentally help anyone whose is rude and ungrateful or just plain unwilling to make an effort themselves.

Anybody who is willing...

Yes, it's possible using the WITH MOVE part of the restore command e.g.

RESTORE DATABASE DB11NEW

FROM DISK='{drive\path}\DB11.bak'

WITH

MOVE 'DB11_Data' TO '{drive\path}\DB11NEW.mdf',

MOVE 'DB11_log' TO '{drive\path}\DB11NEW.ldf'

(assuming DB11_Data and DB11_log are the logical...

And when you've done what Gus suggests, it's worth reading Gail's article on managing the transaction log http://www.sqlservercentral.com/articles/64582/