Viewing 15 posts - 8,476 through 8,490 (of 14,953 total)
They're both good.
There was a long period of time where AMD was ahead of Intel on performance vs price, but not so much any more. Now they're so close...
September 2, 2009 at 7:47 am
Do a search for "parameter sniffing" in Bing/Google/whatever. Gail Shaw's blog has an article on it that's quite good: http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
September 2, 2009 at 7:45 am
Where I work, we just finished retiring our last SQL 2000 server a few weeks ago and are now fully operating on SQL 2005. We just began the discussion...
September 2, 2009 at 7:41 am
Yes, you'll still need linked servers. You'll need those no matter what method you use, if you want SQL servers to talk to each other.
Check out "create view" in...
September 2, 2009 at 7:34 am
GilaMonster (9/2/2009)
I like using the telephone directory to explain indexes. Most people know what one looks like, make the explanations much easier.
I'm beginning to run into people who've never used...
September 2, 2009 at 7:24 am
Haven't ever needed to know that. Not sure where to get it. Dig around a bit in the system views. It's probably in there.
September 2, 2009 at 6:48 am
The first part of the solution would be to check for the existence in each column of rows that do not pass IsDate and IsNumeric.
You could probably leave all of...
September 1, 2009 at 3:16 pm
rjv_rnjn (9/1/2009)
All the columns in the table are currently set for varchar(max) which is a huge waste of space.
I'm not sure but is this true? I thought the "var"...
September 1, 2009 at 3:09 pm
jcrawf02 (9/1/2009)
GSquared (9/1/2009)
James Stover (8/31/2009)
Really, nature has already given us a GUID. It's called DNA. That bit of technology has been...
September 1, 2009 at 3:07 pm
jcrawf02 (9/1/2009)
As for snitch,"Ahh, sweet relief in anonymity of common names.....":-D
True enough. I'd hate to be the person whose career depended on an accurate background check on "John...
September 1, 2009 at 3:05 pm
IceDread (9/1/2009)
GSquared (9/1/2009)
I were not after trying to bash WHS all thou it's not stable enough and not fast enough for me to even consider.
You seem to have an odd...
September 1, 2009 at 3:00 pm
I were not after trying to bash WHS all thou it's not stable enough and not fast enough for me to even consider.
You seem to have an odd definition of...
September 1, 2009 at 2:33 pm
Nope. There is no such command, so far as I know.
September 1, 2009 at 2:23 pm
Performance on that kind of thing will depend largely on your table and index structure, and on how the rest of the query is written. Can you provide the...
September 1, 2009 at 12:10 pm
Viewing 15 posts - 8,476 through 8,490 (of 14,953 total)