Viewing 15 posts - 11,746 through 11,760 (of 19,560 total)
Has anybody here contemplated changing their name (besides bob err ".") for the forums? I am curious if anybody much cares about the confusion that may drive.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 2:57 pm
What indexes do you have defined on that table?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 2:55 pm
Let's step back - what is the state of both databases? Are these two databases already in existence and do they serve production data?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 2:52 pm
Yes
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 1:05 pm
Then this
with lastactivity as (
select ca.case_id as case_id,max(ca.activity_datetime) as activity_datetime
From case_activities ca
Inner Join Cases c
on c.case_id = ca.case_id
where c.case_id = ca.case_id
and c.case_status = 'active'
and ca.activity_datetime < '10/01/2009'
Group by...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 1:04 pm
Craig Farrell (11/4/2010)
Greg Edwards-268690 (11/4/2010)
CirquedeSQLeil (11/4/2010)
GilaMonster (11/4/2010)
CirquedeSQLeil (11/4/2010)
GilaMonster (11/4/2010)
Gianluca Sartori (11/4/2010)
Nothing to complain about today?Plenty, but I think most people are tired of hearing me whine about the Nightmare Project.
Nah...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 12:55 pm
Greg Edwards-268690 (11/4/2010)
CirquedeSQLeil (11/4/2010)
GilaMonster (11/4/2010)
CirquedeSQLeil (11/4/2010)
GilaMonster (11/4/2010)
Gianluca Sartori (11/4/2010)
Nothing to complain about today?Plenty, but I think most people are tired of hearing me whine about the Nightmare Project.
Nah - do...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 12:54 pm
My vote is for backup and restore.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 12:52 pm
It seems to be that the subquery is a bit extraneous - or am I missing something there.
select p.first.name,p.last.name,c.case_status,c.program.type,c.counselor,ca.activity_datetime,ca.activity
from participants p
inner join cases c on p.participant_id = c.participant_id
inner...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 12:50 pm
WayneS (11/4/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 12:39 pm
Please provide us the DDL and sample data. We can't legitimately test a solution without knowing this information.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 12:38 pm
GilaMonster (11/4/2010)
CirquedeSQLeil (11/4/2010)
GilaMonster (11/4/2010)
Gianluca Sartori (11/4/2010)
Nothing to complain about today?Plenty, but I think most people are tired of hearing me whine about the Nightmare Project.
Nah - do tell.
Let's just say...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 11:56 am
Ray K (11/4/2010)
Gianluca Sartori (11/4/2010)
So it seems.Nothing to complain about today?
I think you spoke too soon.
http://www.sqlservercentral.com/Forums/FindPost1016045.aspx
Mr. Celko, please go away. The question was obviously answered, DDL or not. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 11:35 am
Easy - since the ceilings are 12ft, we used our compound bow with a shoe mounted to the end of an arrow - and shot the shoes at the ceiling.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 11:30 am
I have scripted the backup and restore from one server to another. We use native SQL for the backup and for the restore. I restore from a file...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2010 at 11:29 am
Viewing 15 posts - 11,746 through 11,760 (of 19,560 total)