user avatar
user avatar
user avatar
Data Dill
  • Member for 2 years, 11 months
  • Last seen more than a week ago
2 votes
1 answer
584 views

How to query/monitor index fragmentation?

1 vote
2 answers
190 views

Index Fragmentation Monitoring: Can I make this query faster?

1 vote
0 answers
327 views

Naming Convention for SQL AD Group Logins (Potential Bug)

1 vote
2 answers
123 views

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

1 vote
1 answer
43 views

Potentially Improper Row Count Read in Parallel Bitmap Hash Match Plan

0 votes
2 answers
37 views

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

0 votes
1 answer
351 views

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

0 votes
0 answers
98 views

How to get Sql Instance names of remote server

0 votes
1 answer
42 views

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

0 votes
3 answers
201 views

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

0 votes
1 answer
49 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
47 views

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