Viewing 15 posts - 46,456 through 46,470 (of 59,062 total)
I agree... this one looks like RBAR because it does something for each row... but so do all of the queries built in SQL Server. The difference here...
December 22, 2008 at 5:12 am
AnzioBake (12/22/2008)
You can write an SP that given the Source Table or...
December 22, 2008 at 5:01 am
Hooman Shamsborhan (12/21/2008)
So what I've done so far is not going to help me at all?
I don't believe so... I believe you need to setup a new single partition table,...
December 22, 2008 at 4:50 am
GilaMonster (12/22/2008)
Jeff Moden (12/21/2008)
So, what is it, supposedly?
Spatial, xml, hierarchy, etc. The 'rich' data types that some bright spark in marketing thought meant SQL was evolving beyond a relational database....
December 22, 2008 at 4:46 am
timothyawiseman (12/21/2008)
December 22, 2008 at 4:42 am
I believe you're looking for ALTER TABLE / SWITCH. There's a few caveats to it, but it's all covered in Books Online.
December 21, 2008 at 6:20 pm
Nah... too much work, Kevin. 😉
December 21, 2008 at 5:15 pm
So, what is it, supposedly?
December 21, 2008 at 3:01 pm
Is it actually a unicode file you're trying to import? IF it is, try changing -c to -w in BCP and adding the [font="Arial Black"]DATAFILETYPE = 'widechar'[/font]...
December 21, 2008 at 2:53 pm
[font="Courier New"]WHILE (1 = 1)
BEGIN
...
...
...
WAITFOR DELAY '0:00:10' --delay 10 seconds
END[/font]
Perhaps it's just me and maybe I'm not getting it, but it looks...
December 21, 2008 at 2:11 pm
timothyawiseman (12/21/2008)
December 21, 2008 at 2:03 pm
Well, well! Glad to see that the grand misunderstanding as to what is "Set Based" is and is not, prevails. Odd, too, that I've advocated the use of...
December 20, 2008 at 7:09 pm
It'll work if you put the SELECT LIST into the same order as the COLUMN LIST in the table definition. It would be better if the INSERT had a...
December 20, 2008 at 4:41 pm
This type of denormalization is not normally a good thing to do in a database... why do you need to do this? What is the purpose?
December 20, 2008 at 4:26 pm
Now, it's just missing the FROM clause.
December 20, 2008 at 6:23 am
Viewing 15 posts - 46,456 through 46,470 (of 59,062 total)