Jeff Moden

Forum Replies Created

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

RE: Get next 2 weeks

@sharonsql2013,
Many folks have correctly identified that the table should be "normalized". While it may not be possible for you to change the table, do you know how you would...
--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 10:31 pm

#1732011
RE: Source Control: As cool as ice cream or as boring as watching it melt?

I gave this one star only because I couldn't subtract one. If you'd like to know why, let me know and I'll write a quiz for you 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 23, 2014 at 10:10 pm

#1732010
RE: What does a masters degree in database administration give you

SQLTestUser (7/23/2014)
Is there any justification for pursuing a masters degree in database administration? what would be the positives and the negatives?
To be absolutely honest and with the understanding that it's...
--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:53 pm

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

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