Viewing 15 posts - 2,146 through 2,160 (of 5,685 total)
Rob Schripsema (12/5/2011)
Great question. Not what I would have expected....but then, many aspects of SQLVariants are not what I would expect.
Agreed, it's like opening Pandora's Box. I'm not even...
December 6, 2011 at 12:08 pm
Yeah, I so wanted to go... a shame. Ah well, time to review who made the cut.
December 6, 2011 at 11:33 am
drew.allen (12/5/2011)
CELKO (12/5/2011)
Your approach to SQL is fundamentally wrong.
Your approach to SQL training is fundamentally wrong. Without specifics on what you think is fundamentally wrong, why you think it...
December 5, 2011 at 3:03 pm
amos-870870 (12/5/2011)
Ninja's_RGR'us (12/5/2011)
amos-870870 (12/5/2011)
unfortunatly ether/or table that gets updated will remove them from the view.I'd still try repeatable reads in a single transaction... just out of curiosity ;-).
I have not...
December 5, 2011 at 1:45 pm
Lowell (12/5/2011)
December 5, 2011 at 1:36 pm
:blink:
To confirm, you're in SQL 2000? Also, what is your current import mechanism? DTS, BCP, Bulk?
EDIT: I removed a number of confusing items I wrote. I really,...
December 5, 2011 at 12:39 pm
I'd personally approach this utterly differently, but a lot of that comes from the necessity of CYA.
Archive the file with a different file name using a move. Even a...
December 5, 2011 at 12:36 pm
jshahan (12/5/2011)
December 5, 2011 at 12:34 pm
There's a concern with the premise of this problem. Cadavre's code illustrates the concern nicely. He had to include the identity() field.
You have no indicators in the original...
December 5, 2011 at 12:13 pm
I was going to get back involved here, but after what appears to have happened over the weekend and this morning, I'll pass.
Nico, did Ninja use the best phrasing in...
December 5, 2011 at 11:43 am
GilaMonster (12/5/2011)
jcrawf02 (12/5/2011)
Did you guys see this? http://arstechnica.com/business/news/2011/12/bill-would-end-overtime-pay-requirement-for-many-more-it-workers.arsOne more reason I'm glad I'm not American...
The difference Gail is if you WERE American (or working here) you'd be getting paid enough...
December 5, 2011 at 11:40 am
Ninja's_RGR'us (12/5/2011)
amos-870870 (12/5/2011)
Ninja's_RGR'us (12/5/2011)
amos-870870 (12/5/2011)
You know what the problem was, I was using references that were outside SQLServerCentral.No sure what you mean by this?
What I mean is SQLServerCentral has a...
December 5, 2011 at 11:39 am
p-nut (12/5/2011)
CREATE TABLE ClientVersion (id int identity(1,1),...
December 5, 2011 at 11:35 am
Hm, nice problem setup, and an interesting scenario. I've never seen a difference in 1 row estimation vs. accurate 227000 row estimation NOT make a difference...
Is the 405000 base...
December 5, 2011 at 11:31 am
Ninja's_RGR'us (12/5/2011)
amos-870870 (12/5/2011)
December 5, 2011 at 11:22 am
Viewing 15 posts - 2,146 through 2,160 (of 5,685 total)