Viewing 15 posts - 136 through 150 (of 479 total)
Ray Herring (3/6/2009)
I agree with BitBucket. The results described at what you would expect in "normal" operations (assuming the typo is corrected)
I understand the sections BitBucket quoted, but can't...
March 6, 2009 at 8:45 am
Bitbucket,
Irish Flyer has already stated the fact that was confusing me.
From the way your scenario was stated, the second script did not commit its changes. Hence I wrote my tests...
March 6, 2009 at 6:07 am
Lynn Pettis (3/5/2009)
Bob Hovious (3/5/2009)
Why, O Ming, why?Oh, geez, great. Now Queen and the theme from Flash Gordon are going through my head....
Now, I've got it running through my...
March 6, 2009 at 5:04 am
Putts (3/5/2009)
WF_STOP index is not helping either .....
I has a suspicion it might not help as it was common to all queries. Did you check if the plan changed at...
March 6, 2009 at 3:34 am
GilaMonster (3/5/2009)
Derek Dongray (3/5/2009)
Also I'd be interested to see the source of the User-defined function FFG_FX_JUST_DATE since, although it doesn't add the the estimated cost
Scalar functions never do. It's one...
March 5, 2009 at 12:31 pm
Putts (3/5/2009)
Derek was working off the code on page 1 .... I'll go back and modify that to say "read page 4"
My settings are different. 🙂 It's all page 1...
March 5, 2009 at 12:29 pm
Putts (3/5/2009)
Derek Dongray (3/5/2009)
Looking at the plan....
Sorry for a bit of confusion, Derek, but have brought up a new query that is doing something very similar here on page 4....
March 5, 2009 at 12:24 pm
Looking at the plan, 73% of the estimated cost comes from 2 joins and a 'not null' filter, which I've reconstructed as
Select
AUND.AUND_INBOX,
RPT_SQL_CL.dbo.FFG_FX_JUST_DATE(A.WF_START) as Expr1007
from
RPT_SQL_CL.dbo.IREP_T_WF_INFO as A
right join -- 13,988,837 rows...
March 5, 2009 at 11:31 am
Take a look in Books Online at the system procedures sp_add_job, sp_add_jobstep, sp_add_jobserver, sp_start_job and (probably) sp_delete_job.
Something like...
use msdb
exec sp_add_job
@job_name = 'Test 1'
declare @cmd varchar(100)
--
-- Command value was simply...
March 5, 2009 at 9:52 am
You need to repost or edit your message to get the XML to show.
The SqlServerCentral message editor is not friendly towards XML.
To post your message, create it in another editor...
March 5, 2009 at 9:19 am
Can someone clarify the question and answers here please?
The question is asking what isolation the database is set to, but the answers are transaction isolation levels.
Firstly, where is the isolation...
March 5, 2009 at 8:10 am
Jeff Moden (3/4/2009)
That's an extremely old... and slow trick. The DATEADD/DATEDIFF method is quite a bit faster.
That explains why I hadn't seen it before.
Mangal presumably tells posters on MSDN...
March 4, 2009 at 4:52 pm
I skimmed over most of Mangal's blog posts and felt that there wasn't much there which I hadn't come across elsewhere. Nothing wrong with that really (although it hardly seems...
March 4, 2009 at 4:26 pm
GilaMonster (3/4/2009)
Nobody requires that his posts be detailed (or even right?).
Correct and helpful are required. I know I got asked for several forum posts where my answers helped someone
Actually,...
March 4, 2009 at 9:58 am
Viewing 15 posts - 136 through 150 (of 479 total)