adam.g's user avatar
adam.g's user avatar
adam.g's user avatar
adam.g
  • Member for 2 years, 2 months
  • Last seen this week
8 votes
2 answers
796 views

Does killed session appears in Query Store?

5 votes
1 answer
742 views

Does Query Store force plan persist following server restart?

3 votes
1 answer
681 views

What is "execution count" in Query Store?

2 votes
1 answer
262 views

Can we exchange logical disjunction for UNION ALL?

2 votes
2 answers
617 views

How to simulate error with MSG = 0 on Sql Server?

2 votes
1 answer
444 views

Strange behaviour of force plan in query store

2 votes
0 answers
121 views

Huge Difference in IO and CPU for same query

2 votes
2 answers
696 views

How to avoid returning partial data from SQL Server in .NET application?

1 vote
0 answers
51 views

Huge difference in terms of duration between delete of columnstore and rowstore big table

1 vote
0 answers
47 views

Instead of delete trigger performance

1 vote
2 answers
78 views

When can we downsize Azure Virtual machine for SQL Server?

0 votes
1 answer
120 views

Failover in AG without listener

0 votes
1 answer
65 views

What is the best option to remove duplicates in big heap?

0 votes
1 answer
39 views

Does DACPAC creation is doing any blocking on database / server level?

0 votes
0 answers
8 views

Usage of SparkMetric_CL, SparkListenerEvent_CL and SparkLoggingEvent_CL

0 votes
1 answer
64 views

Can I do transaction for dynamic sql which contains DISABLE change tracking / TRUNCATE / PARTITION SWITCH

0 votes
2 answers
1k views

Automatically enable trace flag after server restart

0 votes
0 answers
160 views

Is it an option to deploy specific schema with objects - procedures, funtions, views to multiples databases?

0 votes
0 answers
117 views

Connect query from sp_whoisactive and Query Store

0 votes
1 answer
183 views

Retrieve execution plan via XML data from sp_WhoIsActive in adhoc process

0 votes
1 answer
176 views

What is the best option to store XML in SQL Server 2016?

0 votes
1 answer
443 views

What permission have to set for SQL user for configuration of change tracking in Database?

0 votes
1 answer
86 views

Why new nonclustered index cause more IO reads on table?

-2 votes
1 answer
48 views

Why force plan is not working with failure "NO_PLAN"?