Viewing 15 posts - 18,136 through 18,150 (of 22,202 total)
GilaMonster (3/3/2009)
Grant Fritchey (3/3/2009)
Also, do you get Management Studio (and all the other GUI tools) with SQL Server Express? I didn't think you did.
Not with it, but Management Studio Express...
March 3, 2009 at 6:14 am
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...
March 3, 2009 at 6:10 am
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...
March 3, 2009 at 6:06 am
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...
March 3, 2009 at 6:04 am
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...
March 3, 2009 at 6:02 am
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...
March 3, 2009 at 5:55 am
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....
March 3, 2009 at 5:50 am
Also, do you get Management Studio (and all the other GUI tools) with SQL Server Express? I didn't think you did.
March 3, 2009 at 5:29 am
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...
March 2, 2009 at 6:02 pm
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...
March 2, 2009 at 5:53 pm
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...
March 2, 2009 at 7:44 am
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...
March 2, 2009 at 7:09 am
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.
March 2, 2009 at 6:26 am
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...
March 2, 2009 at 6:25 am
Viewing 15 posts - 18,136 through 18,150 (of 22,202 total)