Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,631 through 15,645 (of 59,101 total)

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
RE: How to “step through” a list of values creating a record for each value

Why not just load the ACE drivers and read directly from the spreadsheet?
--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:03 pm

#1928763
RE: Why dont i get the correct XML format while querying?

sgmunson - Wednesday, February 15, 2017 9:29 AM
Sorry, but that's not an option that I know of. You have the two...
--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 9:52 pm

#1928761
RE: Training Computer Scientists

P Jones - Wednesday, July 1, 2015 1:12 AM
As an IT pro and graduate, I've been involved in the recruitment of programmers...
--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 9:49 pm

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

Lynn Pettis - Wednesday, February 15, 2017 10:08 AM
Sue_H - Tuesday, February 14, 2017 3:54 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 15, 2017 at 9:22 pm

#1928757
RE: Can anyone recommend a working sample ETL package created with SSIS?

halifaxdal - Wednesday, February 15, 2017 12:34 PM
I am looking for a working package, I came across this one from Microsoft's Tutorial,...
--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 9:16 pm

#1928754
RE: How do page splits work with large amounts of sequential data inserted in the middle?

Sioban Krzywicki - Wednesday, February 15, 2017 10:14 AM
Let's say I have a table with a large number of records 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)

February 15, 2017 at 9:12 pm

#1928753
RE: Performance improves after reboot

RVO - Wednesday, February 15, 2017 9:22 AM
We reboot the whole server (Windows 2012 Server box).
Yes, It's shared memory and I pointed...
--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 3:56 pm

#1928744

Viewing 15 posts - 15,631 through 15,645 (of 59,101 total)