Evil Kraig F (2/1/2012)

---

sqlzealot-81 (2/1/2012)

---

Okei, After I took the trace script from the production, Is there any way to specify the server name to be traced. So that I can...

GilaMonster (2/1/2012)

---

Better than SQL Server? Don't understand

Sorry...My bad, I meant SQL Server Profiler here.

2. How can I schedule a server...

Not always. Please read the below link....

http://beyondrelational.com/blogs/sqlzealot/archive/2011/10/04/back-to-basics-update-statement-in-sql-server.aspx

Try the below query to find the missing index:

Note: You may have to really evaluate the proposals from the execution to decide the needs.

SELECT user_seeks * avg_total_user_cost * (...

You can try with the job wizard to notify the failures.

I dont think you should worry on this fragmentation.

Don’t do anything if the index has < 1000 pages

It would defenitely take time in your case.

However a question, Do you have indexes on the table?

Updating stats should be done at less trafic time to avoid blocking. Instead of doing update stats i would recommande to find out the fragmentation level and do the reorganize/rebuild...

Add postcode aslo in the group by and select columns. That would give the result of having the same address with the same postal with the number of entries. Please...

No. Also one more thing that the update statistics are not happening all on a sudden when its invalidated.

After an extensive googling out, I could only relate this with Execution Engine of CLR at the time of GC.

I do not know how far the below link would help you. Please refer the same.

http://social.msdn.microsoft.com/Forums/en/sqlnetfx/thread/9afded55-72ae-49eb-b7c3-f2ab491f93c9

Ok, its worth looking at the below MSDN. I am not sure as long as I dont have any idea about your complete code.

http://support.microsoft.com/kb/958547

Meanwhile, we exepect our experts...

No clues on this. However let me ask you something out of box whats the SQL server version you installed?

ravi@sql (10/18/2011)

---

example of code

INSERT INTO CourseFeedback (Courseid,UserID,Feedbackxml,CreatedDate)

VALUES (@CourseId,@UserID,@Feedbackxml,GETDATE())

In both case am using getdate() function to use. I assigned that date to one variable and am using...