442 reputation
513
bio website blog.richardhartness.com
location Charlotte, NC
age 33
visits member for 2 years, 11 months
seen Jun 17 at 16:53

I am a software architect, living in Charlotte, NC.


Jul
2
awarded  Curious
Apr
8
awarded  Good Question
Jan
6
awarded  Nice Question
Dec
9
awarded  Notable Question
Sep
11
awarded  Yearling
May
14
awarded  Caucus
Mar
29
comment Long time, sporadic 'String or Binary data would be truncated.' Wisdom would be appreciated
I seem to recall that I tried this once a long time ago. Either I couldn't get it to work in the SP or, no, it didn't work.
Mar
28
comment Long time, sporadic 'String or Binary data would be truncated.' Wisdom would be appreciated
@JNK, I appologize that I must have been unclear. This happens randomly to different users. My user base is about 200 users. I've had, oh... 20 people call me on this problem in 6 years. Each have the exact same issue and when I rebuild their DBs it goes away, often to never return.
Mar
28
comment Long time, sporadic 'String or Binary data would be truncated.' Wisdom would be appreciated
you are possibly closest to an actual answer. I created the initial db structure years ago, using varchars. Still don't know why this would be a problem when a user can rebuild the db, and relaunch the process with the same inputs and it "magically" start working. Still, I've come to hate varchars because they've caused more grief than they are worth. Now, I strictly stick with nvarchars, even though they are "2x" the size of vrachars.
Mar
28
comment Long time, sporadic 'String or Binary data would be truncated.' Wisdom would be appreciated
@JNK, fair enough. But how could that happen? Firstly, nothing plays around with the DBs, other than my thin-client application. Even those updates are delegated from the server and I haven't pushed out a db update in, oh... 2 years? Furthermore, these updates when applied, come from SQL Scripts that are downloaded and execvd against the user's DB. I mention this because if anything is changing these databases, it has to becoming from me. Or something "magical" is going on that I am oblivious to.
Mar
28
comment Long time, sporadic 'String or Binary data would be truncated.' Wisdom would be appreciated
There is no way the definitions could change. My application is 100% responsible for the management of the database, and I haven't updated the structure or any associated stored procedures in years. Also, profiler hasn't been helpful in the past. I never could get anything useful from it, even when I installed it on a user's PC and tried to analyze the situation. It's also worth noting that this isn't a "copy" of a server database. This is a simple(-ish) DB that caches data and has a couple stored procedures for building tables for printed documents. That's all.
Mar
28
asked Long time, sporadic 'String or Binary data would be truncated.' Wisdom would be appreciated
Mar
21
comment In what data type should I store an email address in database?
Also, MS documentation states that there are 8-bit code pages, however, the article I read on MSDN didn't reference a specific page. So, I could be wrong. The documentation say it exists (even for SQL 2008) but I haven't seen it.
Mar
21
comment In what data type should I store an email address in database?
@AaronBertrand, well I've never had such a case where I needed strict 8-bit chars. The reason why I became a proponent of what I've stated is because almost every time I've thought I could get away with a varchar field on a column that would contain large amounts of data, eventually someone has manages to throw a unicode char at it, at some point. This has broken exports and nightly processes. After a while, it just wasn't worth the headache to use varchars instead of nvarchars.
Mar
20
comment In what data type should I store an email address in database?
Aaron Bertrand: I would personally disagree. IMHO, if you are absolutely sure that your character data is going to be strictly 8-bits in length per character, AND DB size is an issue, just change the collate code-page of your nvarchar field to a code-page that supports 8-bit characters. I know converting an varchar to nvarchar or updating the code-page of a column is practically nuanced. However, I think sticking with a forward-moving, newer data types, rather than those that were derived from legacy mindsets, is good practice.
Mar
20
comment In what data type should I store an email address in database?
FYI, worth a read: dba.stackexchange.com/questions/5346/… Is there any specific need that would necessitate the use of a varchar. As a good rule of practice, use nvarchar unless it is otherwise absolutely necessary.
Mar
7
accepted Is there a way that I can export a list of all table triggers on a server?
Mar
7
comment Is there a way that I can export a list of all table triggers on a server?
Bingo! And this one helped my find the triggers that I was looking for. I could have sworn I had scripted out that database too. They must have been using a DBA mind trick. >_>
Mar
7
comment Is there a way that I can export a list of all table triggers on a server?
Thank you. This seems to work for SQL 2005, is there a variation that will work for SQL 2000?
Mar
7
asked Is there a way that I can export a list of all table triggers on a server?