Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,416 through 11,430 (of 59,099 total)

RE: millions of users hitting our database

coolchaitu - Sunday, August 26, 2018 1:37 AM
Jeff Moden - Saturday, August 25, 2018 8:47 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)

August 26, 2018 at 7:19 am

#2003335
RE: Are the posted questions getting worse?

No need to pile on... I'm just venting a bit because I see this more and more and not just on this site.
Is it just me or do...
--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)

August 25, 2018 at 9:05 pm

#2003327
RE: millions of users hitting our database

coolchaitu - Friday, August 24, 2018 10:25 PM
Good Morning Experts,
There is a mega sale on a TV for 5 days, starting...
--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)

August 25, 2018 at 8:47 pm

#2003326
RE: PIVOT

TJ_T - Thursday, August 23, 2018 4:00 PM
Hi thanks,
hmmm â€¦ this looks rather complicated. I just need to make column into 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)

August 25, 2018 at 8:22 pm

#2003325
RE: Convert Varchar field

jcelko212 32090 - Friday, August 24, 2018 10:47 AM
Wouldn't it be a much better idea to get rid of these fractions,...
--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)

August 24, 2018 at 12:03 pm

#2003259
RE: PIVOT

TJ_T - Thursday, August 23, 2018 4:58 PM
This would work if I knew all of the CarTypes, but I don't. Any ideas?
Yes......
--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)

August 24, 2018 at 12:17 am

#2003148
RE: Count the Number of Weekend Days between Two Dates

@adam-2 Aspin,
Sorry, Adam... I do honestly appreciate anyone that will step up to bat with an article and share the knowledge they have and I thank you for...
--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)

August 23, 2018 at 10:47 pm

#2003146
RE: Count the Number of Weekend Days between Two Dates

MartJ - Thursday, August 23, 2018 6:51 AM
I wrote a little blog post on something similar as an example of using 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)

August 23, 2018 at 10:40 pm

#2003145
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, August 23, 2018 5:08 PM
Like it would last long enough us to notice. 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)

August 23, 2018 at 10:13 pm

#2003143
RE: Need help with renaming multiple tables

Jeff Moden - Thursday, August 23, 2018 10:09 PM
If you're going to use sp_rename to rename tables other than dbo (or whatever...
--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)

August 23, 2018 at 10:10 pm

#2003142
RE: Need help with renaming multiple tables

If you're going to use sp_rename to rename tables other than dbo (or whatever your default schema is), you must specify the schema name in the first operand of sp_rename...
--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)

August 23, 2018 at 10:09 pm

#2003141
RE: Count the Number of Weekend Days between Two Dates

carsten.saastamoinen - Thursday, August 23, 2018 9:54 AM
"Every bit helps avoid the "Death by 1,000 cuts" that so many systems experience. ...
--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)

August 23, 2018 at 9:49 pm

#2003140
RE: Count the Number of Weekend Days between Two Dates

My very first article on this site was about how to find work days (week days, really... no holidays involved). Figured I'd update from that a bit to solve this...
--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)

August 23, 2018 at 8:49 pm

#2003138
RE: Count the Number of Weekend Days between Two Dates

ScottPletcher - Thursday, August 23, 2018 4:24 PM
There's no need for any tally table nor recursion. A simple mathematical calc 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)

August 23, 2018 at 7:28 pm

#2003137
RE: Count the Number of Weekend Days between Two Dates

dbeggs57 - Thursday, August 23, 2018 6:01 PM
Jeff:
Thank you for correcting my code. This gives me something more to think about...
--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)

August 23, 2018 at 7:17 pm

#2003136

Viewing 15 posts - 11,416 through 11,430 (of 59,099 total)