Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,461 through 14,475 (of 59,097 total)

RE: Are the posted questions getting worse?

GilaMonster - Saturday, September 2, 2017 12:55 AM
Steve Jones - SSC Editor - Friday, September 1, 2017...
--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)

September 2, 2017 at 12:03 pm

#1957932
RE: Database Development Made Easy?

miapjp - Friday, September 1, 2017 4:07 PM
Back a few years ago, we had very OO developers, who'd never seen a stored...
--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)

September 2, 2017 at 12:01 pm

#1957931
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

muhammadaftab25 - Saturday, September 2, 2017 11:27 AM
Hi Jeff & Chris. From the query posted by Chris, we noticed that there 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)

September 2, 2017 at 11:55 am

#1957930
RE: date fillers - dates in two rows

ekant_alone - Friday, September 1, 2017 7:52 AM
Brilliant! Wow!! wowwww! Jason, Steve, Drew, and Jeff - THANK YOU ALL........ I...
--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)

September 2, 2017 at 11:45 am

#1957929
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

Eirikur Eiriksson - Saturday, September 2, 2017 3:38 AM
muhammadaftab25 - Saturday, September 2, 2017 12:01 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)

September 2, 2017 at 11:30 am

#1957927
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

p.s. CPU usage and Duration in the output of sp_WhatsRunning is in decimal seconds, just to make life a little easier. It also identifies if any blocking is going on,...
--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)

September 2, 2017 at 11:12 am

#1957925
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

muhammadaftab25 - Saturday, September 2, 2017 12:01 AM
Jeff Moden - Friday, September 1, 2017 9:00 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)

September 2, 2017 at 11:10 am

#1957924
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

Hold the phone a minute... the original post says that the problem occurs every 5-6 minutes. I've found that wait stats are normally a symptom rather than a cause. Someone...
--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)

September 1, 2017 at 9:00 am

#1957846
RE: date fillers - dates in two rows

Jason A. Long - Thursday, August 31, 2017 9:36 PM
Jeff Moden - Thursday, August 31, 2017 8:33...
--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)

September 1, 2017 at 8:19 am

#1957841
RE: date fillers - dates in two rows

drew.allen - Thursday, August 31, 2017 10:02 AM
First, sample data should be provided as an INSERT statement into your sample table.
The solution...
--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)

September 1, 2017 at 8:15 am

#1957840
RE: date fillers - dates in two rows

ekant_alone - Friday, September 1, 2017 7:52 AM
Brilliant! Wow!! wowwww! Jason, Steve, Drew, and Jeff - THANK YOU ALL........ I...
--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)

September 1, 2017 at 8:10 am

#1957837
RE: Update Statistics..

Arsh - Friday, September 1, 2017 5:40 AM
GilaMonster - Thursday, August 31, 2017 1: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)

September 1, 2017 at 6:55 am

#1957818
RE: First / last item of a string in a nvarchar field

Mike Good - Friday, September 1, 2017 5:53 AM
Doh. That would be the Luis...
--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)

September 1, 2017 at 6:38 am

#1957814
RE: date fillers - dates in two rows

Jason A. Long - Thursday, August 31, 2017 6:40 PM
ekant_alone - Thursday, August 31, 2017 4:07 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 31, 2017 at 8:33 pm

#1957775
RE: date fillers - dates in two rows

ekant_alone - Thursday, August 31, 2017 4:07 PM
yes i am allowed to. But i am confused how i can help my case...
--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 31, 2017 at 8:24 pm

#1957773

Viewing 15 posts - 14,461 through 14,475 (of 59,097 total)