I am curious if using the third party tools makes any difference with this. One of our systems essentially does this every night, since we start our Fulls at...

SQL Magazine had a pretty nice article about a good way of doing that, in a way that I think puts out a nice format

http://www.sqlmag.com/Article/ArticleID/96056/sql_server_96056.html

if you can not get it...

You should check out the Scripts section of this site.

http://www.sqlservercentral.com/scripts/Index+Management/31652/

This particular one scripts the indexes out as a create. I find it to be a more useful type of...

If what you have above is the only sort of thing you are doing (meaning you are printing off individual statements and not record sets) then you can substitute the...

A few things to try and you will invariably have to check this on both the server connecting and the server you are connecting to.

First go to Add/Remove Programs-->Add/Remove Windows...

If you are not already somehow tracking this on your own, I believe that the only way (that I know of anyway) is to go to the error log to...

Within the installation you have to do the Custom selection (can not think of the exact screen on install but essentially you have the option to accept defaults or do...

It is hard to tell what the issue is from just looking at the plan right here, but in the past when I have had issues with performance on linked...

What you have here will work just fine. You can just make a call to msdb..sp_send_dbmail (assuming you have database mail set up) and send whatever information you...

cherie (1/15/2009)

---

One more question..why is it then that when I manually rebuild one of the table index, performance gets better and then again after a week with reindexing..it goes down...

That really depends. Freeing the proccache just removes the plans from cache, so when you...

“M.idt_P” has Non-Cluster Index on it, if I remove this from WHERE, query runs fine, otherwise takes 5 times longer. I have tried couple of options but no use.

Please let...

This is not horribly clever and it certainly requires a second pass through but it works.

select t.IDName

from (select ID, MIN(cost) mincost

from #tmp

group by id) min

join #tmp...

It may be worth looking at the Effective Permissions, just to be sure that whatever permissions are on that folder has not somehow being overwritten by a previous directory. ...

Script it out to be

alter table yourtable

alter column yourcolumn datatype null

and you should not have that same problem.

I have had that same issue when using the interface before. ...