Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,116 through 23,130 (of 59,099 total)

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

halifaxdal (7/22/2014)
For the 400M file, I remove the first two rows (non data), I also added BULKSIZE = 200 to the Bulk Insert, and I was able to load all...
--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 23, 2014 at 9:34 pm

#1732007
RE: 1 Quick question for all the DBA's

Lynn Pettis (7/22/2014)
Jeff Moden (7/22/2014)
Also not being snarky, but I've found that the reason a lot of people turn to PowerShell is because they don't actually know what they're doing...
--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 23, 2014 at 9:03 pm

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

halifaxdal (7/23/2014)
Alvin Ramard (7/23/2014)
Reading about this after all the discussion, I'm starting to think it would have been a lot faster to try the import with VB or C#, or...
--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 23, 2014 at 8:48 pm

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

David Burrows (7/23/2014)
If your file ends with a 'rows affected' line or extra CRLF then AFAIK you will not be able to import using the format file as the line...
--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 23, 2014 at 8:45 pm

#1732004
RE: Index grows really fast!

While I agree with and subscribe to the basic concept that indexes might not need to be defragmented to perform well and that rebuilding an index that is quickly fragmented...
--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 23, 2014 at 8:24 pm

#1732003
RE: disk space 90% full...

samking (7/21/2014)
If the disk contains only data files...than what action we have to take......
My apologies. For some reason, I thought you were the original poster. My only excuse...
--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 23, 2014 at 8:05 pm

#1732002
RE: disk space 90% full...

paul.knibbs (7/23/2014)
Jeff Moden (7/21/2014)
samking (7/21/2014)
If the disk contains only data files...than what action we have to take......
But it doesn't, does it. Notice that's not a question because you previously...
--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 23, 2014 at 7:24 pm

#1732000
RE: SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

snh 51890 (7/23/2014)
Nice article. This is a typical operation when the server is in a SOHO type situation or maybe some older XP-era gear that is co-located somewhere. ...
--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 23, 2014 at 11:48 am

#1731880
RE: SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

sgross 10581 (7/23/2014)
How could we extend this code to add the ability to convert datatypes, like parse a datetime.
Also so do an Upsert per row?
Unless you can guarantee that...
--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 23, 2014 at 11:47 am

#1731878
RE: SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

I'm actually very torn on this article...
On the one hand, I agree. As noted by some of the others, the article would certainly have benefitted from the inclusion of...
--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 23, 2014 at 9:27 am

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

halifaxdal (7/22/2014)
Jeff Moden (7/22/2014)
David Burrows (7/22/2014)
Jeff Moden (7/21/2014)
Think of it as a "Unicode file prefix". It actually means something else specifically and I can't think of the precise meaning...
--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 22, 2014 at 2:52 pm

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

David Burrows (7/22/2014)
Jeff Moden (7/21/2014)
Think of it as a "Unicode file prefix". It actually means something else specifically and I can't think of the precise meaning but that's mostly...
--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 22, 2014 at 12:13 pm

#1731543
RE: Is It Time To Clear Out Those Quirky Functions?

JustMarie (7/18/2014)
We got hit by ISNUMERIC early. It will convert text that happens to be valid hexadecimal into a positive hit. So we went to PATINDEX to find...
--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 22, 2014 at 12:05 pm

#1731536
RE: Need Help parsing through the XML

Evil Kraig F (7/21/2014)
Jeff Moden (7/21/2014)
I have to admit that using XML to do such a thing (and, yes, I have send data "over" for the very same reason you've...
--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 22, 2014 at 11:59 am

#1731533
RE: 1 Quick question for all the DBA's

Also not being snarky, but I've found that the reason a lot of people turn to PowerShell is because they don't actually know what they're doing in SQL 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)

July 22, 2014 at 11:54 am

#1731532

Viewing 15 posts - 23,116 through 23,130 (of 59,099 total)