Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,586 through 15,600 (of 59,063 total)

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
RE: Trouble with openxml query

patrickmcginnis59 10839 - Thursday, February 16, 2017 11:52 AM
I'm curious that if SSN's ideally never make it onto computers, then why 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)

February 16, 2017 at 4:17 pm

#1929002
RE: Training Computer Scientists

Grant Fritchey - Thursday, February 16, 2017 6:09 AM
Reading back through this set of comments is interesting. It does seem to boil...
--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 8:09 am

#1928855
RE: CTE Recursive Query

The posted data won't load. It's missing quotes.
Msg 102, Level 15, State 1, Line 23
Incorrect syntax near '.1'.
Msg 102, Level 15, State 1, 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)

February 15, 2017 at 10:37 pm

#1928767
RE: Trouble with openxml query

pisorsisaac - Sunday, February 12, 2017 3:01 PM
Thanks much to those who helped me, I appreciate it.
To whoever it was that apparently...
--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 15, 2017 at 10:07 pm

#1928764

Viewing 15 posts - 15,586 through 15,600 (of 59,063 total)