Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,291 through 10,305 (of 59,099 total)

RE: PERCENTILE_DISC for median calculation

Not sure what the view is used for but what you posted appears to have been truncated. There's no FROM clause.
--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)

December 19, 2018 at 10:06 am

#2016851
RE: Text data type

sgmunson - Wednesday, December 19, 2018 9:19 AM
Jeff Moden - Tuesday, December 18, 2018 12: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)

December 19, 2018 at 9:37 am

#2016842
RE: Decode waits on Object resource

tttcoding - Wednesday, December 19, 2018 3:21 AM
Jeff Moden - Tuesday, December 18, 2018 1:02 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)

December 19, 2018 at 9:23 am

#2016838
RE: PERCENTILE_DISC for median calculation

Ah... OK. What is the clustered index on the table and, if present, what are the non-clustered indexes? I'm assuming, of course, that this table has a whole lot 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)

December 19, 2018 at 9:09 am

#2016834
RE: Find the root cause of SQL Server slowness and possibly killing blockers automatically

Sridhar-137443 - Tuesday, December 18, 2018 6:25 PM
Thank you, Jeff. I am trying to understand what causes the server to be unresponsive....
--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)

December 19, 2018 at 9:06 am

#2016832
RE: Error: Cannot insert duplicate key row in... a non-unique index?!

I have to admit that I've not seen the likes of this problem before without some trigger, indexed view, or audit system in place. Looking at the code and discounting...
--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)

December 19, 2018 at 8:52 am

#2016830
RE: PERCENTILE_DISC for median calculation

Which column are you taking the Median 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)

December 19, 2018 at 8:47 am

#2016829
RE: Visualise SQL Server IO Stats

Ah... and forgive my manners. I also meant to say this was a good article that got some good ol' fashioned thinking juices flowing. Nicely done!
--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)

December 18, 2018 at 8:37 pm

#2016781
RE: TOP vs Max/Min: Is there a difference?

Mike Byrd - Monday, December 17, 2018 9:47 AM
Wow, didn't know the article was going to generate a fire-storm on TSQL syntax. ...
--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)

December 18, 2018 at 8:34 pm

#2016780
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Tuesday, December 18, 2018 8:12 PM
Jeff Moden - Tuesday, December 18, 2018 7:55 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)

December 18, 2018 at 8:21 pm

#2016779
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Tuesday, December 18, 2018 8:09 PM
Jeff Moden - Tuesday, December 18, 2018 7:59 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)

December 18, 2018 at 8:20 pm

#2016778
RE: Looping Through Data

irehman - Tuesday, December 18, 2018 7:58 PM
@Jeff Moden
Yes, I miss-typed <= 5 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)

December 18, 2018 at 8:01 pm

#2016775
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Tuesday, December 18, 2018 11:00 AM
Jeff
what does 'v' means in this code?
... SELECT SomeInt,SomeDecimal
...
--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)

December 18, 2018 at 7:59 pm

#2016774
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Tuesday, December 18, 2018 10:43 AM
Jeff I created the script - it is 17 Mb - 45 000 records, table...
--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)

December 18, 2018 at 7:55 pm

#2016772
RE: Looping Through Data

irehman - Tuesday, December 18, 2018 12:58 PM
@Jeff Moden
Should be <=5 and >=5
Create table...
--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)

December 18, 2018 at 7:48 pm

#2016771

Viewing 15 posts - 10,291 through 10,305 (of 59,099 total)