Viewing 15 posts - 52,246 through 52,260 (of 59,070 total)
So should I go with the normalized design,...
Heh... what would be the alternative?
February 29, 2008 at 7:48 am
It's in Books Online under "DBCC Reindex"...
fillfactor
Is the percentage of space on each index page to be used for storing data when the index is created. fillfactor replaces the original...
February 29, 2008 at 7:40 am
Ummm.... here's the Books Online link...
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a54f7373-b247-4d61-8fb8-7f2ec7a8d0a4.htm
February 29, 2008 at 7:24 am
SELECT TOP 1 *
FROM yourtable
UNION
SELECT y1.*
FROM yourtable y1,
yourtable y2
WHERE y1.Date...
February 29, 2008 at 7:15 am
Yeah, but nothing like instant confirmation that you're right, huh? Thanks, Adam...
February 29, 2008 at 7:05 am
SELECT ROW_NUMBER () OVER (ORDER BY VatCode),
VatCode
FROM Partner
GROUP BY VatCode
February 29, 2008 at 6:58 am
I just create an updatable view with a "Company" column that is the union of the two tables. It's a little more complicated than that, but not much because...
February 29, 2008 at 5:43 am
The problem is that you have the Price defined as a CHAR column... it should probably be the MONEY data type if you want the 4 decimal places.
If you can't...
February 29, 2008 at 5:39 am
This looks a lot like homework... what have you tried?
February 29, 2008 at 4:47 am
Yeaup, I'll be one of the first to agree and I don't think anyone will argue with that basic rule... my point is that Jeremy produced some code that's completely...
February 29, 2008 at 4:28 am
No... not perfect... what happens in the trigger if you insert more than 1 row into the table? Are you only sending 1 email or are you sending 1...
February 29, 2008 at 4:24 am
Mark Markov (2/29/2008)
NO, I am not being honest about my lack of knowledge of SQL Server! Think about it!! If my resume is junior level, nobody will...
February 29, 2008 at 4:08 am
No problem, Manie... and, heh, yeaup... I know how it is when someone sort'a hits you between the eyes with a sharp one. 😀
One difference between the way you do...
February 29, 2008 at 4:00 am
Ian Yates (2/28/2008)
The wrong type was used for the job thus you got an incorrect answer
THAT, Sir, was the whole point! Glad someone finally got that 😉
February 29, 2008 at 3:46 am
Ummmm.... you waited until the night before an interview to cram-for-the-exam?
Good luck... 😉
February 28, 2008 at 9:24 pm
Viewing 15 posts - 52,246 through 52,260 (of 59,070 total)