Viewing 15 posts - 55,966 through 55,980 (of 59,072 total)
Try it through Enterprise Manager and make sure you select to option to move the pages to the beginning of the file before a shrink is attempted.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 29, 2007 at 9:18 pm
Michael,
SQL is not SQL... Access has a slightly different set of commands, clauses, and features... you might want to try posting on the Access forum... or, at least give someone...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 29, 2007 at 9:16 pm
Sorry about that... the other code had a problem when the two strings were different lengths (doh!)... I fixed the function code above...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 29, 2007 at 9:09 pm
Ah crud... I've got a fly in the ointment... didn't test the majority of possibilities... I'll be back...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 29, 2007 at 8:56 pm
Ok, a function it is... still using the Tally table 'cause I don't have 2K5 to test the code with...
CREATE FUNCTION dbo.fnCharCompare
/******************************************************************************
Purpose:
Compare the two input strings and return...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 29, 2007 at 8:51 pm
GG,
Heh... ok about the aesthetics thing... I don't agree about it being unsettling about having "skip" numbers show up, but I'm also not in your position nor do I know...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 29, 2007 at 8:23 pm
Perfect... thanks for that and great answer... good code, too! ![]()
Amrita??? How about you? You started this thread... why do YOU need to do...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 29, 2007 at 7:51 pm
Heh... and this is the SECOND one on the same subject... ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
June 29, 2007 at 7:47 pm
Heh... absolutely agree on that! And the "Hardware Support" may even include the mundane... like changing toner cartridges on a printer ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
June 29, 2007 at 7:44 pm
Wait a minute... if the first one was the "ulitimate" solution, then ????? ![]()
All of this is good, folks, but no one has asked...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 29, 2007 at 8:37 am
Wasn't generating scripts on the fly... thought you were. Was trying to get around doing that. So, I'm confused as to what you are trying to do... thought you had...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 29, 2007 at 8:32 am
Thanks, Chris... appreciate that...
Karthik... how about you... what are you going to use this for? The "select random rows" problem is pretty rare in SQL and I'm still curious what...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 28, 2007 at 11:08 pm
Thanks for coming back with that... lots of us end up wondering if we actually helped or confused. Really appreciate the feedback even if it is a bit later than...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 28, 2007 at 11:02 pm
Not being a smart guy here... was very interested in what you said...
| MS says that frequent operations requiring... |
--Jeff Moden
Change is inevitable... Change for the better is not.
June 28, 2007 at 10:14 pm
Just being a bit silly here... how about "1 man/woman IT department who knows something about everything?"
... or less silly... "DBA and Jack of all trades"?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 28, 2007 at 10:10 pm
Viewing 15 posts - 55,966 through 55,980 (of 59,072 total)