HI SQL Kiwi

Just want to know if the script through link runs for Index Defrag so we have to run Update statistics separately or whole script takes...

Thanks ..

It really helps to understand now.

very good start of separate forum and basic question on data mining. i am also interested to know more and deep...

can suggest any good book or article?

Thanks

Hi ,

I am using XCOPY Command to move files from one server to another which is run under SQL Agent in midnight taking less time compare to put...

My problem is like weired..

can not connect to sql box through SSMS on same server. It just freeze up.

but from different server i can connect to same sql server.

Hi ,

I am facing kind of same issue with same specs .. are you able to solve this ?

Can you share please?

Thanks

Thanks It works for me ..

Just making sure again it will display the date of every month's end right?

really appreciated for your help and time

Yes i have figured out by reading posts that by setting MXDOP to 1 won't really helps and creates other problem..

Thanks for advise and i am sure for not to...

Anyone has done crystal report to SSRS conversion manually?

If some one can help me step by step would be much appreciated .

Thanks

Checked logs and sqlagent file too..

in error log says all backups proceed successfully.

Hi Shiva

Nice post about TF information..

I would like to know Owner:0x0000000BA7ED6780 this shows in result of Trace flag output..

And how i can know which...

Thanks folks for kind reply..

I found out its Date time stamp issue with query...Sorry couldn't post the query here because of my companies privacy but appreciate all of your's...

Yes chris

The problem is near INSERT statement.

good catch...I saw the error recommending to use convert function but where to apply that?

Table Defination

USE msdb

GO

CREATE TABLE dbo.tblDeadLock_Log (

DeadLock_ID int IDENTITY(1,1) CONSTRAINT pk_tblDeadLock_Log PRIMARY KEY

, DeadLock_Detected datetime

, DeadLock_Graph nvarchar(max)

, NoMailReason nvarchar(2048))

GO

this is most commonly asked question in SQL DBA job interviews. I am also looking for the good answer.

I tried to convince them to go through exec plan , Index,...