Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,306 through 10,320 (of 59,095 total)

RE: Looping Through Data

Also, can you post the data in the readily consumable format that I pointed out in one of my previous posts above? I really don't have the time to mess...
--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 12:42 pm

#2016732
RE: Looping Through Data

irehman - Tuesday, December 18, 2018 10:45 AM
@Jeff Moden
Yes, thanks
You're welcome but you've...
--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 12:40 pm

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

Eric M Russell - Tuesday, December 18, 2018 12:13 PM
Jeff Moden - Tuesday, December 18, 2018 11:49...
--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 12:38 pm

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

Check for other dependencies on the table. I'm thinking that someone may have snuck in an indexed view or synonym on you. I can't imagine why it would cause 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)

December 18, 2018 at 12:34 pm

#2016727
RE: Validate date stored as a string as a complete, valid date

I'm not sure how you're populating your upstream table but, if you're using BCP or BULK INSERT, learn how to use the error parameters to simply sequester the rows with...
--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 12:26 pm

#2016725
RE: Run procedure without cursor or loop

valeryk2000 - Saturday, November 17, 2018 11:03 AM
Thanks. Good to know. We are upgrading to SQL Server 2016. I thik IIf 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)

December 18, 2018 at 12:19 pm

#2016723
RE: Text data type

HappyGeek - Wednesday, April 25, 2018 12:28 PM
Thom A - Wednesday, April 25, 2018 9:05 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)

December 18, 2018 at 12:17 pm

#2016722
RE: Calculate time difference between two related visitors without using cursor

CELKO - Monday, October 10, 2016 1:03 PM
From what I've experienced, a table in some sql dialects can lack a key...
--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 12:15 pm

#2016721
RE: The best way to load big chunks of rolling data

ChrisM@Work - Friday, April 20, 2018 9:48 AM
We had, until recently, a weekly load of around 50 million rows into a 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 12:00 pm

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

Eric M Russell - Tuesday, December 18, 2018 10:04 AM
I don't think we should shape and force a RDMS like SQL Server...
--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 11:49 am

#2016713
RE: Looking to downgrade our SQL Server editions from Enterprise to Standard Edition

asamykin - Tuesday, December 18, 2018 9:52 AM
Another option to do in-place downgrade without any new instances is to use registry keys
--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 10:34 am

#2016697
RE: PERCENTILE_DISC for median calculation

For anyone interested in the conversation on the other post, here's the link...
https://www.sqlservercentral.com/Forums/2013502/PERCENTILEDISC-for-median-calculation
--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 10:23 am

#2016693
RE: PERCENTILE_DISC for median calculation

valeryk2000 - Tuesday, December 18, 2018 8:41 AM
sgmunson - Monday, December 17, 2018 2:36 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 10:19 am

#2016690
RE: Looping Through Data

irehman - Tuesday, December 18, 2018 8:22 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)

December 18, 2018 at 10:14 am

#2016689
RE: Looping Through Data

p.s. I will give you a hint, though. If you have SQL Server 2012 or above, check out the LEAD and LAG keywords.
--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:12 am

#2016673

Viewing 15 posts - 10,306 through 10,320 (of 59,095 total)