Viewing 15 posts - 46 through 60 (of 90 total)
ThanX SSCarpal Tunnel. I felt like some adjustment was called for, and BTW- My mouse wrist and I totally relate to the "carpal tunnel"!
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
November 20, 2012 at 10:25 am
Here are the results. Looks like quite a difference from the intital settings.
namedb_filename ...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
November 20, 2012 at 9:01 am
Would timing-out errors be a symptom of improper TempDB settings? Especially, during peak times. We are in our busy season right now there is a lot of...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
November 20, 2012 at 6:49 am
Thanx OPC.THree.
I normally write it as:
" AND isnull(p.TrackingNumber,'') <> '' "
Though you are right. Neither NULLs or blanks should be returned in this query.
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
June 19, 2012 at 6:26 am
I'd never seen > used against a string, but I have tried a couple of queries and do get results. I just wasn't sure if I was getting the...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
June 18, 2012 at 9:44 am
what would happen if both variables had been set to the same size (big enough to accept the long answer)?
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
February 17, 2012 at 1:58 pm
The -n option in BCP is supposed to import to it's native format. I haven't had the kind of problem you describe, but then again my business requirements may...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
February 17, 2012 at 1:09 pm
No solution on my end. I feel that MSG.exe could be used with cmdshell, but haven't spent the time to experiment. It's more cumbersome than the old Net...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
December 15, 2011 at 5:51 am
My 1 semester of Spanish in college didn't help me very much today, but I still have the book and think I can figure out the text.
This is...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
October 19, 2011 at 11:18 am
Good stuff! Though not necessarily related, I have found the practice of allocating a small hard drive space for OS and installed programs can come back to bite you...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
October 10, 2011 at 11:00 am
We also use a unique record ID field in many of our tables. Very handy for updates and confidence that you are updating the exact record you just selected....
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
July 27, 2011 at 7:08 am
about 11mb. I noticed it a couple weeks ago and thought it odd, but got sidetracked. I'm a rookie on Server 08 and this one is running SQL...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
May 18, 2011 at 7:26 am
My research shows it was discontinued by MS. (don't you just love 'em?) I've tried WinSent, Sent and WinSentMessenger. None of them work. Also tried the native...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
May 13, 2011 at 1:03 pm
I'm a believer. After spending the better part of two days researching and trying different methods, I used the wrapper and it worked.
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 25, 2011 at 7:04 am
Good stuff, and timely for me since I've been working on moving 10GB of data to a remote location. After waiting 1.5 hours using an INSERT/SELECT I realized it wasn't...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 21, 2011 at 6:32 am
Viewing 15 posts - 46 through 60 (of 90 total)