Reputation
502
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 5 15
Impact
~24k people reached

Sep
26
awarded  Famous Question
Sep
11
comment How can I avoid writing to the Transaction Log file when I drop, create and reload data to a table?
Thanks Aaron. I need to move on to another task. If I get a second later today, I'll do just that.
Sep
11
comment How can I avoid writing to the Transaction Log file when I drop, create and reload data to a table?
Thanks @AaronBertrand. I'll have to do a little bit of further research. This could do the trick.
Sep
11
comment How can I avoid writing to the Transaction Log file when I drop, create and reload data to a table?
What I need to do is create a snapshot process that pulls certain data from massive audit table on our production server. I want to move the pertinent data to our dev server, and create a process that can run nightly/weekly to get the most recent changes. However, I need to do an initial population from the full audit table. I'm new to the company and I do not know anything about their data structures. Thus, I need to pull the data, do a bit of analysis and then fine-tune my queries.
Sep
11
asked How can I avoid writing to the Transaction Log file when I drop, create and reload data to a table?
Jun
25
awarded  Popular Question
Feb
9
awarded  Popular Question
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.