|
As a follow up to: http://stackoverflow.com/questions/105400/what-are-indexes-and-how-can-i-use-them-to-optimize-queries-in-my-database where I am attempting to learn about indexes, what columns are good index candidates?, specifically for an mssql database...
Started by mmattax on
, 12 posts
by 12 people.
Answer Snippets (Read the full thread at stackoverflow):
Any column....
(Also, primary keys make such good indexes down the writes and never get used.
They are unique and must have a value specified.
In general (I don't use mssql so can't comment specifically), primary keys make good indexes.
|
|
Can someone tell me why there are so little good programming tutorials in general?
I know one site, and that's for flash, but I don't use that much flash: http://www.gotoandlearn.com/
I think it's a nice place. All tutorials are video, you see it happening...
Started by Vordreller on
, 8 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
No videos understand it, they say the tutorial....
W3schools.com have some good short tutorials on web and xml related things.
good programming tutorials in general?
Because most people read a tutorial and if they don't programs too...
|
|
Using Adobe ColdFusion version 8 and below, all my cfqueries are wrapped in a try catch that calls a function in database.cfc called "CatchError".
<cftry> <cfquery datasource="myDatasource"> UPDATE TableName SET ... WHERE ID = <cfqueryparam...
Started by cf_PhillipSenn on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Edit - Here is a general handler using the cferror approach: http to error handling in general, so you may find some useful answers in language-agnostic questions.
To log problems like that.
|
Ask your Facebook Friends
|
In general, I occasionally have a chain of nested macros with a few preprocessor conditional elements in their definitions. These can be painful to debug since it's hard to directly see the actual code being executed.
A while ago I vaguely remember finding...
Started by Tyler on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Can you replace them with....
This might not be applicable in your situation, but macros really do hamper debugging and often are overused and avoidable .
Debug the dissasembly with the symbols loaded.
Gcc -E will output the preprocessed source to stdout.
|
|
Just started a new coop workterm and using a solaris machine with bash as my shell. Know basic commands in bash:
ls, pwd, find, cd, mkdir, rm, grep ...
That is basically all I need to do my job (working in java with intellij), but would like to be able...
Started by sixtyfootersdude on
, 11 posts
by 11 people.
Answer Snippets (Read the full thread at stackoverflow):
And don't forget the SO sister sites; superuser.com and serverfault.com - they are a good source shells by Example (Ellie Quigley) is good as a primer on both using shells as your CLI and scripting.
|
|
I want a compact and portable computer... definitely less than a foot wide, 10 inches is plenty of screen.
I've been looking for a while, waiting for something suitable to come out, but am constantly dissappointed - all the mini-notebooks that come out...
Started by Peter Boughton on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at superuser):
Samsung Q45 or....
For example, check pricerunner to find a specific model.
I've had good luck with the smaller Mac laptops the latest generation of netbooks and are suitable for general use.
A friend really likes their EeePC running Ubunta.
|
|
My program is written in C for Linux, and has many functions with different patterns for return values:
1) one or two return n on success and -1 on failure.
2) some return 0 on success and -1 on failure.
3) some return 1 on success and 0 on failure (I...
Started by James Morris on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
In case something fails, I would ....
In that case testing for -1 will surely be a bad idea .
One condition I can think of where your above methodology can fail is a function that can return any value including -1, say a function to add two signed numbers .
|
|
14 Welcome ‹ General Discussions
Started by chimuchi on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at afternysc):
Good mornin
[ via Mobile ] Olokiki oru, A f'ida sile, f'egungun eran.
[ via Mobile ] Life is sweet if we live it simple.. .
Good morning
[ via Mobile ] What iz Nize will always be Nice! Good morning...
|
|
I'm using SQLAlchemy's declarative extension. I'd like all changes to tables logs, including changes in many-to-many relationships (mapping tables). Each table should have a separate "log" table with a similar schema, but additional columns specifying...
Started by Ken on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
And my favorite solution is to extent Session.commit() method to accept optional .
This way is not as good.
|
|
For reference, this would be for Visual Studio 2008 with a fair amount of WinForms working with the VS Designer.
Given the same price bracket, would there be certain specs you look for in a development rig vs what one would get for a gaming machine?
Edit...
Started by Davy8 on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
I would rather invest.
Video card is not an important factor...
Not be a very good gaming machine.
|
