Data Dill's user avatar
Data Dill's user avatar
Data Dill's user avatar
Data Dill
  • Member for 3 years, 1 month
  • Last seen more than a month ago
2 votes
1 answer
613 views

How to query/monitor index fragmentation?

1 vote
2 answers
201 views

Index Fragmentation Monitoring: Can I make this query faster?

1 vote
0 answers
353 views

Naming Convention for SQL AD Group Logins (Potential Bug)

1 vote
2 answers
135 views

Why does this stored proc cause a clustered index scan, but seek when using OPTION RECOMPILE?

1 vote
1 answer
44 views

Potentially Improper Row Count Read in Parallel Bitmap Hash Match Plan

0 votes
2 answers
38 views

Are AD Groups the exact same as individual windows logins with explicit permissions?

0 votes
1 answer
378 views

Performance impact of Extended Events sessions looking at the exact same event type

0 votes
0 answers
138 views

How to get Sql Instance names of remote server

0 votes
1 answer
43 views

SQL Server - Is it a good idea to persist temporary stats built on AG read-only secondary?

0 votes
3 answers
221 views

Will I need to fix fragmentation after shrinking a database full of only HEAPs?

0 votes
1 answer
50 views

Fastest way to get total block time?

0 votes
1 answer
28 views

Query to change 2 statements into a batching job [closed]

0 votes
1 answer
58 views

How to write a query to identify common combinations of parameters used to call a stored proc?