Viewing 15 posts - 50,491 through 50,505 (of 59,078 total)
Heh... Grant will probably agree... I wouldn't teach recursion if they doubled my salary! I've got ethics! 😀
May 16, 2008 at 8:39 pm
It would appear that a couple folks didn't test their code... and with disasterous results for the OP...
Here's some code that demonstrates the points that JohnG and Gus were trying...
May 16, 2008 at 8:20 pm
Returning stuff to the screen is the worst way to test this. The video systems on each may be a lot different, etc, etc. Find a better way...
May 16, 2008 at 7:42 pm
There's no index on col1 or col2 yet you're aggregating and grouping on those.
Doing a copy into a heap and then putting an appropriate index on it would really make...
May 16, 2008 at 7:34 pm
Welcome aboard! Since you're new, lemme tell you that you'll get much better answers much more quickly if you do what suggested in the URL in my signature, in...
May 16, 2008 at 7:28 pm
RyanRandall (5/16/2008)
*Note that [ABCDEFGHIJKLMNOPQRSTUVWXYZ] <> [A-Z] since [A-Z] = [AbBcCdD...zZ], confusingly!
Very nice job... You just didn't use the correct Collation, Ryan... 🙂
declare @t table (name varchar(20))
insert @t
...
May 16, 2008 at 6:47 pm
What's more important: quality or consistency?
The two are not mutually exclusive, nor does one spawn the other. And, if you want it done right, you won't let any time...
May 16, 2008 at 6:34 pm
wayne.mcdaniel (5/16/2008)
May 16, 2008 at 6:02 pm
Au4848 (5/16/2008)
SELECT SomeDate AS StartDate,
SomeDate+1 AS EndDate
FROM (
...
May 16, 2008 at 5:50 pm
Thomas SNyder (5/16/2008)
Just tried a 1GB file and took 1m 23sec to work,
Just curious... How many rows and columns, Tom?
May 16, 2008 at 5:44 pm
Michael,
It'll take me a bit to digest the "Map", but very nice on the documentation! Nice to see something so well documented!
May 16, 2008 at 5:40 pm
Ian Crandell (5/16/2008)
May 16, 2008 at 5:38 pm
Ian Crandell (5/16/2008)
Jeff Moden (5/15/2008)
Looks interesting... can't download the code, though, because I'm not a member and they want too much info for my liking.
Jeff, I was able to download...
May 16, 2008 at 5:13 pm
jcrawf02 (5/16/2008)
Permissions
Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.
If I can't convince almighty DBA to make me either, I'm...
May 16, 2008 at 5:11 pm
JacekO (5/16/2008)
PS.Jeff,
It is Jacek not Jack. 😉
Dang... I'm so sorry... I'm usually the one who get's ticked when someone mispells "Jeff" (believe it or not, it happens). Old...
May 16, 2008 at 8:04 am
Viewing 15 posts - 50,491 through 50,505 (of 59,078 total)