I think one reason why this could be is our global world. How many of us actually understand how to communicate with not only other people (techies, non-techies, management)...

Thank you Gail for the clarification.

So for those of us who aren't DBA experts does this mean that choosing between a SELECT INTO and INSERT INTO is one of those "It Depends" choices? Using...

I think we have all gotten off the original topic here which was valid when it started. Security is an issue and the thought concerning it needs to be...

The points about Education and Core garbage is right, there is a lot of fighting and unnecessary stuff going on about that. Which is why it's a joke people...

Old Hand - unfortunately that attitude is more prevalent than people think. Also the silly belief that "We have a firewall and AV running, we're good." Like neither...

As mentioned yes it is possible and in fact you can set up a plan to do the backups regularly as well. Thing I noticed though is this (at...

Thanks for the info. Very interesting read on exactly how the SQL Engine uses the T-log. I knew about the recovery model aspect(s) but the other stuff was...

That is one of the differences in opinion. It was placed into Full Recovery Mode with no T-log backups being done. And no I can't explain to you...

Thanks for the info and sorry I didn't get back to answer the question asked. The current DB file size that we are working on is 190GB. The...

Curious about this topic. Say you have a 40GB DB file. Would it ever be realistic to have say a 20GB log file? I was always under...

Thank you both as now I have learned something new. Have been wasting time thinking it was corruption when it wasn't all along. I'll have to check about...

Good question so I checked. Each Clustered Index that still showed fragmentation has either 6 pages or less. Most had either 2 or 3 pages only. I...

Those are very good suggestions and having been in IT for a while is pretty much what I do, purchase books, pay for my own training at times, etc, etc....

So Steve what would you recommend then for those poor souls? As being one of them it drives me nuts to constantly be told I can't get more training...