Skip to main content
Ritesh Bhakre's user avatar
Ritesh Bhakre's user avatar
Ritesh Bhakre's user avatar
Ritesh Bhakre
  • Member for 8 years, 10 months
  • Last seen more than 5 years ago
12 votes
3 answers
8k views

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

5 votes
1 answer
609 views

Why does dropping decimal columns not free up any space?

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?

4 votes
2 answers
19k views

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

3 votes
2 answers
2k views

How to prevent Extended Events from tracking system fired events?

2 votes
1 answer
217 views

Seeking help with Extended events behaviour

2 votes
0 answers
703 views

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

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
1k views

CDC capture job failing due to trigger execution error apparently

1 vote
1 answer
601 views

Optimising file shrink and index reorganization operations

1 vote
1 answer
3k views

How to extract xml attribute from a column?

1 vote
0 answers
265 views

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

1 vote
2 answers
171 views

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

1 vote
1 answer
2k views

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

0 votes
0 answers
49 views

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

0 votes
1 answer
213 views

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

0 votes
3 answers
864 views

Dynamic query execution error

0 votes
3 answers
2k views

Retrieve information about a recent copy only backup?

-1 votes
1 answer
655 views

Optimizing a query to avoid CXPacket wait type