Look up UPDATETEXT. It is needed once you get above a certain size.

Mani is correct and you can sync them back up. Remember the USERS are in the database and this is completely separate from LOGINs, which are on the server....

I agree with Matt. Set the logs at their peak + pad, and leave them. There's no reason to shrink them. As you back them up (or checkpoint in simple...

Is performance worse than the old system?

I tend to agree with GSquared on the setup, though I'd check the cache on the SAN as well. For SQL you really want...

Ian, all you can do is document as best you can. If no one will pick up the slack to learn the older system, at least you've done something.

I'm trying...

Could it be IMPLICIT TRANSACTIONS set off for some connection?

The ROI or cost/benefit is something you have to determine, but I think there's something else to consider.

Is your company a risk taker?

Going with a new version early, means you're...

I've seen it both ways, and bragging doesn't always have anything to do with skill in my experience.

If someone is right, you might be annoyed by their bragging, but they're...

At this job the title doesn't much matter. However when you look for the next job, the title will matter.

Really you've got a couple titles. I'd talk about this...

Hmmm, my wife just calls me :hehe:

Great comments and while I was thinking of technical skills, I'm glad you ran with the communication and problem solving items. Those are really important and if you were hiring...

Change all your tables in the FROM clause to

FROM tablea inner join tableb

on tablea.x = tableb.x

The mixed join types might cause issues (ANSI and non-ANSI)

you can do this with charindex or patindex. Search for the "." and then use substring to pull things out.

There are about 150 SQL Server MVPs, about 1500 or so across all products. The number depends on funding and each MVP is evaluated against others in the quarter they...

There are about 150 SQL Server MVPs, about 1500 or so across all products. The number depends on funding and each MVP is evaluated against others in the quarter they...