Viewing 15 posts - 45,406 through 45,420 (of 59,063 total)
Funny thing... you don't look a million members old. 😛 Congratulations Steve, SSC, and RedGate!
January 28, 2009 at 9:53 pm
Absolutely my pleasure, Trigger. Heh... thinking out side the box... a phrase I coined goes as follows...
[font="Arial Black"]Before you can think outside the box, you must first realize... you're...
January 28, 2009 at 9:46 pm
Sorry... didn't say it quite the right way... I meant that the real problem code they were trying to fix at my old company didn't budge... aggregate views of aggregate...
January 28, 2009 at 7:14 pm
Funny how people keep trying to optimize hardware... the code is the great divide... I've seen servers with all those wonder changes to the hardware occur... and the code didn't...
January 28, 2009 at 6:30 pm
Thank you, Sir. Glad to see you got the test data generator working, as well. I appreciate the performance report on that, as well.
January 28, 2009 at 6:14 pm
No problem... especially since the write-up in BOL leaves a lot for the reader to discover.
PARSENAME was designed to parse the 1 to 4 part object names (usually tables or...
January 28, 2009 at 5:55 pm
bruce.cassidy (1/28/2009)
[font="Courier New"]
CREATE [OR REPLACE] TRIGGER
{BEFORE|AFTER} {INSERT|DELETE|UPDATE} ON
[REFERENCING [NEW AS ...
January 28, 2009 at 5:35 pm
I don't believe there's an easy way to do that, all though I could certainly be wrong. The fly in the ointment is what happens if a sproc returns...
January 28, 2009 at 5:24 pm
ian McCann (1/28/2009)
I don't think I explained my needs very well.
My problem is not in fixing this ( I am actually looking forward to working with a tally table...
January 28, 2009 at 3:09 pm
Christopher,
Andrew is correct... take a look at the link in my signature below to help us help you. Thanks.
January 28, 2009 at 3:02 pm
timscronin (1/28/2009)
If you were going to convert a guid to a varchar would the conversion not be a varchar(36)?
Probably not... since all GUID's are 36 characters, why not save the...
January 28, 2009 at 2:58 pm
There's only one thing that ultimately affects fragmentation... that's growth of files. Whether you set it manually or automatically, it's file growth. The best thing to do is...
January 28, 2009 at 2:47 pm
aali_online (1/28/2009)
Fragmentation will depend on the speed of the disk subsystem
How do you figure that the speed of the disk has anything at all to do with disk fragmentation?
January 28, 2009 at 2:43 pm
ian McCann (1/28/2009)
My understanding is that manually growing the files can also contribute to physical file fragmentation.Look to the link for more information.
Actually, manual and automatic growth will both contribute...
January 28, 2009 at 2:41 pm
Viewing 15 posts - 45,406 through 45,420 (of 59,063 total)