Jeff Moden

Forum Replies Created

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

RE: simple select * from table takes around 15 secons

Jeffrey Williams 3188 - Friday, May 18, 2018 11:48 AM
ScottPletcher - Friday, May 18, 2018 11:09 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 18, 2018 at 11:52 am

#1991050
RE: simple select * from table takes around 15 secons

ScottPletcher - Friday, May 18, 2018 11:09 AM
Still seems too long for only 76K rows.
1) Check fragmentation on the clus index. If...
--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 11:51 am

#1991049
RE: Change formatting of SSMS generated code

Lynn Pettis - Friday, May 18, 2018 7:37 AM
"River" format? Never heard of it...
Most people have never heard of the "River"...
--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 8:16 am

#1990997
RE: Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

I didn't do a deep dive on this older article but I do disable indexes not only for deletes but also for index maintenance. It's a good article to explain...
--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 7:00 am

#1990984
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

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