HI,

Idle sessions will never consume your CPU resource. To start investigating, you can use sys.dm_exec_request OR sys.sysprocesses  DMVs to check for sessions that are actively running at that instance. These...

Hi All,

The DBA who was before me had used the Ola's code in the sql job. But as i found out, it did not removed fragmentation. So i tried to...

Hi,

Updating 0 rows is correct execution path and there is no error.

In order to check for the try catch block, you can do the following -

1. set incorrect data type...

Hi,

Assuming you have to add 3 columns with data to the existing 5million row table.

Following is the approach which you can use -

1. Extract the 5 million rows data in...

Hi S_Kumar_S,

Even if you provide explicit DENY Insert/Update/Delete in the user securables within the database to the login-user, the procedure once executed by the same user will perform the DML.

As...

Since it is a part of SP, there must be some logic and requirements of other columns in the remaining SP code.

Get the requirements clear and eliminate the columns which...

Hi,

Using temp tables is beneficial when used in stored procedures and they come handy when you have to store temporary table values for further computations.

Yes, they consume storage and memory...