You can also need to update statistics on smaller tables where large percentages of the data changes regularly.

No doubt. I wouldn't do it. Ever. I was just pretty sure that it was possible. It's also possible to stick my fork into my thigh... I'm not doing that...

You've got two different issues you're going to be working with. First, the lack of PK & FK in the database could lead to serious integrity issues. That means the...

TRY/CATCH itself has no performance implications. What you do in the CATCH statement could have serious performance implications.

This is something normally handled on the client, as was already said. But, you could use a CLR query to do it. I wouldn't recommend it, but it is possible....

That's actually...

mhaskins (7/18/2008)

Mine too - I don't know if my minimum wage customer service jobs were really...

This reminds me of when i started at my current company. I started the same day as another guy in my group. He was considered the people person/manager in the...

This is a good article. I can see why it was reprinted. I'd like to see an update. Things are just a little different in 2005/2008. Those differences, some of...

INCLUDE columns absolutely help with lookup...

Soft skills... Soft skills....

OH! I know. That's when you use wrist locks and grapple into submission holds rather than smash their face flat and kick their naughty bits up between...

And the functionality has improved a ton. I love being able to pull execution plans right off the screen.

I'm happy to see someone else come out with the old data saw, only move the data you need and only when you need it. I would have added that.

As...

Actually, if I were doing it, first, I'd try to avoid dynamic sql unless you use sp_executesql and pass it parameters (this creates execution plans that are reusable). For what...

Between the query window in Management Studio and the command line options available through sqlcmd.exe, anything you can do with isql.exe is very old hat indeed. They're either just using...