Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,561 through 7,575 (of 59,072 total)

Reply To: Restoring file group from one database to another

You might want to look into partitioning. If I had it to do over again (I had a similar requirement), I'd have used a Partitioned VIEW instead of a Partitioned...
--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)

March 12, 2020 at 10:24 pm

#3733815
Reply To: The Triple Update
Magnus Ahlkvist wrote:
This is fun code to test and try to get ones head around - in which orders are operators applied.
```
DECLARE @i INT=0;
UPDATE t SET @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)
March 12, 2020 at 9:54 pm

#3733804
Reply To: Gap Analysis Using Algebra

Ah... gotcha. Thanks, Glenn. I'll do my best over the weekend.
--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)

March 12, 2020 at 2:30 pm

#3733636
Reply To: Gap Analysis Using Algebra

Glen Cooper wrote:
A SQL Server solution to this problem, without using mathematics, would be very interesting. This was a real problem that I worked on, and I expected to do some...
--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)

March 12, 2020 at 4:41 am

#3733464
Reply To: Are the posted questions getting worse?

Ah... thanks. I totally missed the link.
--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)

March 12, 2020 at 1:24 am

#3733427
Reply To: Are the posted questions getting worse?

Thanks folks. Still looking to find out if AWS RDS will support the Developers Edition or not. I'd look for myself but I don't yet have access.

--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)

March 11, 2020 at 11:16 pm

#3733407
Reply To: Exploring the DATE Functions in SQL

ckredo wrote:
Just a quick comment re. DateAdd. I just got myself into trouble with a DateAdd function that was adding 1 year to 2/28/2019. The application was working with budgets...
--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)

March 11, 2020 at 11:14 pm

#3733406
Reply To: Are the posted questions getting worse?

Shifting gears a bit... does AWS RDS support the Developers Edition of SQL Server? Also, any idea if they support 2019 yet?
--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)

March 11, 2020 at 7:26 pm

#3733352
Reply To: extract all data with week

Ah... and in the absence of a more defining problem, given a year number, create one file per ISO week that contains all columns of each row in the week...
--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)

March 11, 2020 at 2:52 pm

#3733248
Reply To: extract all data with week

One of you folks that knows how to use SSIS should write an article on this... it would be a popular one because a lot of people need 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)

March 11, 2020 at 2:30 pm

#3733242
Reply To: Why Containers?
David.Poole wrote:
We have template Python projects so that the start of any Python development has a big head start
- Virtual environment build (venv)
- Test...
--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)
March 11, 2020 at 12:21 pm

#3733171
Reply To: Data Modeling in a New World

skeleton567 wrote:
Tom Uellner wrote:
This is even more challenging in medical. If you are a blood lab and run a panel of tests, some of them greatly depend on the birth sex...
--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)

March 11, 2020 at 1:03 am

#3733048
Reply To: Weird issue with data transfer to Oracle

cphite wrote:
Found the problem.... *sigh*
Our infrastructure team spun up a copy of our production environment, but forgot to update the firewall to prevent it from communicating outside itself. So 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)

March 10, 2020 at 6:59 pm

#3732974
Reply To: extract all data with week

Phil Parkin wrote:
Did 'he' say whether this is a one-off requirement, or something which will need to run periodically?
I can't help in SSIS but I try to code "one-offs" such as...
--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)

March 10, 2020 at 6:57 pm

#3732973
Reply To: Data Modeling in a New World

A bit of a sidebar... I cannot agree with changing the ISO spec. People who make the change all want to be identified by the gender they've chosen and 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)

March 10, 2020 at 6:51 pm

#3732972

Viewing 15 posts - 7,561 through 7,575 (of 59,072 total)