quote: Darn it brain is fried with the new baby here. What do you mean by covering index, jpipes? For some reason my mind has gone blank (happening a lot recently too). isn't a covered index an index that contains all fields of a table, or the SELECT statement? Frank
2003-09-04
DataGuard, I wanted to do the "normalization" in the SELECT statement (thus the reason for a function). From your post, it sounds like that won't be possible and as far as I know, one can't use a SP in the SELECT statement. Looks like I will have to rethink my process. Darn. 🙂 Thanks for […]
2003-09-02
Dale, http://www.freetranslation.com/ I use it sometimes with my French customers and although it is better than babelfish it still doesn't replace linguistic ability. For some vague reason my study of the French language did not have much to do with computers and more with ordering a good French red wine from the waiter. Hindsight is […]
2003-08-27
If your message can be less than 255 characters, you might want to check out the extended stored procedure xp_sprintf. If you have ever done C programming, you will feel right at home with this stored proc. Here is an example: declare @variable1 nvarchar(10) declare @variable2 nvarchar(10) declare @message varchar(255) set @variable1 = 'Betty' set […]
2003-08-27
1 reads
quote:In the end I dumped the application role and harassed the developer to change his code. If there were a way to “undo” or roll back the application role setting, this would not have been a problem.I agree wholeheartedly. While a simple stored procedure can reset client settings, nothing exists to reset an app role […]
2003-08-27
2 reads
I agree that there is probably a design flaw/oversight if there are that many NULL's. However, if a column in a table has values that are REALLY lopsided, like a bit column with 99% of values set to one value, then an index is helpfull in some cases if you are only querying for the […]
2003-08-27
Babel fish makes the funniest translations. It always translates the language so that the speaker sounds as if they have just landed from Mars and are using a dictionary to speak to you. Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance. Patrick
2003-08-26
Ich weiss jetzt, dass ich gesagt haben sollte: "Ich gratuliere. Bis mein naechstes EMail..." Ich versuche immer besser zu sein. Ron
2003-08-26
1 reads
2003-08-25
Thanks for all the input. I don't think I expressed my problem very well. Perhaps I should have asked... 'What is the best way to initiate a VB program on another computer'. Thanks again!
2003-08-25
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers