Viewing 15 posts - 41,071 through 41,085 (of 49,571 total)
Bob Hovious (2/13/2009)
The gurus here might have better insight into what the next frontier should be than his professors.
Agreed. I chatted with lots of people before picking my master's thesis,...
February 13, 2009 at 8:47 am
Grant Fritchey (2/13/2009)
There's a blog post. Do you get it or do I?
Why not both? (Like we did with the table-valued functions)?
I'll write one over the weekend. Title's written,...
February 13, 2009 at 8:41 am
llokshin (2/13/2009)
Thank you for your reply, actually I am looking for a tool that will use both, logs and trace.
Why? Logs, while they can be used for some autiting, are...
February 13, 2009 at 8:40 am
Sorry, shouldn't have used the term 'estimated'. I seem to have confused everyone. I'll explain better.
The terms estimated and actual for plans are actually a bit of a misnomer. A...
February 13, 2009 at 8:21 am
Chris Morris (2/13/2009)
February 13, 2009 at 8:20 am
Phillip Cox (2/13/2009)
February 13, 2009 at 8:10 am
Codezilla (2/13/2009)
If I need to keep my job, it has to complete atleast in about 4 hours.
Then start writing up your CV.
There is nothing that you can do to...
February 13, 2009 at 8:05 am
sun_kuang (2/13/2009)
What do you mean vulnerable to SQL Injection, sorry I'm new to these?
Google SQL injection. If you're working with dynamic or ad-hoc SQL, you need to be aware of...
February 13, 2009 at 6:05 am
You can get the actual plans from profiler. I don't recall offhand what event it is, so check Books Online.
Ok, so they are parameterised, which means the optimiser should be...
February 13, 2009 at 6:02 am
Where Session IN (''' + @Session + ''')'
By putting quotes around @Session you're treating it as a string literal, not as a variable.
Why dynamic SQL for this?
Are you aware...
February 13, 2009 at 5:46 am
Ken Gaul (2/13/2009)
SELECT [TransID], [LedgerDate], [ClAccountID], [subclaccountid], [LineNumber], [MovementType], [MovementSource],
[CCYCode], [Amount], [Balance], [Reference], [Narrative], [DisplayToClient], [Capital], [ProductCapital],
[UserID], [DateCreated], [LedgerSource], [LedgerSourceID], [FromCCYCode], [ToCCYCode], [BaseCCYCode], [FXRate],
[RestrictSweepUntil], [AdjustmentUserID], [ProductType], [ProductDisplayName],...
February 13, 2009 at 5:37 am
Those are estimated plans. They don't have the information that I need. Please can you capture the actual plan and post that.
There's no way to identify a stats issue from...
February 13, 2009 at 5:34 am
Dan Puiu (2/11/2009)
I tried everything:I can't get rid of SOS_SCHEDULER_YIELD wait type.
Any clues?
Have you tried optimising the queries involved? (and I don't mean applying query hints)
February 13, 2009 at 5:03 am
Codezilla (2/13/2009)
thanks for your replies. It currently is telling me that it has 10 hours to recover. But I am not sure if we could wait untill then.
You...
February 13, 2009 at 4:59 am
Ken Gaul (2/12/2009)
OK thanks, that surely can't be right though!
It does tend to happen with date columns, especially when the column in question is defaults to getdate and queries...
February 13, 2009 at 4:53 am
Viewing 15 posts - 41,071 through 41,085 (of 49,571 total)