Viewing 15 posts - 55,996 through 56,010 (of 59,078 total)
That's almost exactly correct... it would, indeed, be a multi-row insert using a loop in the GUI. Or, you could store each answer in an answer staging table if you...
June 28, 2007 at 7:01 am
Stephen Falken: Except, that I never could get Joshua to learn the most important lesson.
David Lightman: What's that?
Stephen Falken: Futility. That there's a time when...
June 27, 2007 at 11:29 pm
I gotta ask... what will this be used for?
June 27, 2007 at 6:32 pm
| For batch inserts you Call GetNextID with a @count parameter *once* |
Yep, I'm aware of that, but then you...
June 27, 2007 at 6:03 pm
Nope... gave credit where credit was due... I got lazy and said "heck, they probably don't have the right kind of index, anyway, so why bring it up?" You reminded...
June 27, 2007 at 4:54 pm
Nope... if you don't have an index, using the function or not has no effect on speed... both are the same for the most part. Only difference is if you...
June 27, 2007 at 4:52 pm
That too, will work, but as Chris Morris pointed out, any time you do a calculation/function on a column in the WHERE clause, you will decrease performance (A LOT!!) if a...
June 27, 2007 at 7:49 am
I found this in Books Online...
When the IDENTITY property is used with CREATE TABLE, Microsoft® SQL Server™ uses the NOT FOR REPLICATION option of CREATE TABLE to override the...
June 26, 2007 at 10:12 pm
Um... I gotta ask... why wouldn't 0.3333 represent all of the numbers from 0.3332(5) to 0.3333(4) in the TR model?
June 26, 2007 at 9:50 pm
Well, maybe an Index Scan... but you're (almost) exactly correct... the OR in this case will certainly allow an Index SEEK to occur if the correct index is available.
I...
June 26, 2007 at 6:21 pm
No, David... JacekO did it just right... try it and see...
--===== Declare and populate a test table
DECLARE @test-2 TABLE (RowNum INT IDENTITY(1,1), SomeString VARCHAR(10))
INSERT INTO @test-2 (SomeString)
SELECT 'A'...
June 26, 2007 at 6:10 pm
Like I said earlier to your core question... "Yes".
It's just a bad idea to shrink files that are destined to grow again because of file fragmentation. You must first...
June 26, 2007 at 5:45 pm
No problem, Noel... it's easy to see how I might have been taken because I was pretty adamant about the whole IDENTITY thing. ![]()
So,...
June 26, 2007 at 5:31 pm
Eamon,
I was a bit out of line... I should have asked why you need to do this so we can come up with the best solution for your circumstance.
So,...
June 26, 2007 at 5:02 pm
Viewing 15 posts - 55,996 through 56,010 (of 59,078 total)