Viewing 15 posts - 1,486 through 1,500 (of 49,552 total)
DesNorton - Wednesday, April 26, 2017 4:14 AMORDER BY is expensive as it requires a SORT.
Not necessarily. If there's an index...
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
April 26, 2017 at 4:17 am
No ORDER BY, no guarantee of order. End of story.
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
April 26, 2017 at 4:02 am
It looks like you edited the deadlock graph to take the object and index names out, unfortunately that's made it hard to see what's going on. Can you either edit...
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
April 26, 2017 at 3:46 am
That table just has a 2-column primary key. It's now the designers of the database set it up. It probably shouldn't be (The SalesOrderDetailID column is unique by itself iirc),...
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
April 26, 2017 at 3:20 am
You really should sort the VM configuration out.
You can 'just' upgrade to Enterprise edition, but 16 cores of Enterprise licenses will be quite a bit more expensive than...
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
April 25, 2017 at 3:14 am
Google for "SQL Server edition hardware limits" and you should get the comparison page (it's what I do any time I need it)
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
April 25, 2017 at 2:22 am
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
April 24, 2017 at 4:13 pm
SQL Server in VMs in Azure or Azure SQLDB?
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
April 24, 2017 at 3:57 pm
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
April 24, 2017 at 3:40 pm
alen teplitsky - Monday, April 24, 2017 2:28 PMI guess they only appeared in the report because of replication updating them.
Yup.
The DMV...
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
April 24, 2017 at 3:32 pm
An index will only have an entry in that DMV if it's been used at least once, for anything, since SQL Server last started.
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
April 24, 2017 at 2:14 pm
Estimated executions: ~19000, actual executions: 0. In that plan they key lookup is not worth removing as it's not doing anything.
Why you've got such bad estimates for row counts...
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
April 24, 2017 at 8:29 am
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
April 24, 2017 at 8:11 am
No easy way to do that, and you will have to take into account all sorts of conflict problems when you do it.
What happens if a row 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
April 24, 2017 at 5:46 am
You mean a backup that only contains data between when it's taken and some previous point in time?
That's a differential backup, but it won't do what you want, as...
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
April 24, 2017 at 4:12 am
Viewing 15 posts - 1,486 through 1,500 (of 49,552 total)