Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,316 through 12,330 (of 59,095 total)

RE: Is there a maximum number of joins allowed in SQL 2016?

jcelko212 32090 - Thursday, May 17, 2018 7:01 PM
sgmunson - Thursday, May 17, 2018 2:56 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)

May 18, 2018 at 5:44 am

#1990972
RE: Change formatting of SSMS generated code

andrew gothard - Friday, May 18, 2018 4:30 AM
Hi all,
not exactly the most pressing query ever, but after all these years...
--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)

May 18, 2018 at 5:40 am

#1990971
RE: Change formatting of SSMS generated code

There are tons of mostly free online resources for this. Some are better than the others when it comes to complex stuff. Please see the following Google Search.
--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)

May 18, 2018 at 5:24 am

#1990967
RE: Are the posted questions getting worse?

Good lord! Have you seen the spam tonight? It has affected all of the top 5 or 6 forums on this site and there's 40 to 50 on each forum. ...
--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)

May 17, 2018 at 9:43 pm

#1990953
RE: Interviewing Avatars

Frank W Fulton Jr - Thursday, May 17, 2018 3:31 PM
I think a "Steve" avatar would be great! ...
--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)

May 17, 2018 at 5:07 pm

#1990947
RE: Preserving the total field lenght

paulo.margarido - Thursday, May 17, 2018 5:34 AM
i just realize this post has 4 years ...
It's ok. Always good to have more...
--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)

May 17, 2018 at 4:30 pm

#1990941
RE: The SQL Saturday Thread

Lynn Pettis - Thursday, May 17, 2018 12:50 PM
Ray K - Thursday, May 17, 2018 12:19 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)

May 17, 2018 at 3:12 pm

#1990936
RE: Send Mail to Particular Mail id if Any employer of the organisation has Birthday on daily basis

Beatrix Kiddo - Thursday, May 17, 2018 8:07 AM
sunilchand - Wednesday, May 16, 2018 11:17 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)

May 17, 2018 at 8:46 am

#1990857
RE: Query taking more time

ChrisM@Work - Thursday, May 17, 2018 8:22 AM
Jeff Moden - Thursday, May 17, 2018 7:57 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)

May 17, 2018 at 8:33 am

#1990850
RE: Send Mail to Particular Mail id if Any employer of the organisation has Birthday on daily basis

jonathan.crawford - Thursday, May 17, 2018 7:56 AM
sunilchand - Thursday, May 17, 2018 12:27 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)

May 17, 2018 at 8:14 am

#1990840
RE: Send Mail to Particular Mail id if Any employer of the organisation has Birthday on daily basis

sunilchand - Wednesday, May 16, 2018 11:17 PM
ThomasRushton - Wednesday, May 16, 2018 6:54 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)

May 17, 2018 at 8:12 am

#1990839
RE: Export data in XML to import into Word

Matt Simmons - Tuesday, May 2, 2017 2:31 PM
Kev, Why not connect directly to SQL via Word as several others have...
--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)

May 17, 2018 at 8:03 am

#1990835
RE: Query taking more time

ChrisM@Work - Thursday, May 17, 2018 2:15 AM
haichells - Wednesday, May 16, 2018 10:31 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)

May 17, 2018 at 7:57 am

#1990834
RE: Cannot Open Database "xxx" requested by login. Login failed

clearlymichele - Wednesday, May 16, 2018 2:16 PM
Antares686 - Wednesday, March 28, 2007 10:06 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)

May 16, 2018 at 6:35 pm

#1990752
RE: Send Mail to Particular Mail id if Any employer of the organisation has Birthday on daily basis

Beatrix Kiddo - Wednesday, May 16, 2018 9:22 AM
Agreed. Also I would HATE to get an insincere card or email from...
--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)

May 16, 2018 at 6:30 pm

#1990751

Viewing 15 posts - 12,316 through 12,330 (of 59,095 total)