Viewing 15 posts - 11,821 through 11,835 (of 49,562 total)
It's a bug in Management studio
September 3, 2013 at 2:32 am
If you're seeing mirroring-related waits, check the latency of the line to the mirror, make sure that nothing's wrong, check write throughput on the mirror's log drive. The state will...
September 3, 2013 at 2:13 am
Can you post the procedure?
September 3, 2013 at 2:07 am
durai nagarajan (9/3/2013)
But why not they check OS Memory before accepting it?
Why should it?
How does SQL know that I'm not setting max server memory higher then going home while the...
September 3, 2013 at 1:12 am
santhosh411 (9/3/2013)
September 3, 2013 at 1:11 am
Why wouldn't it accept the value?
If you check books online, max server memory must be a value between 16 and 2147483647, min server memory must be a value between 0...
September 3, 2013 at 1:00 am
Depends which gives the expected results. The choice of the two is not a performance consideration, it's a correctness consideration.
Union - combine the two resultsets and remove duplicates.
Union all -...
September 3, 2013 at 12:57 am
Primary key is not decided by a query. It's part of the design process of the table. It's a column or set of columns that uniquely (with no nulls) identifies...
September 3, 2013 at 12:55 am
Please post table definition, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/. Tuning is seldom about removing portions of a query.
Also ditch the nolocks, unless the users know and accept...
September 3, 2013 at 12:53 am
Since SQL will never be able to reach 5GB (and hence the min server memory setting will never take effect), nothing different to the default setting (where max server memory...
September 3, 2013 at 12:49 am
iirc he also wrote a chapter in one of the MVP Deep Dives on the subject.
September 3, 2013 at 12:44 am
Err... the second line of my post....
As for why SQL's using the memory, because it can. Because it has not been told that it can't (via max server memory). Set...
September 3, 2013 at 12:41 am
Shadab Shah (9/2/2013)
So you are telling me that this missing index dmv's are useless :w00t:.
No. I didn't say they're useless. I said they're a place to start.
September 3, 2013 at 12:37 am
SQLRNNR (9/2/2013)
Pins and needles seeing the strike-through on your MCM in the signature.
I'll remove the strikeout in a week or two. Just making a point.
September 2, 2013 at 5:05 pm
No idea. Maybe. Possibly not.
Ignore fragmentation on very small indexes. It's meaningless on very small indexes (which are the ones that usually show this kind of behaviour)
September 2, 2013 at 5:05 pm
Viewing 15 posts - 11,821 through 11,835 (of 49,562 total)