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...

If you always move all changes, because you don't keep things "in progress" in the development database, then SQL Compare from Red Gate (I work for them) or ApexSQL Diff...

Your match should work. I am guessing that for some reason one of the tables might have spaces or some other non-visible characters that are causing the matches to miss.

Have...