Viewing 15 posts - 16 through 30 (of 71 total)
LutzM (7/10/2011)
... They take arbitrary length strings - is there a problem with a UDF doing the same?
Have a look at this link[/url]. there seems to be a significant...
July 10, 2011 at 5:14 pm
Jeffrey Williams-493691 (7/9/2011)
July 10, 2011 at 4:51 pm
LutzM (7/9/2011)
Step 1: fix the data type used in / returned by the functions involved (e.g. [fnsFormatAkcesit] will never exceed 17 byte, therefore the data type...
July 9, 2011 at 6:17 pm
GilaMonster (7/9/2011)
pdanes2 (7/9/2011)
How do YOU deal with possible overflows of text input? Same logic in the front-end as in the database? Wait for the DB to throw an error?
Validation in...
July 9, 2011 at 5:47 pm
LutzM (7/9/2011)
July 9, 2011 at 4:41 pm
GilaMonster (7/9/2011)
Regardless (and I'm going to be very blunt here), the use frequent of the MAX data types is an indication of poor database design.
No stress, I'm not sensitive. Senseless...
July 9, 2011 at 3:48 pm
LutzM (7/9/2011)
Ok, first off, thanks for sticking around. I've run into people in forums and newsgroups who get offended when I don't accept their blank statements as gospel. They make...
July 9, 2011 at 1:12 pm
LutzM (7/8/2011)
but where do I draw the line? 20? 50? 100? Inevitably, someone will want 101 or 102. Putting a firm number seems to me to indicate some real, defined...
July 8, 2011 at 6:31 pm
LutzM (7/7/2011)
The massive use of VARCHAR(MAX) seems to be oversized from my point of view. Not only within the functions, but also within the table...
July 7, 2011 at 5:37 pm
Nevyn (7/7/2011)
July 7, 2011 at 5:17 pm
My two cents worth: I use 'SELECT Null FROM ...' when using an EXISTS clause. As Gail has pointed out, the speed difference is probably trivial at best, more likely...
February 11, 2011 at 7:23 am
Sounds like something I should learn to use. The organization of scripts into packages seems to be an important factor - THIS table is changed, so THOSE scripts need to...
January 21, 2011 at 2:35 am
weitzera (1/20/2011)
Two things you may find helpful are to separate your prod and test environments, and to modify your database objects through scripts rather than through SSMS.
I do have separate...
January 20, 2011 at 3:58 pm
pdanes2 (1/17/2011)
You've lost me here. Do you mean when the query contains a WHERE clause, it would hunt through the index more efficiently?
No, I'm saying that since there's no...
January 17, 2011 at 5:40 pm
Grant Fritchey (1/17/2011)
GilaMonster (1/17/2011)
pdanes2 (1/17/2011)
"It doesn't work" gets little sympathy in these forums
No, because it's near-impossible to offer useful advice for that. When we have some indication what's not working,...
January 17, 2011 at 12:48 pm
Viewing 15 posts - 16 through 30 (of 71 total)