Viewing 15 posts - 38,041 through 38,055 (of 49,552 total)
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...
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
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...
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
June 30, 2009 at 5:33 am
S Hodkinson (6/30/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
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...
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
June 30, 2009 at 4:36 am
S Hodkinson (6/30/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
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)...
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
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...
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
June 30, 2009 at 12:59 am
Lynn Pettis (6/29/2009)
My only problem is 30 years of experience just...
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
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?
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
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....
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
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...
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
June 29, 2009 at 2:54 pm
ddicecca (6/29/2009)
GilaMonster (6/29/2009)
Take a look in Books Online for the UPDATE ... FROM syntax.Seriously...? That's your help?
I'm sorry, I thought you might like a hint where 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
June 29, 2009 at 2:45 pm
jcrawf02 (6/29/2009)
GSquared (6/29/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
June 29, 2009 at 2:41 pm
Alvin Ramard (6/29/2009)
Lynn and Gail, what would you say to creating a new table in a user database for holding the new data, along with the key fields from sys.sql_logins?
It'd...
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
June 29, 2009 at 2:28 pm
Take a look in Books Online for the UPDATE ... FROM syntax.
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
June 29, 2009 at 2:19 pm
Viewing 15 posts - 38,041 through 38,055 (of 49,552 total)