Viewing 15 posts - 41,056 through 41,070 (of 49,552 total)
Chris Morris (2/13/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2009 at 8:20 am
Phillip Cox (2/13/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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],...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2009 at 4:53 am
Codezilla (2/13/2009)
I I need to get this up running say in about 2 hours. Is there any other way, to do this other than waiting for the recovery to complete.
No....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2009 at 4:42 am
No log reader tool is going to do what you want, because selects are not logged. To get all operations, including selects, you'll need to use a profiler trace or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2009 at 2:57 am
It will result in more usage or TempDB. MAke sure that it's capable of handling additional load. Test on a non-production system first.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2009 at 2:45 am
SQL_Easy_btn? (2/12/2009)
I would get rid of the WHERE clause.
I wouldn't.
The case has no else clause. That means any value that doesn't match any of the case conditions returns NULL....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2009 at 2:44 am
Viewing 15 posts - 41,056 through 41,070 (of 49,552 total)