Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,206 through 14,220 (of 59,101 total)

RE: Get-DbaPowerShell

Steve Jones - SSC Editor - Monday, October 2, 2017 10:49 AM
kevin77 - Monday, October 2, 2017...
--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)

October 2, 2017 at 8:03 pm

#1961981
RE: Since looping is bad, how should I accomplish what I am trying to do?

Cool. I'm thinking that we can simplify a bit. Using one of the code pieces that you posted from the collective thoughts of the people on this thread, we can...
--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)

October 2, 2017 at 7:37 pm

#1961980
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

david.leyden - Sunday, October 1, 2017 11:16 PM
I've come across this article and a few others that suggest it is a limitation...
--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)

October 2, 2017 at 6:00 pm

#1961977
RE: Since looping is bad, how should I accomplish what I am trying to do?

rmcfaden - Monday, October 2, 2017 4:42 PM
Jeff Moden - Monday, October 2, 2017 8:13 AM
--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)

October 2, 2017 at 4:51 pm

#1961973
RE: sa password fault - Possibly OK after restart

as1981 - Monday, October 2, 2017 2:33 PM
Hello,
Sorry, that wasn't intentional. I hadn't seen previous advice to disable SA so hadn't done...
--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)

October 2, 2017 at 4:38 pm

#1961970
RE: Are the posted questions getting worse?

jasona.work - Monday, October 2, 2017 1:22 PM
jonathan.crawford - Monday, October 2, 2017 12:58 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)

October 2, 2017 at 2:27 pm

#1961955
RE: sa password fault - Possibly OK after restart

as1981 - Monday, October 2, 2017 2:15 PM
Jeff: Thanks.
Chris: Sorry I didn't see the notification for your post. Thanks, that's the account...
--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)

October 2, 2017 at 2:25 pm

#1961954
RE: Since looping is bad, how should I accomplish what I am trying to do?

bmg002 - Monday, October 2, 2017 11:40 AM
Jeff Moden - Sunday, October 1, 2017 4: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)

October 2, 2017 at 2:19 pm

#1961953
RE: The Worms-eye View

David.Poole - Monday, October 2, 2017 8:33 AM
I think siloed thinking rather than over-specialization is the biggest threat.
+1000 to that. 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)

October 2, 2017 at 10:06 am

#1961907
RE: Since looping is bad, how should I accomplish what I am trying to do?

rmcfaden - Sunday, October 1, 2017 11:26 PM
Jeff,
First let me say thank you for taking the time to reply to my post....
--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)

October 2, 2017 at 8:13 am

#1961873
RE: select from flat file

MinhL7 - Sunday, October 1, 2017 8:32 PM
It's not a good file and I need to filter the insert. Can you select...
--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)

October 2, 2017 at 7:56 am

#1961866
RE: select from flat file

If your file is in good shape, then the following will work...
Create a staging table like this...

CREATE TABLE dbo.Test
(
Field1...
--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)

October 1, 2017 at 7:43 pm

#1961815
RE: Insert fails when trying to create a table.

newdba2017 - Wednesday, September 27, 2017 1:03 PM
Phil Parkin - Wednesday, September 27, 2017 12:27 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)

October 1, 2017 at 7:23 pm

#1961814
RE: Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

Jack 49290 - Thursday, March 30, 2017 3:45 PM
Can you please elaborate onQ1? Based on the chart at 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)

October 1, 2017 at 7:21 pm

#1961813
RE: Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

billh-508166 - Wednesday, September 27, 2017 1:04 PM
A CLR is a better solution when date validation is required.
Why would you think...
--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)

October 1, 2017 at 6:54 pm

#1961812

Viewing 15 posts - 14,206 through 14,220 (of 59,101 total)