Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,861 through 19,875 (of 59,072 total)

RE: Need Help on SQL Insert Query

Understood that the data is coming from an application. How are you passing the data to the database?
--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 11:25 am

#1820332
RE: Help Needed in Processing Data

KGJ-Dev (8/16/2015)
ahh...
I could figured out the logic around. Below is the try for my another question and it works fine
...
--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 11:23 am

#1820331
RE: Help Needed in Processing Data

KGJ-Dev (8/16/2015)
Hi Jeff,
All your concerns are very valid and Regarding table name, age datatype, ID are just sample structure to play with data on this thread. As i said 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 11:20 am

#1820330
RE: Help Needed in Processing Data

Heh... ya just gotta love the nuances of some of these things along with the lack of documentation on them. For example...
1. It's documented that if you use...
--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 9:23 am

#1820325
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

Viewing 15 posts - 19,861 through 19,875 (of 59,072 total)