Viewing 15 posts - 46 through 60 (of 89 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"!
November 20, 2012 at 10:25 am
Here are the results. Looks like quite a difference from the intital settings.
namedb_filename ...
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...
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.
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...
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)?
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...
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...
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...
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...
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....
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...
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...
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.
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...
April 21, 2011 at 6:32 am
Viewing 15 posts - 46 through 60 (of 89 total)