You need to rename the logical name after completing the restore.

Well, to really help we will also need the DDL (create table statements) for the tables in the query, sample data for the tables that reflect the problem you are...

dun (8/27/2009)

---

Yes, the MCTS 70-431 on p605 does say "You cannot create Database Snapshots against system databases." The MSKB at http://support.microsoft.com/kb/920926 does not have any errata for this page to...

Lynn Pettis (8/27/2009)

---

Well, if he's like the OP who basically called me...

Well, if he's like the OP who basically called me a "liar"...

David. (8/27/2009)

---

This demonstrates that the datediff solution does not change the age at the time of the birthdate. All the age results are the same:

declare @BirthDate DATETIME

set...

I'm curious how this would be done considering the metadata for the table(s) or table partitions is contained in the system tables in the primary file group in the .mdf...

Okay, it has to be something in the air. It seems that some of the OP's here don't like our answers and will argue it.

This time an OP took...

FredS (8/27/2009)

---

I was able to make it work, but I have no idea if it is stable or a good idea.

ALTER PROCEDURE [dbo].[IH_GetRecords]

@Area char(15)

,@AreaKey Int

AS

BEGIN

-- SET NOCOUNT ON added...

If you need help with performance tuning a query, please read the second article in my signature block regarding "tips to get better help with Performance Problems." Following the...

john.arnott (8/26/2009)

---

ta.bu.shi.da.yu (8/26/2009)

---

That search has since...

Or:

with RowNumbered as (

select

row_number() over (partition by Data1 order by Data2 asc) as rownum,

Data1,

Data2,

Data3

from

...

If this is a test/development server, try the following before each run of your query:

dbcc dropcleanbuffers

dbcc freeproccache

What are your results then?

And I will say it again. CACHING!

I realize I only gave a partial answer, but to essentially be called a liar? Anyone else want to tackle this one?