Hi I was running that query and I got some time outs to end users so .. I have canceled the query ...

what else we can do to prevent...

HI .. I am running SELECT * FROM distribution.dbo.MSdistribution_status

query it’s still running ..

Stopping Agent in Production server its little hard... I have other import jobs running on agent for...

Hi ,

Guys any information on this problem ?

I am facing same problem in my DB

Let me know your information.

Thanks

Ichbinraj

hi experts,

Please let me know is it right syntax for creating non cluster index on cluster index ?

CREATE NONCLUSTERED INDEX IX_dbo_ZTable_SID_ITEM_CUSTOM1

ON dbo.Ztable(SID, ITEM_CUSTOM1);

GO

Appreciate your suggestions.

Thanks

ichbinraj

Sample data:

300801680051000180023 ...

Hi ,

That's true ..both statements are correct.

It does insert update on DB table as well as its updates some tables on application side

Thanks

ichbinraj

Hi did you check the execution plan ?

about stats update I am doing it manually.

if i change any thing on cluster index .. means removing cluster index from sid...

Hi ,

Application fetching all the fields and updating other tables in application.

So I have to select all fields on .

As per your suggestion . I have...

Hi ,

Here its my query : SELECT * FROM pep.ZSDI38_DATAITEMS WHERE SID = '80168005' and ITEM_CUSTOM1 in (1000180023,1000180024);

and Index information

ZSDI38_DATAITEMS~0clustered, unique, primary key, stats no recompute located on...

one quick question

IF my application updating existing record that mean

some 123 record does it going to slowdown the performance ?

If I am trying to insert a new records number...

hi my information about the Table

What is the clustered index key? its created on 5 columns

Where are your inserts in the clustered key, beginning, middle, end? its dynamic process...

Hi Gurus,

Server is in cluster group.

First node has Oracle path set up correctly and it is running fine ... but when sql failover to 2 node DTS having...

My Bad....

I have created ABC group in 'local users and group' and able to set the permission's READ/Write on TEST DB, Added (mapping windows users) some windows users...

Thanks for your information.

I created on role XYZ_USERs .. just I am confused here can you explain me little more...

I could see 40 users when I am...

Hi Thanks for information.

I have fragmentation table which >30 and its nearly 78 tables and I am planing to rebuilding online indexes now..

Can you please send me Script...