Jeff Moden

Forum Replies Created

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

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
RE: Julian Date

jcelko212 32090 - Saturday, November 10, 2018 2:54 PM
irehman - Saturday, November 10, 2018 8:25 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)

November 10, 2018 at 9:37 pm

#2013113
RE: Julian Date

Ok... so nothing has changed much in the last couple of decades for this type of conversion. A trip through character based code to do such conversions is still 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 10, 2018 at 1:36 pm

#2013103
RE: Julian Date

irehman - Saturday, November 10, 2018 12:49 PM
Jeff Moden - Saturday, November 10, 2018 9:23 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)

November 10, 2018 at 1:24 pm

#2013101

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