Viewing 15 posts - 47,236 through 47,250 (of 49,552 total)
Is the F drive compressed or encrypted?
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
March 3, 2008 at 3:52 am
Is the index covering? The 90% (often closer to 99%) applies when SQL needs to do bookmark lookups to the cluster/heap
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
March 3, 2008 at 3:03 am
How are you viewing the execution plan?
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
March 3, 2008 at 3:03 am
Selectivity is a measure of how many different values are in the index compared with the number of total rows.
If the values are unique, then you have 100% selectivity.
I don't...
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
March 3, 2008 at 2:37 am
Traceflags 1204 and 1205 are for finding deadlocks, not blocking chains
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
March 2, 2008 at 1:20 pm
webrunner (2/29/2008)
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
March 2, 2008 at 1:02 pm
Lynn Pettis (2/29/2008)
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
March 2, 2008 at 12:48 pm
Jack Corbett (2/29/2008)
This is when I hate coming to this site, because I'd probably fail in interview with you guys.
I did say depending on the position. Someone applying for...
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
March 2, 2008 at 12:43 pm
Odd. SQL won't automatically create indexes, only statistics.
Is it possible that someone created that index and gave it the same name as the statistic it was supposed to replace?
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 29, 2008 at 5:10 am
Cool.
Any chance of seeing the execution plans? Please?
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 29, 2008 at 4:33 am
One thing I notice from that.
You've got a TOP 100% ... ORDER BY in a sub query. It's useless there. Order by only applies in the outer select. It probably...
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 29, 2008 at 3:56 am
The _WA_sys aren't indexes. They're automatically created column statistics. Nothing more.
They're created to help the optimiser determine the number of rows that queries should return. They're created on columns that...
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 28, 2008 at 10:45 pm
KATHLEEN Y ZHANG (2/28/2008)
somehow a proc I created to monitor blocking shows 'create proc' on the blocking side and 'execute' on the blocker side. I am not sure why.
How...
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 28, 2008 at 10:38 pm
lucky (2/28/2008)
I'll be having an interview tomorrow and I would like to get some hot tips
Sure.
Be honest about your level of knowledge. Any competant interviewer can tell knowledge 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 28, 2008 at 10:36 pm
Yup. I've seen that before.
Had an old DB that we found corruption in. Had no idea how long it had been there, and the earliest backup we had was...
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 28, 2008 at 10:31 pm
Viewing 15 posts - 47,236 through 47,250 (of 49,552 total)