GilaMonster (3/3/2009)

Not with it, but Management Studio Express...

I would say both approaches are valid. You need to do what your business defines. You're already on the right track, make sure you update the statistics and defrag the...

You need to be sure that your string data is defined as unicode so that you can define the character set as well as the values. This means NVARCHAR and...

There are no issues with SCOPE_IDENTITY that I'm aware of.

One way you can try to debug this is to use the OUTPUT clause. I use it instead of SCOPE_IDENTITY because...

Well, what you've really defined is a DISTINCT on both fields. You're getting all values that match a list for both criteria. It's not really a unique listing of the...

You really need to show what's been done so far, even if you haven't done much.

What language are you using for the scripting? Are you doing everything through T-SQL and...

In addition to what the others have posted, you should take a look at updating your statistics and maybe defragging your indexes. You have estimated 4 rows, but actual 86000....

Also, do you get Management Studio (and all the other GUI tools) with SQL Server Express? I didn't think you did.

That's probably the right way to think about it. By the way, I wasn't talking about 1 player to 1 manager. I was attempting to describe the two directions that...

I think asking why is probably not asked often enough. So many of the questions that come by are just a little off. You know the kind that makes you...

Nice work.

Did it generate an error or did the update not occur? If you're checking for an update working, you'd want to look at the @@ROWCount instead of @@Error. Also, since...

With well indexed tables, a three table join is pretty painless. A ten table join is pretty painless too depending on the indexes. I sure wouldn't compromise the data integrity...

Reading that BOL entry, I'll bet it's a holdover from 2005. It did work in 2005, but it doesn't seem to in 2008.

I've never been able to do it either. When I'm working 2000 instances I just go back to sp_who2 and other TSQL methods for seeing what's going on. Not as...