Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,066 through 13,080 (of 59,095 total)

RE: Changing Extensions

manik_anu - Tuesday, January 23, 2018 12:28 AM
ildjarn.is.dead - Monday, January 22, 2018 6:48 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)

January 23, 2018 at 6:38 am

#1976888
RE: Question Regarding Date logic

drew.allen - Monday, January 22, 2018 2:27 PM
Note that it is NOT the beginning of the week.
"It Depends". Day 0 is...
--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)

January 22, 2018 at 7:19 pm

#1976850
RE: Question Regarding Date logic

below86 - Monday, January 22, 2018 12:49 PM
I would say using 0 to represent 01-01-1900 or -1 to mean 12-31-1899 is far...
--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)

January 22, 2018 at 7:07 pm

#1976849
RE: Changing Extensions

Bobby Russell - Monday, January 22, 2018 11:11 AM
Jeff Moden - Monday, January 22, 2018 10:59 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)

January 22, 2018 at 6:10 pm

#1976845
RE: Question Regarding Date logic

below86 - Monday, January 22, 2018 10:58 AM
In a follow up post KGJ-dev wanted to be able to pass any number of...
--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)

January 22, 2018 at 11:04 am

#1976769
RE: Changing Extensions

Bobby Russell - Monday, January 22, 2018 10:16 AM
Item 4 was my choice, which IS correct whether you think so or not, and...
--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)

January 22, 2018 at 10:59 am

#1976766
RE: Need to convert lowercase characters to 'a' and uppercase to 'A'

srikanthrv - Monday, January 22, 2018 8:38 AM
ThomasRushton - Monday, January 22, 2018 8:28 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)

January 22, 2018 at 9:07 am

#1976747
RE: Changing Extensions

George Vobr - Monday, January 22, 2018 7:59 AM
ildjarn.is.dead - Monday, January 22, 2018 6:48 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)

January 22, 2018 at 8:15 am

#1976730
RE: Need to convert lowercase characters to 'a' and uppercase to 'A'

drew.allen - Monday, January 22, 2018 7:38 AM
Jeff Moden - Friday, January 19, 2018 9:59 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)

January 22, 2018 at 8:12 am

#1976729
RE: Changing Extensions

ildjarn.is.dead - Monday, January 22, 2018 6:48 AM
Jeff Moden - Monday, January 22, 2018 5:44 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)

January 22, 2018 at 7:00 am

#1976715
RE: Ways to determine what increased the log file.

adilahmed1989 - Monday, January 22, 2018 2:37 AM
John Mitchell-245523 - Monday, January 22, 2018 2:16 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)

January 22, 2018 at 6:35 am

#1976710
RE: Shrink File by using empty file option

glugingboulder - Monday, May 10, 2010 5:57 PM
...some index fragmentation we can live.
While I'll be the first to agree with the fact...
--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)

January 22, 2018 at 6:05 am

#1976707
RE: Shrink File by using empty file option

glugingboulder - Monday, May 10, 2010 7:55 PM
not sure what you mean by system objects left in the *.mdfI can create 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)

January 22, 2018 at 5:59 am

#1976706
RE: Changing Extensions

ildjarn.is.dead - Monday, January 22, 2018 3:47 AM
The question isn't "What is the easiest way" but "what should I do". And adding...
--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)

January 22, 2018 at 5:44 am

#1976705
RE: Stored Procedure Dynamic SQL using sp_executesql Not working

Charles_P - Sunday, January 21, 2018 8:18 PM
Thank Jeff!
Using the text mode for
PRINT @ColumnsForCREATE;
PRINT @ColumnsForSELECT;
It clearly showed me that I was...
--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)

January 22, 2018 at 5:19 am

#1976702

Viewing 15 posts - 13,066 through 13,080 (of 59,095 total)