Skip to content
Navigation Menu
Sign in
Products
Platform
GitHub
Repository hosting, code review, and collaboration
Copilot
AI coding agent for tasks, projects, and automated work
Build & Ship
Actions
CI/CD and automation
Code Quality
Quality analysis, fixes, and enforcement
Codespaces
Cloud development environments
Secure
Code Security
Vulnerability detection and remediation
Secret Protection
Secret scanning and leak prevention
All Features
Developers
Learn
Documentation
Training
Certifications
Build
Build with Copilot
Customize Copilot
Integrations
Explore
Trending repos
GitHub Sponsors
Developer articles
Changelog
Changelog
Your source for the latest features, improvements, and fixes across GitHub products, all in one place.
Businesses
By Stage
Enterprises
Team
Startups
Nonprofits
By Industry
Healthcare
Financial services
Manufacturing
Government
See all industries
Evaluate GitHub
Why GitHub
Customer Stories
Business insights
Trust Center
Add-ons
GitHub Advanced Security
Enterprise-grade code security
Copilot for business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Resources
Learn & Connect
Documentation
Resource center
Blog
Events & webinars
Community Forum
Customer Stories
Integrations
Support
Customer support
Training
GitHub Status
Company
About
Partners
Changelog
GitHub Universe
GitHub Universe
The event for developers, by developers — talks, workshops, and what’s next for GitHub.
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
ktaranov
sqlserver-kit
Repository navigation
Code
Issues
1
(1)
Pull requests
3
(3)
Discussions
Actions
Projects
Wiki
Security and quality
Insights
More
items
Files
Expand file tree
master
Breadcrumbs
sqlserver-kit
/
Scripts
/
Foreign_Keys_With_No_Index.sql
Copy path
Blame
More file actions
Blame
More file actions
Latest commit
History
History
History
29 lines (27 loc) · 1.42 KB
master
Breadcrumbs
sqlserver-kit
/
Scripts
/
Foreign_Keys_With_No_Index.sql
Copy path
Top
File metadata and controls
Code
Blame
29 lines (27 loc) · 1.42 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
/*
Author: Drupal
Original link: http://sqlworldwide.com/tsql-to-find-status-of-sql-server-statistics/
*/
WITH
fk_cte
AS
(
SELECT
OBJECT_NAME
(
fk
.
referenced_object_id
) pk_table
,
c2
.
name
pk_column
,
kc
.
name
pk_index_name
,
OBJECT_NAME
(
fk
.
parent_object_id
) fk_table
,
c
.
name
fk_column
,
fk
.
name
fk_name
,
CASE
WHEN
i
.
object_id
IS
NOT
NULL
THEN
1
ELSE
0
END
does_fk_has_index
,
i
.
is_primary_key
is_fk_a_pk_also
,
i
.
is_unique
is_index_on_fk_unique
, fk.
*
FROM
sys
.
foreign_keys
AS
fk
INNER JOIN
sys
.
foreign_key_columns
fkc
ON
fkc
.
constraint_object_id
=
fk
.
object_id
INNER JOIN
sys
.
columns
AS
c
ON
c
.
object_id
=
fk
.
parent_object_id
AND
c
.
column_id
=
fkc
.
parent_column_id
LEFT JOIN
sys
.
columns
AS
c2
ON
c2
.
object_id
=
fk
.
referenced_object_id
AND
c2
.
column_id
=
fkc
.
referenced_column_id
LEFT JOIN
sys
.
key_constraints
AS
kc
ON
kc
.
parent_object_id
=
fk
.
referenced_object_id
AND
kc
.
type
=
'
PK'
LEFT JOIN
sys
.
index_columns
AS
ic
ON
ic
.
object_id
=
c
.
object_id
AND
ic
.
column_id
=
c
.
column_id
LEFT JOIN
sys
.
indexes
AS
i
ON
i
.
object_id
=
ic
.
object_id
AND
i
.
index_id
=
ic
.
index_id
)
SELECT
*
FROM
fk_cte
LEFT JOIN
sys
.
dm_db_partition_stats
ps
on
ps
.
object_id
=
fk_cte
.
parent_object_id
and
ps
.
index_id
<=
1
WHERE
does_fk_has_index
=
0
--
and fk_table = 'LineItems'
ORDER BY
used_page_count
DESC
;
You can’t perform that action at this time.