Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,891 through 19,905 (of 59,098 total)

RE: Help Needed in Processing Data

There's something else going on here. Here's the error that I get.
Msg 4866, Level 16, State 1, Line 1
The bulk load failed. [font="Arial Black"]The column is too long in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 8:28 am

#1820322
RE: Help Needed in Processing Data

KGJ-Dev (8/15/2015)
Hi Jeff,
Thank you
yes, the end of character will be CRLF (carriage return line feed). also i tried with second option which was mentioned in my samplescripts attachment in my...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 8:20 am

#1820320
RE: SQL Joins Question

Gosh, I'd be real careful here, Eirikur. While your good code certainly does what was asked, it will fail if table SampleData2 is ever correctly used for its apparent...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 7:53 am

#1820319
RE: Help Needed in Processing Data

KGJ-Dev (8/15/2015)
Please find the attached file for the reference and please let me know if i need to provide any additional info.
thank you for your precious time.
Heh... that's also generated...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 15, 2015 at 11:21 pm

#1820306
RE: Help Needed in Processing Data

That's good but I really need the 5 lines from the file so that I can tell what the actual end of line character is.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 15, 2015 at 9:28 pm

#1820302
RE: query help

Yes. And I'm going to do this in a manner that no one else might because the queries end up being nasty fast and it prepares your data for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 15, 2015 at 3:39 pm

#1820297
RE: query help

peterausger (8/15/2015)
can some one here please help me?
Help is on the way. I need about another half hour or so to finish my answer.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 15, 2015 at 2:45 pm

#1820296
RE: CPU utilization alert through WMI Alert.

SQL-DBA-01 (8/14/2015)
Guys, any update? Advise? Thoughts? Suggestion(s)?
Yes. Don't do CPU utilization alerts through SQL Server. Do them through Windows Server.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 15, 2015 at 11:00 am

#1820293
RE: Nope to NoOps, No way to NoDBA

From the article:
Because we as an industry are particularly cursed with the habit of repeating our mistakes rather than learning from them, the voice of experience is mistaken for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 15, 2015 at 10:45 am

#1820290
RE: Help Needed in Processing Data

KGJ-Dev (8/14/2015)
Hi Jeff,
Thanks for your response and really it's helpful. I did try with Bulk insert and it's very fast.unbelievable. it just took 6 seconds for half million records. So...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 15, 2015 at 9:16 am

#1820289
RE: Regular activities of SQL DBA (L1 person).....

srivastavanitesh16 (8/15/2015)
best article on daily task :):-)
Lets see what happens next...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 15, 2015 at 7:12 am

#1820281
RE: Errors when inserting rows from a linked server

g.britton (8/15/2015)
On topic but slightly different subject, what is the purpose for having 548 MAX columns? Not a challenge, Gerald... just curious.
wish I knew! I've been asked to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 15, 2015 at 7:07 am

#1820280
RE: Errors when inserting rows from a linked server

On topic but slightly different subject, what is the purpose for having 548 MAX columns? Not a challenge, Gerald... just curious.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 14, 2015 at 9:28 pm

#1820264
RE: Are the posted questions getting worse?

The good part about it is that all hardware has had to become bigger, faster, and cheaper to be able to handle even just the tag bloat never mind the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 14, 2015 at 7:01 pm

#1820262
RE: Help Needed in Processing Data

Heh... I thought it might be a little more complicated than what your first post suggested.
For these types of things, I don't use SSIS but you might want to because...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 14, 2015 at 6:40 pm

#1820260

Viewing 15 posts - 19,891 through 19,905 (of 59,098 total)