Hi team,

The link provided in not helping..

any one please check my queries and suggest the changes.

Actually Performance is not a major issue in my case, trying to implement the table management.

i want to store the older records away by creating partitions.

my overrall request is, by...

Select query is taking long time on this table, there are more than 10000 inserts per day.

and this table is mainly used for OLAP process only.

Finally...performance of table needs to...

Hi,

The above code works good.

Can you please create script for below table structure, because Column "Dept_code" having all nulls, insert script is generating as NULL.

Table Name : Emp_dept

Emp id(int)

Dept_id...

Hi,

Want to capture 'Blocked process report' event in trace file for Blocks and Desdlocks.

Sorry,

am using below statements.

begin tran

Update table

from another session trying to execute same select statement from above table, and i wait for more than 5 minute..

hi,

Yes, i've configured for 5 seconds, and manually executed few staments like

begin tran

select.....

from another session trying to execute same select, and i wait for 1 minute..

then trying to fetch the...

Trace file which am trying to read is stopped, and another trace file is running currently.

Hi,

Gettting below error.

You don't have permission to open this file.

Contact the file owner or an administrator to obtain permission

Hi,

If i start the Job at 12:00 AM, then below statement will stop the job after 23hrs 59mins.

SET @StopTime = DATEADD(MINUTE,59,DATEADD(HOUR,23,GETDATE()))

how to stop the trace at 11:59 directly with out...

Thank you..:-)

Agree,

But the same code is running in other enviornment from last 3 days without stored procedure.

In other environemnt also sql server got restarted 2 times, still the code is running.

the...

Hi Gail Shaw,

Found that SQL Server restarted, hence Server side trace stopped.

In other environemnt, am executing server side trace directly without stored procedure, but it is running after sql server...

Hi,

Stored procedure executed, and two trace files with 50 MB created, then it stopped automatically.

Hi Team,

Executed below stored procedures from link "http://ola.hallengren.com"

IndexOptimize.sql

CommandExecute.sql

but while executing stored procedures using below parameters, only statistics are udpated, but indexes are not rebuiling / reorganizing.

EXECUTE dbo.IndexOptimize

@databases...