Viewing 15 posts - 18,991 through 19,005 (of 26,484 total)
You need to rename the logical name after completing the restore.
August 27, 2009 at 10:34 am
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...
August 27, 2009 at 10:31 am
dun (8/27/2009)
August 27, 2009 at 9:32 am
Lynn Pettis (8/27/2009)
GilaMonster (8/27/2009)
Lynn Pettis (8/27/2009)
This time an OP took exception to Gail's answer.I wonder how long he's going to protest.
Well, if he's like the OP who basically called me...
August 27, 2009 at 9:06 am
GilaMonster (8/27/2009)
Lynn Pettis (8/27/2009)
This time an OP took exception to Gail's answer.I wonder how long he's going to protest.
Well, if he's like the OP who basically called me a "liar"...
August 27, 2009 at 9:03 am
David. (8/27/2009)
declare @BirthDate DATETIME
set...
August 27, 2009 at 8:57 am
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...
August 27, 2009 at 8:43 am
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...
August 27, 2009 at 8:39 am
FredS (8/27/2009)
ALTER PROCEDURE [dbo].[IH_GetRecords]
@Area char(15)
,@AreaKey Int
AS
BEGIN
-- SET NOCOUNT ON added...
August 27, 2009 at 8:31 am
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...
August 26, 2009 at 8:53 pm
john.arnott (8/26/2009)
ta.bu.shi.da.yu (8/26/2009)
Lynn Pettis (8/26/2009)
I realize I only gave a partial answer, but to essentially be called a liar? Anyone else want to tackle this one?
That search has since...
August 26, 2009 at 8:47 pm
Or:
with RowNumbered as (
select
row_number() over (partition by Data1 order by Data2 asc) as rownum,
Data1,
Data2,
Data3
from
...
August 26, 2009 at 4:40 pm
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?
August 26, 2009 at 4:18 pm
And I will say it again. CACHING!
August 26, 2009 at 4:13 pm
I realize I only gave a partial answer, but to essentially be called a liar? Anyone else want to tackle this one?
August 26, 2009 at 3:41 pm
Viewing 15 posts - 18,991 through 19,005 (of 26,484 total)