Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,876 through 10,890 (of 59,102 total)

RE: How to store output of SQL Server Stored Procedure in a .txt file

vikasjagadale8 - Sunday, October 21, 2018 9:59 AM
I have below SP I am printing the value of the variable in S.S.M.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)

October 21, 2018 at 1:14 pm

#2010521
RE: Anyone see a problem with this?

Sergiy,
Just so you know, please see the following.
https://www.sqlservercentral.com/Forums/FindPost2003341.aspx
--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 21, 2018 at 11:18 am

#2010520
RE: Display 'blank' cell when it is null.

keneangbu - Friday, October 19, 2018 2:03 PM
The data type of the column is decimal(9,2). I wanted an empty cell 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)

October 20, 2018 at 6:51 pm

#2010509
RE: Display 'blank' cell when it is null.

jcelko212 32090 - Friday, October 19, 2018 7:35 PM
keneangbu - Friday, October 19, 2018 2:03 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 20, 2018 at 6:41 pm

#2010508
RE: Naming Conventions for SQL Server Objects

As for the CMS standards that you provided a link to... there's some good advice here and there in it but, for the most part, BLEAH! Imagine using Hungarian Notation...
--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 20, 2018 at 1:32 pm

#2010504
RE: Naming Conventions for SQL Server Objects

Heh... maybe "Capitialize() instead of the past tense "capitalized". I also hate the use of all upper case or all lower case for user defined object names, especially in this...
--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 20, 2018 at 1:08 pm

#2010502
RE: A $3 Billion Donation

Jonathan AC Roberts - Friday, October 19, 2018 4:21 AM
Jeff Moden - Thursday, October 18, 2018 9:32...
--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 19, 2018 at 7:43 am

#2010428
RE: Can anyone suggest a SQL Server Advanced course?

Data Cruncher - Friday, October 19, 2018 1:53 AM
allan.ford17 - Thursday, October 18, 2018 5:10 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 19, 2018 at 7:41 am

#2010426
RE: Same Execution Plan different stats

anvegger - Friday, October 19, 2018 7:16 AM
BTW that INDEX hint along with an INDEX itself did not change execution plan 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)

October 19, 2018 at 7:34 am

#2010423
RE: Find and replace third occurrence of the string

saravanatn - Thursday, October 18, 2018 8:33 PM
ScottPletcher - Thursday, October 18, 2018 2:25 PM
I...
--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 18, 2018 at 8:44 pm

#2010351
RE: Same Execution Plan different stats

Jack Corbett - Thursday, October 18, 2018 7:30 PM
I know you have said you updates stats, but did you do...
--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 18, 2018 at 8:14 pm

#2010346
RE: Same Execution Plan different stats

anvegger - Thursday, October 18, 2018 6:30 PM
Jeff Moden - Thursday, October 18, 2018 5:53 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 18, 2018 at 6:54 pm

#2010342
RE: Same Execution Plan different stats

anvegger - Thursday, October 18, 2018 4:33 PM
That would of been my thought as well but unfortunately I don't see that right...
--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 18, 2018 at 5:53 pm

#2010335
RE: Same Execution Plan different stats

anvegger - Thursday, October 18, 2018 3:06 PM
Let me re-iterate the issue:
1. I have the same INSTANCE running on the virtual box
2....
--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 18, 2018 at 4:06 pm

#2010322
RE: Find and replace third occurrence of the string

ScottPletcher - Thursday, October 18, 2018 2:25 PM
I suggest starting with your actual solution, not listing things you would not do first. ...
--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 18, 2018 at 4:01 pm

#2010321

Viewing 15 posts - 10,876 through 10,890 (of 59,102 total)