Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,336 through 16,350 (of 59,101 total)

RE: Inline table-valued function to list numbers

Shifting gears a bit, ROW_NUMBER() OVER is relatively expensive. The same DRY (Don't Repeat Yourself) principles that folks use in front end code also apply to T-SQL. It...
--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)

November 13, 2016 at 3:24 pm

#1912125
RE: Inline table-valued function to list numbers

TheTrojan (11/13/2016)
@mister.magoo You will be happy to know that your solution is slightly faster than mine! Have a look at the times:
-- if the parameter is 1000: 76 ms (instead...
--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)

November 13, 2016 at 2:23 pm

#1912124
RE: Copy/Insert Data to another table with different number of columns

Again, just to emphasize, this whole design of the originally stated problem, I wouldn't create either table in the current "horizontal" format. I'd make them both vertical and I'd...
--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)

November 13, 2016 at 9:59 am

#1912114
RE: Copy/Insert Data to another table with different number of columns

To be honest, this is a train wreck that happens every time that you bring new data in because you have to add columns to the [dbo].[namer_wf_test] table every time...
--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)

November 13, 2016 at 9:37 am

#1912113
RE: Go Code

David.Poole (11/13/2016)
I look back in my career having known individuals who were 100% right about what they were saying and were years ahead of their time but because they couldn't...
--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)

November 13, 2016 at 8:31 am

#1912110
RE: Are the posted questions getting worse?

GilaMonster (11/13/2016)
Ed Wagner (11/12/2016)
I just hid a bunch
How???
I'm sick of just reporting them and having the spam hang around for hours afterwards
Ask Steve to give you the privs to 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)

November 13, 2016 at 7:52 am

#1912109
RE: Embedded Text Qualifier Bug

Aubrey-314204 (11/11/2016)
Recently we migrated from SQL 2008 to 2014. I have come across an error that only is happening on the 2014 environment, but working successfully in 2008. ...
--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)

November 12, 2016 at 6:18 pm

#1912095
RE: Copy/Insert Data to another table with different number of columns

tocy1980 (11/12/2016)
Hello guys,
This would be me example. I have some query and my final table looks like:
|Country|Region|Mark|RW|December 26, 2015|January 2, 2016|January 9, 2016|... etc.
Also I have and second table where...
--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)

November 12, 2016 at 6:13 pm

#1912093
RE: Today's Random Word!

TomThomson (11/12/2016)
Luis Cazares (11/11/2016)
djj (11/11/2016)
Ed Wagner (11/11/2016)
Revenant (11/11/2016)
Hope
Faith
Charity
goodwill
Benevolence
Philanthropic
--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)

November 12, 2016 at 6:07 pm

#1912092
RE: Benefits of SQL 2014/2016 over 2005 ??

Luis Cazares (11/10/2016)
Eirikur Eiriksson (11/10/2016)
homebrew01 (11/10/2016)
Eirikur Eiriksson (11/10/2016)
Think this is the wrong question, should be "what are the justifications for running an unsupported version of SQL Server"
😎
Doesn't cost any money...
--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)

November 12, 2016 at 3:33 pm

#1912083
RE: Are the posted questions getting worse?

Eirikur Eiriksson (11/12/2016)
What a spamtastic Saturday morning:pinch:
😎
Indeed it has been. I've personally hidden about 100 spam posts in the last 4 to 5 hours. The bots are having...
--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)

November 12, 2016 at 11:37 am

#1912071
RE: Are the posted questions getting worse?

Brandie Tarvin (11/11/2016)
Jeff Moden (11/10/2016)
Lynn Pettis (11/10/2016)
Jeff Moden (11/9/2016)
Lynn Pettis (11/9/2016)
Jeff, I actually excepted you to have some interesting comments about the code I emailed you, or didn't you get...
--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)

November 12, 2016 at 11:33 am

#1912070
RE: Good to have Multiple Data Warehouses?

To wit, I frequently go with the "no data warehouse" option in favor of just writing some streamlined code to solve actual problems instead of a system to handle all...
--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)

November 12, 2016 at 11:26 am

#1912068
RE: Trace value in stored proc

weiran1982 (11/12/2016)
Hi guys,
I'm new to SQL and need a bit help here. I'm troubleshooting an application (no source code). I set up SQL profiler and captured RPC call something like...
--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)

November 12, 2016 at 11:22 am

#1912067
RE: Understanding from .. from

Edvard Korsbæk (11/12/2016)
Now i just need to understand, why you use so much time om me....:-)
You've already answered that question. 😀
Edvard Korsbæk (11/12/2016)
This makes sense, and makes my 'Deletes' much...
--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)

November 12, 2016 at 11:15 am

#1912066

Viewing 15 posts - 16,336 through 16,350 (of 59,101 total)