Viewing 15 posts - 12,346 through 12,360 (of 49,552 total)
Can you please tell me that when we have to use NOLOCK option as it gives us inappropriate data in result?
You don't have to use it. There's no situation ever...
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
July 17, 2013 at 1:45 am
Khalid Hanif-458693 (7/16/2013)
I need data ordered by how sql orders it.
SQL doesn't order it, that's what people are trying to tell you.
There is no default ordering. There is no concept...
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
July 16, 2013 at 4:34 pm
TUellner (7/16/2013)
(which I presume is the time spent generating the plan).
That's the time spend by SSMS rendering the plan, before it runs out of memory (or hits max resultsets)...
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
July 16, 2013 at 4:25 pm
SQLisAwE5OmE (7/16/2013)
Latch = is a type of lock you place in buffer cache
No.
locks = are placed against resources.
No.
Maybe take a read through the search links I posted above.
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
July 16, 2013 at 2:29 pm
Or you could just remove the nolock hints entirely and remove any chance of their nasty side effects causing you problems.
See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
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
July 16, 2013 at 1:41 pm
Firstly, you didn't answer my question. Previous and next as defined by what column. What column tells me that a row is the next one?
Row number does not force table...
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
July 16, 2013 at 10:58 am
Luis Cazares (7/16/2013)
What about using simple recovery model? Am I confused here?
He's asking (afaict) for reasons not to truncate the log. In simple recovery, the log is automatically truncated, so...
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
July 16, 2013 at 10:29 am
RTaylor2208 (7/15/2013)
iii.SQL Server: Buffer Manager: Buffer Cache Hit ratio should exceeed 90% preferably 99%
Buffer cache hit ratio is a near-useless counter. By the time it shows a noticable drop,...
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
July 16, 2013 at 10:02 am
Best option, no. If management is screaming that 'something must be done', then you can rebuild but it probably won't have a noticable effect (unless the problem was due 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
July 16, 2013 at 9:52 am
http://www.google.com/search?q=sql+server+locks
http://www.google.com/search?q=sql+server+latches
Lots and lots of info there
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
July 16, 2013 at 8:10 am
ramyours2003 (7/16/2013)
what are the possible reasons when a query is timed out ?
The query took longer than the application's timeout setting.
what are the possible reasons for not truncating...
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
July 16, 2013 at 7:37 am
Define 'previous' and 'next'? Tables have no order, so what column is the one that defines which row is the next row?
And why the restriction against the row number function?
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
July 16, 2013 at 7:35 am
Welsh Corgi (7/16/2013)
I may eventually apply the restore to refresh the Development Environment.But I'm not trying to restore at this point.
Err.. I think you're missing the point.
WITH NORECOVERY is used...
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
July 16, 2013 at 7:33 am
SQL Show (7/16/2013)
Is there a chance the 2nd query will result high cpu usage?
Since it uses twice the CPU of the first, yes.
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
July 16, 2013 at 6:41 am
Ignore the scan count, it doesn't tell you much of use.
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
July 16, 2013 at 5:54 am
Viewing 15 posts - 12,346 through 12,360 (of 49,552 total)