User Ritesh Bhakre

12 votes

3 answers

8k views

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

asked Aug 19, 2015 at 7:50

5 votes

1 answer

537 views

Why does dropping decimal columns not free up any space?

asked Dec 27, 2016 at 15:43

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?

asked Sep 2, 2015 at 9:45

4 votes

2 answers

18k views

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

asked Aug 18, 2016 at 10:18

3 votes

2 answers

2k views

How to prevent Extended Events from tracking system fired events?

asked Sep 28, 2015 at 9:49

2 votes

1 answer

217 views

Seeking help with Extended events behaviour

asked Oct 20, 2015 at 10:06

2 votes

0 answers

676 views

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

asked Aug 26, 2015 at 9:09

2 votes

1 answer

1k views

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

asked Aug 27, 2015 at 10:25

2 votes

0 answers

974 views

CDC capture job failing due to trigger execution error apparently

asked Oct 27, 2015 at 8:24

1 vote

1 answer

574 views

Optimising file shrink and index reorganization operations

asked Mar 26, 2016 at 20:15

1 vote

1 answer

2k views

How to extract xml attribute from a column?

asked Oct 20, 2015 at 10:28

1 vote

0 answers

251 views

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

asked Oct 21, 2015 at 8:45

1 vote

2 answers

152 views

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

asked Jan 13, 2017 at 9:35

1 vote

1 answer

2k views

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

asked Jun 20, 2017 at 12:55

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?

asked Sep 4, 2015 at 15:41

0 votes

1 answer

201 views

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

asked Sep 14, 2015 at 12:27

0 votes

3 answers

841 views

Dynamic query execution error

asked Sep 23, 2015 at 15:30

0 votes

3 answers

2k views

Retrieve information about a recent copy only backup?

asked Sep 7, 2016 at 15:47

-1 votes

1 answer

649 views

Optimizing a query to avoid CXPacket wait type

asked Jan 12, 2017 at 13:42

Stack Exchange Network

19 Questions

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

Why does dropping decimal columns not free up any space?

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

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

How to prevent Extended Events from tracking system fired events?

Seeking help with Extended events behaviour

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

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

CDC capture job failing due to trigger execution error apparently

Optimising file shrink and index reorganization operations

How to extract xml attribute from a column?

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

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

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

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

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

Dynamic query execution error

Retrieve information about a recent copy only backup?

Optimizing a query to avoid CXPacket wait type