Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,321 through 10,335 (of 59,095 total)

RE: Looping Through Data

irehman - Tuesday, December 18, 2018 7:52 AM

Hello, I'm new to SQL.
This is what I'm trying to do.
If Caller...
--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:11 am

#2016672
RE: Entity-Attribute-Value is evil ? how to avoid...

Eric M Russell - Tuesday, December 18, 2018 7:45 AM
Entity-Attribute-Value tables are good for modeling operational configuration data; things like configuration strings,...
--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:00 am

#2016670
RE: Visualise SQL Server IO Stats

It would be handy to people that read your article if you mentioned two additional pieces of information, especially since one of your steps is "download Power BI desktop"...
1. ...
--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:53 am

#2016667
RE: Issue with midnight in stored procedure

crmitchell - Tuesday, December 18, 2018 2:45 AM
Jeff Moden - Monday, December 17, 2018 3:45 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 7:43 am

#2016663
RE: Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

neil-560592 - Tuesday, December 18, 2018 6:46 AM
Instead of using CROSS JOIN you could instead use: INNER JOIN ON 1=1
or even: select...
--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:41 am

#2016662
RE: Entity-Attribute-Value is evil ? how to avoid...

aaron.reese - Tuesday, December 18, 2018 6:48 AM
EAVs can be a good way to scaffold an application until the users understand what...
--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:31 am

#2016659
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Tuesday, December 18, 2018 7:13 AM
Sorry .... which index should it be?
BTW, I can send you a chunk of data...
--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:26 am

#2016658
RE: Where did our 30GBs go?

Jonathan AC Roberts - Monday, December 17, 2018 7:37 PM
Jeff Moden - Monday, December 17, 2018 4:52...
--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 17, 2018 at 7:50 pm

#2016617
RE: The Number that shouldn't be a number

PHYData DBA - Thursday, December 13, 2018 9:07 AM
Eric M Russell - Thursday, December 13, 2018 7:47...
--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 17, 2018 at 7:06 pm

#2016615
RE: Monthly Report

CoryC - Monday, December 17, 2018 10:08 AM
I need to produce a monthly report on usage, uptime, and capacity. Any ideas 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)

December 17, 2018 at 5:32 pm

#2016612
RE: Find Next payment Date

ramrajan - Monday, December 10, 2018 6:38 PM
I have below table with columns date and Number of Payments and Next Payment Date...
--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 17, 2018 at 5:25 pm

#2016611
RE: PERCENTILE_DISC for median calculation

The OP actually made the mistake of posting their question in two separate posts. This question has been beat to death in the other post, which is located at the...
--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 17, 2018 at 5:20 pm

#2016610
RE: PIVOT operator is not allowed in the recursive part of a recursive common table expression

msimone - Monday, December 10, 2018 8:56 AM
Hello, i have a little problem.
I create an in lined table function and with SQL...
--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 17, 2018 at 5:16 pm

#2016609
RE: Where did our 30GBs go?

Here's what I think is the troublemaker for you...
[COMMENT] [varchar](7000) NULL,
Large comments like that...
--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 17, 2018 at 4:52 pm

#2016608
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Monday, December 17, 2018 12:28 PM
Tried Offset/Fetch - works slower than Percentile ...
Do you have the correct index in place to...
--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 17, 2018 at 3:48 pm

#2016602

Viewing 15 posts - 10,321 through 10,335 (of 59,095 total)