Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,616 through 15,630 (of 59,097 total)

RE: Good or slow? 1 min to load 600M text format into SQL

TheSQLGuru - Friday, February 17, 2017 3:14 PM
As other's have said REALLY efficient loading of very large amounts of data (and then...
--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)

February 17, 2017 at 4:16 pm

#1929215
RE: Good or slow? 1 min to load 600M text format into SQL

IIRC, BULK INSERT doesn't require you to disable the clustered index to get minimal logging if setup correctly and the data is in the same order as the CI 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)

February 17, 2017 at 11:27 am

#1929175
RE: Check if xp_cmdshell is turned on and flip the bit

I'll send it to the two of you over the weekend. Thanks for your interest. I'm converting it to an article so I'd be interested in your feedback, good 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)

February 17, 2017 at 11:21 am

#1929172
RE: Check if xp_cmdshell is turned on and flip the bit

SQLShark - Friday, February 17, 2017 6:13 AM
Jeff, in our environment it is a security violation to leave this turned on. 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)

February 17, 2017 at 8:21 am

#1929132
RE: Good or slow? 1 min to load 600M text format into SQL

I just gave you one. Compressed backups/restore if the data is in a table on another server.
And it wouldn't be A best practice... it would be MANY best...
--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)

February 17, 2017 at 7:49 am

#1929115
RE: Tally generator

Oh yeah... I got that from the beginning. Still, it's useful by itself and it would be nice if people could find it. But, it's your script. I'm just making...
--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)

February 17, 2017 at 7:43 am

#1929110
RE: Tally generator

Sergiy - Thursday, February 16, 2017 10:36 PM
I had status "Commited" for 2 years in a busy Production system.Not a soul complained.Till...
--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)

February 16, 2017 at 11:16 pm

#1929032
RE: Convert first column in row without duplicate values, and second column in rows

benkraiemchedlia - Thursday, February 16, 2017 12:59 PM
Hi,
I have a table with 2 columns : questions, answers. The same questions can 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)

February 16, 2017 at 10:39 pm

#1929031
RE: Good or slow? 1 min to load 600M text format into SQL

If the 6TB lives in a database on another machine and you have the ability to do a compressed backup, then do it using compressed backup/restore. My main server contains...
--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)

February 16, 2017 at 10:29 pm

#1929028
RE: Timeout errors for SQL Jobs

If it worked fine before and started misbehaving 3 days ago, it sounds more like a NIC or a switch or a cable going/gone bad. I've had each of those...
--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)

February 16, 2017 at 10:23 pm

#1929027
RE: Tally generator

Can't believe whomever the editor was didn't catch the missing "y" in the title. They can fix it for you, Sergiy.
Good to see you've finally picked up 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)

February 16, 2017 at 10:04 pm

#1929026
RE: Check if xp_cmdshell is turned on and flip the bit

Great script, Edward. I'd only use it once, though, because I'd turn it on and leave it on. There's no extra safety to having it turned off.
--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)

February 16, 2017 at 10:02 pm

#1929025
RE: Delete the duplicate records of table having only one column

JasonClark - Thursday, February 16, 2017 8:45 PM
PS: Please perform delete operation within a transaction.
I have to ask "why"? ...
--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)

February 16, 2017 at 9:50 pm

#1929024
RE: Trouble with openxml query

Sergiy - Thursday, February 16, 2017 5:46 PM
Don't Americant protect the wrong thing?
Heh... hell no. That's a part of the problem 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)

February 16, 2017 at 6:26 pm

#1929011
RE: Non-ANSI equal join - SQL 2012

drew.allen - Thursday, February 16, 2017 11:16 AM
Jeff Moden - Wednesday, February 15, 2017 9:22 PM
--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)

February 16, 2017 at 4:19 pm

#1929003

Viewing 15 posts - 15,616 through 15,630 (of 59,097 total)