Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,636 through 10,650 (of 59,102 total)

RE: Are the posted questions getting worse?

Lynn Pettis - Sunday, November 11, 2018 5:16 PM
I started putting brackets out of self defense, especially in my dynamic SQL...
--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)

November 12, 2018 at 5:24 am

#2013194
RE: Placing data file , log file and temp file in 1 drive or separate drive ?

For the sake of "management purposes", people will have the SAN guy set up different "drive letters" so they can more easily keep track of their data files, log files,...
--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)

November 11, 2018 at 6:59 pm

#2013176
RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table

p.s. SSIS, SSRS, SSAS, SSSB.... those are all "four letter words" to me. 😀
--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)

November 11, 2018 at 6:50 pm

#2013175
RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table

VoldemarG - Sunday, November 11, 2018 6:16 PM
its only because this way it ieasier to output all text fields to text file...
--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)

November 11, 2018 at 6:47 pm

#2013173
RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table

pietlinden - Sunday, November 11, 2018 3:25 PM
Why are you VARCHAR columns and then storing numbers in them? Why is a...
--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)

November 11, 2018 at 5:32 pm

#2013164
RE: Placing data file , log file and temp file in 1 drive or separate drive ?

Everyone says that they're supposed to be on "separate drives". If these things are on a SAN, you'll have a bunch of "logical drives" and there's absolutely no guarantee that...
--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)

November 11, 2018 at 5:21 pm

#2013161
RE: SELECT TOP 1 on Primary Key?

AdrianLParker+sqlservercentral.com - Sunday, November 11, 2018 3:15 PM
Jeff Moden - Sunday, November 11, 2018 1:43 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)

November 11, 2018 at 3:46 pm

#2013154
RE: Column names on INNER JOINS

ANSI/ISO standards have absolutely nothing to do with how to post a question. They also frequently don't have much to do with high performance code because, if you follow them,...
--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)

November 11, 2018 at 1:59 pm

#2013144
RE: SELECT TOP 1 on Primary Key?

AdrianLParker+sqlservercentral.com - Friday, November 9, 2018 10:12 AM
The MSDN says of OPTIONA (FAST X):
Specifies that the query is optimized for fast retrieval...
--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)

November 11, 2018 at 1:43 pm

#2013143
RE: Are the posted questions getting worse?

Michael L John - Sunday, November 11, 2018 12:37 PM
About 5 miles. We finished just under 22 hours after we started. ...
--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)

November 11, 2018 at 1:26 pm

#2013141
RE: Julian Date

p.s. And sorry about the mess the forum software made with the code and the results. I posted it the same way I did in similar posts above but it...
--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)

November 11, 2018 at 8:52 am

#2013121
RE: Julian Date

Jeff Moden - Saturday, November 10, 2018 9:41 PM
frederico_fonseca - Saturday, November 10, 2018 2:06 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)

November 11, 2018 at 8:50 am

#2013120
RE: Are the posted questions getting worse?

Michael L John - Saturday, November 10, 2018 2:43 PM
We started moving our data center last night at 3 am. 12 racks...
--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)

November 10, 2018 at 10:00 pm

#2013116
RE: Julian Date

irehman - Saturday, November 10, 2018 1:32 PM
Jeff Moden - Saturday, November 10, 2018 1:24 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)

November 10, 2018 at 9:44 pm

#2013115
RE: Julian Date

frederico_fonseca - Saturday, November 10, 2018 2:06 PM
similar results for me
As the results I had given before only related to the date...
--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)

November 10, 2018 at 9:41 pm

#2013114

Viewing 15 posts - 10,636 through 10,650 (of 59,102 total)