Viewing 15 posts - 55,396 through 55,410 (of 59,067 total)
Must be...
EXEC (@Cmd)
August 11, 2007 at 8:33 pm
I noticed that the growth rate is set to 10%. At the current size, that means that then next growth will be approximately 16 gig... that will take quite a...
August 11, 2007 at 8:33 am
I believe what you're looking for is a kind of "histogram". The other solutions are great but if there are any unexpected characters, the cross-tabs will miss them and, if...
August 10, 2007 at 7:40 pm
Have had similar problems in the past and have found it quicker to re-export the desired rows and re-import them using the parsing of Bulk Insert or BCP.
August 10, 2007 at 6:36 pm
Hey, Phil...
I just went back and read my reply about testing it... it sounds a lot sarcastic and I didn't mean to make it sound that way. Hope you took...
August 10, 2007 at 6:25 pm
Now, there's some common sense thinking outside the box... thanks, Lowell. ![]()
August 10, 2007 at 6:20 pm
No, no... he's not miffed... it's a bit of a language barrier thing and, because of that, he comes off as being short... He's really trying to help you think...
August 10, 2007 at 6:18 pm
Thanks, Lynn...
Heh... I don't have 2k5, either... was going on someone else's word... thanks.
August 10, 2007 at 11:27 am
Just additional info... Foreign Keys must reference either a PK or a column with a UNIQUE index... that not-with-standing, you still can't reference a computed column as a Foreign Key...
August 10, 2007 at 10:26 am
| I have a table which contains a date field which is a string with format 'yyyymmdd' ... |
It's almost...
August 10, 2007 at 8:23 am
I don't think so... foreign keys don't automatically make indexes like Primary Keys do. They make excellent candidates for indexes, though.
August 10, 2007 at 7:59 am
Pretty sure "OR" can't be used here....
SELECT CASE RowNum
WHEN 1 OR 10 THEN '1 or 10'
ELSE 'Not 1 or 10'
END
FROM jbmTest
WHERE RowNum <=10
Server: Msg...
August 10, 2007 at 7:50 am
The only thing you can pass to a function are scalar values... can't pass a query.
August 10, 2007 at 7:45 am
Viewing 15 posts - 55,396 through 55,410 (of 59,067 total)