Chris Patton (8/26/2009)

---

Thank you. I'd rather not have to go the route of creating a new filegroup and emptying the other into it.

We use the filegroup in question for archived...

Nice topic. I have had to use this as well for searching special characters of this type due to the nature in which the application and database were developed...

SQL 2005 still supports the following three ways to report data and log space usage for a database:

DBCC SQLPERF ( LOGSPACE ) can tell you...

This method may be a little longer. Have you considered creating a new filegroup that is readwrite and then moving tables and indexes from the readonly filegroup to the...

Something we have done in the past is to block apps at the firewall - if you have your database servers in a protected zone.

Another method is to disable the...

Ouch, have to agree with GSquared. That clustered index scheme should be re-evaluated by the vendor. Setting your fillfactor low and defragging will help this scenario.

Are you using a service account for the Browser service startup? If so, is that account expired, or password expired?

Also try from a cmd prompt:

ipconfig /flushdns

And then have your...

Hugo and Hakan, both bring up good points. There may be justifiable cases to not have a clustered index on a table - in an ideal world where one...

To answer your questions would vary from school to school and employer to employer. What are the hours like - depends on how well you do your job and...

With the linked server in play, that is where I would troubleshoot first. You said that the proc does the import and export from within the same Instance, and...

This is a decision to be made by the db and server groups within your company.

I prefer to separate SSIS off onto it's own server - we call them process...

For those still asking, try the sqlfarms website. There is a script there to download. In order to download you must be a member of the site.

SQLFarm Site

RedGate also has a tool called Dependency tracker that could be of some use.

Which version of Management Studio are you using and which version of SQL?

Are these connection issues related to trying to connect to SharePoint, WSUS or something like that?

Personally I like ER Studio. Thanks to this listing, I am checking out Power Architect now.