Viewing 15 posts - 38,056 through 38,070 (of 49,571 total)
Ok, those worked properly.
This is seriously weird.
Edit: Anyone else seeing this? (I've already passed it on to Steve)
June 30, 2009 at 6:12 am
S Hodkinson (6/30/2009)
June 30, 2009 at 6:08 am
Can someone send me a PM please. There looks like there's something buggy, every PM I've received in the last week has been from 'Anonymous' and has no profile associated.
If...
June 30, 2009 at 6:06 am
Paul White (6/30/2009)
PS I have yet to come across a system that ended up needing the -g switch
I have. Previous company we had one server that was used for a...
June 30, 2009 at 5:58 am
mazzz (6/30/2009)
I remember reading about the cost figures being estimates, even in the *actual* execution plan
Yup, because the cost comes from the optimiser, before the query is actually run.
what...
June 30, 2009 at 5:46 am
Neerav: Performance tuning is a massive subject entire books can be written on the subject (and in fact have)
Have a look for "SQL 2008 performance tuning Distilled" and "Inside SQL...
June 30, 2009 at 5:33 am
S Hodkinson (6/30/2009)
June 30, 2009 at 5:16 am
Books Online:
The guest user cannot be dropped, but it can be disabled by revoking its CONNECT permission. The CONNECT permission can be revoked by executing REVOKE CONNECT FROM GUEST within...
June 30, 2009 at 4:36 am
S Hodkinson (6/30/2009)
June 30, 2009 at 4:34 am
If most of the usage is on ColB and quite a bit on the combination, I'd change that PK so that the columns are in the other order (ColB, ColA)...
June 30, 2009 at 4:26 am
What you've got there is VAS (virtual address space) fragmentation (not necessarily pressure).
There are a number of things that can cause this. Are you using any of the following?
Extended...
June 30, 2009 at 12:59 am
Lynn Pettis (6/29/2009)
My only problem is 30 years of experience just...
June 30, 2009 at 12:40 am
GSquared (6/29/2009)
GilaMonster (6/14/2009)
$Deity's gift to ITYep!
Is it stuck above your monitor?
June 29, 2009 at 3:01 pm
Lynn Pettis (6/29/2009)
Actually Gail, I think it is just an old style inner join.
Except that there's no condition in the where clause that joins the two tables either....
June 29, 2009 at 2:54 pm
Alvin Ramard (6/29/2009)
Lynn Pettis (6/29/2009)
Snippy some people can be.
Yep. I'm ready to guess the solution to his update problem is, but we can't say without knowing more about his...
June 29, 2009 at 2:54 pm
Viewing 15 posts - 38,056 through 38,070 (of 49,571 total)