Ritesh Bhakre's user avatar
Ritesh Bhakre's user avatar
Ritesh Bhakre's user avatar
Ritesh Bhakre
  • Member for 8 years, 6 months
  • Last seen more than 4 years ago
1 vote
1 answer
2k views

Red Gate comparison not working after upgrading SQL Server 2016 [closed]

1 vote
2 answers
158 views

Dropping columns from a table, truncating it and then re-inserting data as before into the table doesn't reduce space occupied

-1 votes
1 answer
651 views

Optimizing a query to avoid CXPacket wait type

5 votes
1 answer
557 views

Why does dropping decimal columns not free up any space?

0 votes
3 answers
2k views

Retrieve information about a recent copy only backup?

4 votes
2 answers
18k views

The process cannot access the file because it is being used by another process 2

1 vote
1 answer
584 views

Optimising file shrink and index reorganization operations

2 votes
0 answers
1k views

CDC capture job failing due to trigger execution error apparently

1 vote
0 answers
257 views

Best event to track the DML operations being performed on Server along with the hostname performing those operations?

1 vote
1 answer
2k views

How to extract xml attribute from a column?

2 votes
1 answer
217 views

Seeking help with Extended events behaviour

3 votes
2 answers
2k views

How to prevent Extended Events from tracking system fired events?

0 votes
3 answers
850 views

Dynamic query execution error

0 votes
1 answer
209 views

Retrieving only the last row of a table, in the absence of a primary key

0 votes
0 answers
48 views

Different ways to log the DML operations being performed, along with the hostname (or some type of unique ID) performing the said operations?

5 votes
3 answers
9k views

Can SQL Server Audit be used to track hostnames or IP adresses of the users performing DML on a table?

2 votes
1 answer
1k views

Determine the command type in a DDL trigger / get names and datatypes of new columns

2 votes
0 answers
689 views

Any way to ensure that Change Data Capture clean up process does not delete the change data that you haven't processed yet?

12 votes
3 answers
8k views

Find the identity of the client firing a query in SQL Server without using triggers?