Viewing 15 posts - 271 through 285 (of 582 total)
POST THE CODE
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 19, 2006 at 4:03 am
might be worth trying
>=
''
then.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 19, 2006 at 3:45 am
Yes it would.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 19, 2006 at 3:38 am
Agree float is absolutely inappropriate for a surrogate key.
The efficency of a key column depends mainly on two things: how big it is, and how straightforwardly it is compared.
Using character data...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 19, 2006 at 3:15 am
POST THE CODE !!!!
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 19, 2006 at 2:56 am
There's no way you should have a trigger that takes 20s. Optimise the code or get it out of the trigger and do it some other way. Doing it in a...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 19, 2006 at 2:53 am
There is no advantage from the POV of storage or efficiency in reducing the maximum size of varchar fields. The only reason to do so is to avoid overrunning the...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 19, 2006 at 2:40 am
Because all inserts have to occur at the 'same' point i.e. at the end.
Of course there are about 587 other considerations which also feed into the decision process...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 18, 2006 at 1:53 pm
>(pretty cool... even though he didn't test it {had 2 "AS" in it}, he almost got it right)...
Even cooler when no-one realises you haven't tested it!
BTW, MAX() might be...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 18, 2006 at 9:11 am
It's only a problem if access to this table is done in a multiple-statement transaction, or if for some bizarre reason you used a massive query to read and write from...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 18, 2006 at 9:02 am
Jeff M: >If someone was foolish enough to build an Oracle-like "sequence table" (for next ID's and the like), first, find them and shoot them out of a cannon...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 18, 2006 at 7:23 am
Both tables being scanned, one repeatedly (the lazy spool.) Put a compound index on all join columns on both tables, in the same order on both tables. Add any remaining columns...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 17, 2006 at 8:50 pm
EM = Enterprise Manager
SSMS = SQL Server Management Studio
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 17, 2006 at 8:37 pm
For point-in-time, look at sysprocesses. If a series of snapshots rather than a complete audit is ok, you could just poll it every few seconds. I don't think that would...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 17, 2006 at 8:33 pm
It's not necessarily a mistake to store the values as varchar. Often ID 'numbers' are not really numbers, even though they may be restricted to a very limited subset of...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 17, 2006 at 7:41 pm
Viewing 15 posts - 271 through 285 (of 582 total)