Gamleur84 | SQLServerCentral

Gamleur84

Forum Topics Started

Viewing 15 topics - 1 through 15 (of 22 total)

Topics

Posts

Last post
Grant View Change Tracking at the database level, possible ?

5 replies

4 years, 11 months ago

By: CC-597066
How can I change the credit card numbers during the INSERT ? (e.g.I want all 0s)

2 replies

6 years, 8 months ago

By: Thom A
Database with thousand of tables and no foreign keys.

14 replies

6 years, 8 months ago

By: Jeff Moden
lock escalation on a small table (13 rows)

4 replies

6 years, 9 months ago

By: Gamleur84
Does adding a column to my table will trigger a update change in Change Tracking

0 replies

6 years, 10 months ago

By: Gamleur84
Improve performance of a query by milliseconds. Should I loop the query to extrapolate the stats ?

8 replies

6 years, 11 months ago

By: Grant Fritchey
Resource Governor - Can a workload go beyond Calculated effective MAX % ?

2 replies

6 years, 11 months ago

By: Gamleur84
How can I offload the compute of SUM operation ?

3 replies

6 years, 11 months ago

By: Jeff Moden
Can I hint a join order or can I hint the first index seek ?

5 replies

6 years, 11 months ago

By: Grant Fritchey
How does a cursor affect the optimizer (and the execution plan) ?

4 replies

6 years, 11 months ago

By: Gamleur84
Slow in the Application, Fast in SSMS. How to force the execution plan generated by SMSS

8 replies

6 years, 12 months ago

By: Gamleur84
RPC:Completed in SQL Profile, but the data is not updated

11 replies

7 years, 1 months ago

By: Jeff Moden
SQL AlwaysOn AG - Cluster with a secondary replica in DR location

1 replies

7 years, 9 months ago

By: Gamleur84
SQL uses 2 different executions plan (slow and fast) for a simple query. Need a new index ?

9 replies

8 years ago

By: Gamleur84
How can I cache an execution plan from SSMS

1 replies

8 years ago

By: sgmunson

Viewing 15 topics - 1 through 15 (of 22 total)