Skip to content

Instantly share code, notes, and snippets.

View gilbonbaggins's full-sized avatar

gilbonbaggins

View GitHub Profile
@gilbonbaggins
gilbonbaggins / CEmodel120+updated-stats.xml
Created February 13, 2020 15:09
https://dba.stackexchange.com/questions/259550/funky-cardinality-estimate-skews-high-memory-grants-and-missing-statistics
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.480" Build="12.0.6329.1">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementText="SELECT&#xD;&#xA;&#x9;&#x9; t.CanDelete&#xD;&#xA;&#x9;&#x9;, t.CanDownload&#xD;&#xA;&#x9;&#x9;, t.CanUpload&#xD;&#xA;&#x9;&#x9;, t.CanView&#xD;&#xA;&#x9;&#x9;, i.ClientCreatedDate&#xD;&#xA;&#x9;&#x9;, i.ClientModifiedDate&#xD;&#xA;&#x9;&#x9;, i.CreationDate&#xD;&#xA;&#x9;&#x9;, uc.FirstName AS CreatorFirstName&#xD;&#xA;&#x9;&#x9;, i.CreatorID&#xD;&#xA;&#x9;&#x9;, uc.LastName AS CreatorLastName&#xD;&#xA;&#x9;&#x9;, i.ExpirationDate&#xD;&#xA;&#x9;&#x9;, i.FileCount&#xD;&#xA;&#x9;&#x9;, i.FileName&#xD;&#xA;&#x9;&#x9;, i.FilePath&#xD;&#xA;&#x9;&#x9;, i.FileSizeBytes&#xD;&#xA;&#x9;&#x9;, i.Hash&#xD;&#xA;&#x9;&#x9;, t.ItemID AS ID&#xD;&#xA;&#x9;&#x9;, sl.ExpirationDate AS LockExpirationDate&#xD;&#xA;&#x9;&#x9;, sl.LockID&#xD;&#xA;&#x9;&#x9;, ea.Email AS LockOwnerEmailAddress&#xD;&#
@gilbonbaggins
gilbonbaggins / CEModel120+T4199.xml
Created February 13, 2020 14:57
https://dba.stackexchange.com/questions/259550/funky-cardinality-estimate-skews-high-memory-grants-and-missing-statistics
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.480" Build="12.0.6329.1">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementText="SELECT &#xD;&#xA; t.CanDelete &#xD;&#xA; , t.CanDownload &#xD;&#xA; , t.CanUpload &#xD;&#xA; , t.CanView &#xD;&#xA; , i.ClientCreatedDate &#xD;&#xA; , i.ClientModifiedDate &#xD;&#xA; , i.CreationDate &#xD;&#xA; , uc.FirstName AS CreatorFirstName &#xD;&#xA; , i.CreatorID &#xD;&#xA; , uc.LastName AS CreatorLastName &#xD;&#xA; , i.ExpirationDate &#xD;&#xA; , i.FileCount &#xD;&#xA; , i.FileName &#xD;&#xA; , i.FilePath &#xD;&#xA; , i.FileSizeBytes &#xD;&#xA; , i.Hash &#xD;&#xA; , t.ItemID AS ID &#xD;&#xA; , sl.ExpirationDate AS LockExpirationDate &#xD;&#xA; , sl.LockID &#xD;&#xA; , ea.Email AS LockOwnerEmailAddress &#xD;&#xA; , ul.FirstName AS LockOwnerFirstName &#xD;&#xA; , sl.LockOwnerID &#xD;&#xA; , ul.LastName AS LockOwnerLastNam
@gilbonbaggins
gilbonbaggins / TF 2363.txt
Created February 12, 2020 21:13
TF 2363 Output for CE 120
Begin selectivity computation
Input tree:
LogOp_Select
CStCollBaseTable(ID=1, CARD=5230 TBL: #CurrentItemsWithPerms AS TBL: t)
ScaOp_Logical x_lopAnd
@gilbonbaggins
gilbonbaggins / CE70.xml
Created February 12, 2020 20:51
https://dba.stackexchange.com/questions/259550/funky-cardinality-estimate-skews-high-memory-grants-and-missing-statistics
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.480" Build="12.0.6329.1">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementText="SELECT &#xD;&#xA; t.CanDelete &#xD;&#xA; , t.CanDownload &#xD;&#xA; , t.CanUpload &#xD;&#xA; , t.CanView &#xD;&#xA; , i.ClientCreatedDate &#xD;&#xA; , i.ClientModifiedDate &#xD;&#xA; , i.CreationDate &#xD;&#xA; , uc.FirstName AS CreatorFirstName &#xD;&#xA; , i.CreatorID &#xD;&#xA; , uc.LastName AS CreatorLastName &#xD;&#xA; , i.ExpirationDate &#xD;&#xA; , i.FileCount &#xD;&#xA; , i.FileName &#xD;&#xA; , i.FilePath &#xD;&#xA; , i.FileSizeBytes &#xD;&#xA; , i.Hash &#xD;&#xA; , t.ItemID AS ID &#xD;&#xA; , sl.ExpirationDate AS LockExpirationDate &#xD;&#xA; , sl.LockID &#xD;&#xA; , ea.Email AS LockOwnerEmailAddress &#xD;&#xA; , ul.FirstName AS LockOwnerFirstName &#xD;&#xA; , sl.LockOwnerID &#xD;&#xA; , ul.LastName AS LockOwnerLastNam
@gilbonbaggins
gilbonbaggins / CE120.xml
Created February 12, 2020 20:48
https://dba.stackexchange.com/questions/259550/funky-cardinality-estimate-skews-high-memory-grants-and-missing-statistics
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.480" Build="12.0.6329.1">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementText="SELECT &#xD;&#xA; t.CanDelete &#xD;&#xA; , t.CanDownload &#xD;&#xA; , t.CanUpload &#xD;&#xA; , t.CanView &#xD;&#xA; , i.ClientCreatedDate &#xD;&#xA; , i.ClientModifiedDate &#xD;&#xA; , i.CreationDate &#xD;&#xA; , uc.FirstName AS CreatorFirstName &#xD;&#xA; , i.CreatorID &#xD;&#xA; , uc.LastName AS CreatorLastName &#xD;&#xA; , i.ExpirationDate &#xD;&#xA; , i.FileCount &#xD;&#xA; , i.FileName &#xD;&#xA; , i.FilePath &#xD;&#xA; , i.FileSizeBytes &#xD;&#xA; , i.Hash &#xD;&#xA; , t.ItemID AS ID &#xD;&#xA; , sl.ExpirationDate AS LockExpirationDate &#xD;&#xA; , sl.LockID &#xD;&#xA; , ea.Email AS LockOwnerEmailAddress &#xD;&#xA; , ul.FirstName AS LockOwnerFirstName &#xD;&#xA; , sl.LockOwnerID &#xD;&#xA; , ul.LastName AS LockOwnerLastNam