Someone must have altered them somehow and not restarted the server. Were there any trace flags set on the service startup?

You can move the files back using the process here:...

You could search through syscomments for "select *" as a key phrase in those objects that are views.

You need a trace to see what activity is taking place. The log grows when any transactions are running, including index rebuilds, DBCC, etc. Something is happening. Check jobs as...

There isn't necessarily a great way to do this, although perhaps a tool like SQL Compare (REd Gate) can help.

select * isn't recommended because things can change. It also...

Is there a question here? You need more disk space.

SANs centralize the storage and often contain more drives than you can physically attach to one server. The PC architecture has limitations, and most vendors don't go beyond a certain...

I think the naming could be better. Logs, for the most part in computer science, are just extra information about what an application is doing. It seems more and more...

Very strange. Could you have two registrations? Perhaps under another email with the same display name?

If you're having issues, then you might need to apply the SP. If not, I'd hold off. Typically when I've called MS in the past, they want the latest SP...

I think there are still jobs out there, and surprisingly I've been contacted by a lot of recruiters lately with jobs in the Denver area.

Keep your resume up to date,...

Please let us know if this changes things. I'd also watch reads and index size before and after if you can and let us know.

Steve

which blog site? Probably not me, as the Redriven doesn't sound familiar. I'll check it out.

🙁

Partitioning is built for this type of issue, but will it help? Can you separate out partitions to separate disks? It might reduce blocking on loads to load a new...

the rules are the same at a small or large level. You design to store and query data efficiently. You might need to add things at a large level like...