Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,146 through 23,160 (of 59,099 total)

RE: How to efficiently import data in .rpt format into SQL 2008

halifaxdal (7/21/2014)
as I suspect if the EOF was recognized by bulk insert, I compare the two data files (the larger file costs me long time to load and even longer...
--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)

July 21, 2014 at 8:01 pm

#1731285
RE: How to efficiently import data in .rpt format into SQL 2008

halifaxdal (7/21/2014)
I found the root cause to the error, there is nothing wrong with you code but in fact when I save the format file, the UltraEdit automatically added some...
--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)

July 21, 2014 at 7:58 pm

#1731284
RE: Generate script to restore log backups

Michael Valentine Jones (7/21/2014)
I'm sure you really meant that a diff is a duplication of every page in the database that is new or changed since the last full backup,...
--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)

July 21, 2014 at 5:38 pm

#1731265
RE: Extracting VarBinary(MAX) column to Flat File - Facing Issue.

Try NOT using references to Unicode when dealing with binary data, which is no where near being Unicode.
--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)

July 21, 2014 at 5:14 pm

#1731263
RE: Insert sequence number

adonetok (7/21/2014)
I use
select max(sequence)
to find out max sequence number
I have to admit, I cringe a little every time I see a recommendation like that. There's just too...
--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)

July 21, 2014 at 5:08 pm

#1731262
RE: What would your answer be for this question?

The question ends with the following...
List 3 other areas to look for optimization opportunities. (Personal experiences are preferred over hypothetical scenarios). "
My answer would be...
Based on nearly 20 years...
--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)

July 21, 2014 at 4:59 pm

#1731260
RE: How to efficiently import data in .rpt format into SQL 2008

Ok... here we go...
The first thing that I did was to download your data import file and save it to my local machine at C:\Temp\Test.txt.
The next thing I did was...
--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)

July 21, 2014 at 3:59 pm

#1731243
RE: need help parsing XML

This is a duplicate post, which only serves to split up the answers. I recommend that no other answers be posted here. Instead, please see the original post...
--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)

July 21, 2014 at 2:23 pm

#1731214
RE: Need Help parsing through the XML

Eirikur Eiriksson (7/21/2014)
Quick suggestion, don't use OPENXML, it is a depreciated feature and shoul not be used in new development. It is also much slower than XQuery/nodes methods, there are...
--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)

July 21, 2014 at 2:14 pm

#1731209
RE: How to efficiently import data in .rpt format into SQL 2008

halifaxdal (7/21/2014)
Jeff Moden (7/21/2014)
Ok... I took the time to find your BCP format file and the example text file. This is easy. All the columns need to be...
--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)

July 21, 2014 at 2:09 pm

#1731205
RE: Generate script to restore log backups

SQLRNNR (7/21/2014)
Jeff Moden (7/21/2014)
Jack Corbett (7/21/2014)
SQLRNNR (7/21/2014)
I am a bit surprised this hasn't been asked yet and it seems REALLY important.
Why do you have 2000 log backups 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)

July 21, 2014 at 12:32 pm

#1731164
RE: format the output column in destination .csv

Ah, my apologies. You said that in your original post and I was in too much of a hurry. I'm not sure how to do this on 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)

July 21, 2014 at 12:24 pm

#1731158
RE: Back from Sabbatical

bitbucket-25253 (7/21/2014)
WELCOME HOME
We have something special in our little technology niche, and I hope all of you appreciate it.
I am sure all the site users appreciate the help/knowledge it/that has...
--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)

July 21, 2014 at 11:59 am

#1731135
RE: Not Good Enough For Government Work

From the article...
It is very difficult to explain in simple terms why the principles of relational database are so important. To be able to safely determine whether a system requires...
--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)

July 21, 2014 at 11:57 am

#1731134
RE: How to efficiently import data in .rpt format into SQL 2008

Ok... I took the time to find your BCP format file and the example text file. This is easy. All the columns need to be treated as fixed...
--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)

July 21, 2014 at 11:41 am

#1731129

Viewing 15 posts - 23,146 through 23,160 (of 59,099 total)