I have some control. We have a CSS and a template for some things that can be changed, however I'm semi-forbidden from changing things. We have a testing team that...

I'm with Anders, I usually make friends with the people that work hard and are stuck there. I've often been lucky enough to find someone that wants to learn, so...

I agree with Brian that I haven't seen this. Are you using Windows Auth or SQL Auth?

You never need to shrink the database, or almost never. This causes fragmentation and can slow your indexes and worsen performance.

Shrinking should only take place rarely when something unusual makes...

ALTER might be preferred, but if it's not an answer, you don't get to suggest it 😉

The reference given, shows that SQL 2005 requires trace flag 3608. Perhaps that's not...

I think SQLGuru expressed concern that you're trying to solve a complex problem, meaning a very, very busy system, based on community advice. That type of system is one that...

It should be as wide as the article text is (it is here in IE 7 and Firefox 2), but it's not as wide as the page. There's a right...

Nope, don't do it. TSM will have a problem on the day you need to restore a database because someone (perhaps you) deleted a table by forgetting the WHERE clause.

Back...

I agree with Doug. allowing developers to make changes to anything other than development is asking for deployment issues.

With the varchar it doesn't matter. If they are supposed to be six, you can trim them with the SUBSTRING function.

I'd use CHARINDEX to find the space, then SUBSTRING up...

Check out my series on change control. I used to copy all changed things for a release to a second project as they were altered. This way we had the...

Good reference for the one thread per file. I swear I'd seen that in BOL (7, 2000), but perhaps not. Or I misread it 🙁

I've hard on the MVP side...

Native Client supports the newer features of SQL Server 2005 and I think some of the Access 2007 stuff, but I'm not 100% sure. If the ODBC driver works, I...

osql for SQL Server 2000 and SQLCMD for SQL Server 2005 are what you should use.

From a development standpoint, a database in SQL Server is a database, no matter what you're doing with it. If you have a local install of SQL Server, meaning it's...