I'm not sure it will cause problems if you have the time and resources to do it, but there's no need for rebuilding all indexes.

Michelle's script, Hot linked: http://sqlfool.com/2009/06/index-defrag-script-v30/, works...

George has the best advice. Use the configuration manager to assign the account. It will assign the permissions needed.

I don't think BCP/Bulk Import would help here.

If space is at a premium, I would look to resolve that issue. Isn't data likely to grow? Meaning more log space needed?

You...

Excellent job, Paul. It helped me learn a few things about a command I rarely use.

Correct. RTM has dropped out of mainstream support. Or at least...

manure

operating the spreader today to fertilize the pasture.

anthony_merriwether (4/19/2010)

---

This is for all of you who are perturbed with the postings that you are seeing. I have read your replies and feel that you are all out of...

You are getting confused here about security context. When you log into SQL Server as "sa", SQL Server is a self-contained system. It has no knowledge, or even rights, to...

Not sure. I think there is a difference depending on your security connection and setup (AD v non-AD, group v...

Sorry, I think I typed too many S's. Old habit from tracking machines too often.

suser_name() should return the security context.

http://msdn.microsoft.com/en-US/library/ms187934%28v=SQL.90%29.aspx

suser_sname()

http://msdn.microsoft.com/en-US/library/ms174427%28v=SQL.90%29.aspx

Is the file name the same every time? Same location? Or do you need to somehow read what's on the FTP site and then programmatically pick a file to retreive?

That actual rendering of the report is likely the smallest part of the time. As mentioned by the ninja, you need to tune the queries. So focus on tuning those.

If...

I don't usually do this, but...

If you have SQL 2000 installed, you cannot install a default instance of SQL 2005. You would install a named instance, or upgrade your SQL 2000 instance to 2005.