Viewing 15 posts - 31,996 through 32,010 (of 59,102 total)
Sean Lange (11/9/2011)
Breakwaterpc (11/9/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 9, 2011 at 8:15 am
How do i specify that the number of rows that make up the Details for each Group must always be 15 as i sometimes return less data? The details on...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 9, 2011 at 7:54 am
What I was getting at is that folks work hard for their 4 year degree and they learn a lot of things in the process. That's the whole plan....
--Jeff Moden
Change is inevitable... Change for the better is not.
November 9, 2011 at 7:52 am
MyDoggieJessie (11/8/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 9, 2011 at 7:46 am
sotn (11/8/2011)
so their table/content is different
What about the collation of the character based columns of that table? COLLATION can make a HUGE impact on performance and, IIRC, they...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 9, 2011 at 6:04 am
michael.french 172 (11/8/2011)
I had memorized the answers to many of their questions
That's the reason why many people fail the cert exams. Memorization without understanding won't help you if they...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2011 at 8:00 pm
MyDoggieJessie (11/8/2011)
There is some reason that the file grew to 50GB. Usually we say, "leave the file as big as it grows to- if it got that big,...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2011 at 7:27 pm
You could spend a whole lot of time and money on this. For example, what is a word? As well as the normal "separated by spaces" requirement, what...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2011 at 7:20 pm
That's a start. Are you sure you have no FKs with intermediate digits? Also, have you verified by definiton that the FKs are actually duplicates?
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2011 at 6:57 pm
Great editorial, Steve. Thanks.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2011 at 6:49 pm
GilaMonster (11/8/2011)
The Dixie Flatline (11/8/2011)
daveriya (11/8/2011)
i want to order my result by 1,5 ..not with column nameHasn't ordering by column number been deprecated?
I thought so too, but I can't find...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2011 at 5:38 pm
goofbauer (11/8/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2011 at 5:15 pm
Fair enough... then let's tweak Paul's bit of Tally-Table-like prestidigitation with a fix that will handle trailing spaces on the file name... 🙂
SELECT
LEFT(d.OFFERT, LastBackslash.position - 1),
...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2011 at 4:15 pm
SQLRNNR (11/7/2011)
SQL Kiwi (11/7/2011)
Mind you,...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2011 at 4:04 pm
SQL Kiwi (11/7/2011)
Jeff Moden (11/7/2011)
I agree with TOM. I recommend you continue to use DATALENGTH for the very reason he stated.
Trouble is, that implementation now only works with Unicode...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2011 at 11:05 am
Viewing 15 posts - 31,996 through 32,010 (of 59,102 total)